Design & Install Analysis Services

SQL Server 2014    |    Intermediate
  • 12 videos | 1h 3m 56s
  • Includes Assessment
  • Earns a Badge
Likes 24 Likes 24
SQL Server Analysis Services (SSAS) lets you use different models to analyze large amounts of data. Explore the benefits each model provides, and how to install and configure SSAS.

WHAT YOU WILL LEARN

  • explain the functionality OLAP and data mining provide for business intelligence
    explain the functionality tabular mode provides for business intelligence
    explain the functionality of SQL Server BI features with SharePoint, including PowerPivot
    identify the different BI features to install based on a scenario
    identify the appropriate data model to use for data analysis
    identify the development and production considerations for install SSAS
  • install SSAS in multidimensional mode
    install SSAS in Tabular mode
    install PowerPivot for SharePoint with use in SSAS
    upgrade an SSAS instance
    update an SSAS instance
    configure server and database level security for an SSAS instance

IN THIS COURSE

  • 9m 10s
    After completing this video, you will be able to explain the functionality OLAP and data mining provide for business intelligence. FREE ACCESS
  • 5m 21s
    After completing this video, you will be able to explain the functionality tabular mode provides for business intelligence. FREE ACCESS
  • Locked
    3.  Overview of BI Features with SharePoint
    5m 46s
    After completing this video, you will be able to explain the functionality of SQL Server BI features with SharePoint, including PowerPivot. FREE ACCESS
  • Locked
    4.  SQL Server BI Scenarios and SharePoint
    5m 15s
    In this video, you will learn how to identify the different business intelligence features to install based on a scenario. FREE ACCESS
  • Locked
    5.  Identify the Correct Model for Data Analysis
    4m 15s
    Learn how to identify the appropriate data model to use for data analysis. FREE ACCESS
  • Locked
    6.  Identify the Development and Production Considerations
    5m 49s
    In this video, you will learn how to identify the development and production considerations for installing SSAS. FREE ACCESS
  • Locked
    7.  Installing SSAS in Multidimensional Mode
    4m 52s
    During this video, you will learn how to install SSAS in multidimensional mode. FREE ACCESS
  • Locked
    8.  Installing SSAS in Tabular Mode
    4m 20s
    Find out how to install SSAS in Tabular mode. FREE ACCESS
  • Locked
    9.  Installing SQL Server PowerPivot for SharePoint
    4m 36s
    In this video, find out how to install PowerPivot for SharePoint with SSAS. FREE ACCESS
  • Locked
    10.  Upgrading an SSAS Instance
    5m 37s
    Learn how to upgrade a SSAS instance. FREE ACCESS
  • Locked
    11.  Updating an SSAS Instance
    3m 6s
    Learn how to update an SSAS instance. FREE ACCESS
  • Locked
    12.  Configuring Security for an SSAS Instance
    5m 50s
    In this video, you will configure server and database level security for an SSAS instance. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Microsoft Azure Infrastructure Solutions: Data Solutions
Book SAP S/4HANA Embedded Analytics: The Comprehensive Guide, 2nd Edition, Updated and Revised 2021
Book Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Flow Implementation & ETL
Likes 56 Likes 56  
Course SSIS Package Execution & Script Tasks
Likes 15 Likes 15  
Course Business Reporting: Visualizing & Merging Data in Power BI
Likes 456 Likes 456