Design & Install Analysis Services

SQL Server 2014
  • 12 Videos | 1h 8m 26s
  • Includes Assessment
  • Earns a Badge
Likes 11 Likes 11
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

  • Playable
    1. 
    Overview of the Multidimensional and Data Mining Mode
    9m 10s
    UP NEXT
  • Playable
    2. 
    Overview of Tabular Mode
    5m 21s
  • Locked
    3. 
    Overview of BI Features with SharePoint
    5m 46s
  • Locked
    4. 
    SQL Server BI Scenarios and SharePoint
    5m 15s
  • Locked
    5. 
    Identify the Correct Model for Data Analysis
    4m 15s
  • Locked
    6. 
    Identify the Development and Production Considerations
    5m 49s
  • Locked
    7. 
    Installing SSAS in Multidimensional Mode
    4m 52s
  • Locked
    8. 
    Installing SSAS in Tabular Mode
    4m 20s
  • Locked
    9. 
    Installing SQL Server PowerPivot for SharePoint
    4m 36s
  • Locked
    10. 
    Upgrading an SSAS Instance
    5m 37s
  • Locked
    11. 
    Updating an SSAS Instance
    3m 6s
  • Locked
    12. 
    Configuring Security for an SSAS Instance
    5m 50s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 8 Likes 8  
Likes 7 Likes 7  
Likes 8 Likes 8  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 152 Likes 152  
Likes 20 Likes 20  
Likes 141 Likes 141