Advanced DAX


What Will You Learn?

  • To have the ability to significantly enhance the analytical value of data models with DAX calculations
  • To develop a strong understanding of advanced DAX concepts and learn to think like DAX
  • To understand when and how to use the more advanced DAX functions


The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the ‘why’ behind how calculations work.



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 basic understanding of how to create calculated columns and measures, ideally completion of Pragmatic Works’ Introduction to DAX course. The target audience of this course is for power users who are familiar with DAX, but want to take their skills to the next level.

Curriculum For This Course

System Requirements

  • Windows 7, Windows 8 or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • Power BI Desktop – http://tinyurl.com/PowerBIDesktop
  • **Optional** SQL Server Analysis Services Tabular

You may also like…