Introduction to SSAS Tabular


What Will You Learn?

  • How to use Power Pivot and create tabular data models
  • How to create calculated columns and calculated measures with DAX
  • Managing and securing Tabular models
  • Use advanced data analysis to gain insight from your business data


Introduction to SSAS Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying Tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.



BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.


What to Know Before the Class

A background in database development is required, but no previous knowledge of PowerPivot, DAX, or SQL Data Tools is assumed. Some experience using pivot tables and formulas in Excel may be helpful, but is not required.

Curriculum For This Course

System Requirements

  • 2 GB of available RAM (recommended 4 GB or more)
  • GHz CPU (recommended 2 GHz or faster)
  • Windows 7, Windows 8 or Windows 10
  • SQL Server Developer Edition or Enterprise Edition 2012/2014/2016
  • Excel 2010 or greater

You may also like…