Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

DeepDive Analysis Services - Building Models in SQL Server Analysis Services Tabular Model

Tune SQL Server Analysis Services in tabular mode and experience the difference!

}

Duration: 8 hours

 

Level: 300

 

What does this course cover?

Building a proper data model for SSAS Tabular is crucial for the functionality and from a performance point of view. SSAS Tabular doesn’t have the same features as SSAS multidimensional. We are working with tables instead of dimensions; we have calculated columns and calculated measures; new language for defining measures (DAX) etc.

Pre-requisites: What do you need to know?

Experience with SQL Server Analysis Services

“Very interesting insights in SSAS in tabular mode!”

Jens Stoever

Business Analyst, Hamburg

Course outline

Creating a BISM End-to-End: Understanding the Process

  • SQL Server Data Tools for BI development
  • The SSAS development process
  • Define data sources
  • Develop the model (multidimensional vs. tabular)
  • Deployment and processing
  • Maintenance

Building Models

  • Models
  • Tables
  • Calculated columns
  • Calculated measures

Advanced Features

  • Hierarchies
  • DAX and calculated members
  • Key Performance Indicators
  • Perspectives
  • Reporting properties for enhanced end-user experience

All our courses can be offered as a private delivery and tailored for your team's specific needs