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

WHEN and WHERE is this course running?

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

WHEN and WHERE is this course running next?