Design & Install Analysis Services

SQL Server 2014    |    Intermediate
  • 12 Videos | 1h 3m 56s
  • Includes Assessment
  • Earns a Badge
Likes 18 Likes 18
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
    FREE ACCESS
  • Locked
    4. 
    SQL Server BI Scenarios and SharePoint
    5m 15s
    FREE ACCESS
  • Locked
    5. 
    Identify the Correct Model for Data Analysis
    4m 15s
    FREE ACCESS
  • Locked
    6. 
    Identify the Development and Production Considerations
    5m 49s
    FREE ACCESS
  • Locked
    7. 
    Installing SSAS in Multidimensional Mode
    4m 52s
    FREE ACCESS
  • Locked
    8. 
    Installing SSAS in Tabular Mode
    4m 20s
    FREE ACCESS
  • Locked
    9. 
    Installing SQL Server PowerPivot for SharePoint
    4m 36s
    FREE ACCESS
  • Locked
    10. 
    Upgrading an SSAS Instance
    5m 37s
    FREE ACCESS
  • Locked
    11. 
    Updating an SSAS Instance
    3m 6s
    FREE ACCESS
  • Locked
    12. 
    Configuring Security for an SSAS Instance
    5m 50s
    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 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

BOOK Getting Started with SAS(r) Programming: Using SAS(r) Studio in the Cloud
BOOK Insightful Data Visualization with SAS Viya
BOOK Introducing the New Model in SAP Analytics Cloud

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
COURSE Advanced SQL Queries
Likes 209 Likes 209  
COURSE Concepts & Conceptual Design
Likes 298 Likes 298