• Enrollment system is currently unavailable. We apologize for the inconvenience.┬áPlease try again later.

SQL Server Tabular Modeling and Power Pivot

Tabular models are in-memory databases that develop models using imported data from underlying data sources, while designing objects that organize, enhance, and secure the data. Learn to use compression algorithms and multithreaded query processing to deliver fast access to tabular model objects and data through reporting client applications in Microsoft Excel. This course combines lectures with hands-on training in a lab setting, where every participant has a dedicated computer with its own hard drive. Build upon what you learn week to week in lab exercises, beginning with the basics of tabular modeling, then connecting to various data sources, and finally progressing to Power Pivot for Excel. After creating a tabular BI semantic model, move on to advanced features, such as parent-child relationships, partitions, perspectives, and DAX functions, ending with self-service BI modeling.

More details

You'll Walk Away with

  • An understanding of how to create a new tabular model project in SQL Server Data Tools
  • The ability to import data from a SQL Server relational database into a tabular model project
  • The experience of having created and managed relationships between tables in a model

Ideal for

  • Anyone interested in implementing reporting solutions using SQL Server Reporting Services
  • Experienced SQL users who seek to implement multidimensional databases using SQL Server Analysis Services
  • Those who want to create tabular semantic data models for analysis using SQL Server Analysis Services

1 section