Data Academy Course

Advanced Power BI: Mastering DAX (self-paced) [OPEN]

About this course

The goal of this video course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. You can watch the videos at anytime and the system will keep track of your progress. Within the course you can download the material for all the exercises. The course is provided through the SQLBI online portal and made available by DataSF.

Length: The course is fully self-paced and online. It includes over 15 hours of recorded lectures, plus another 15-20 hours of individual exercises. You will have access to this course for two weeks.

What you’ll learn in this course

  • Introduction to DAX
  • Evaluation contexts
  • The CALCULATE function
  • Advanced evaluation contexts
  • Iterators
  • Building a date table
  • Time intelligence in DAX
  • Hierarchies in DAX
  • Querying with DAX
  • Date lineage and TREATAS
  • Expanded tables
  • Arbitrarily shaped filters
  • ALLSELECTED and shadow filter contexts
  • Segmentation
  • Many-to-many relationships
  • Ambiguity and bidirectional filters
  • Relationships at different granularities
  • Calculation groups


Note: this is an advanced course and is geared towards Power BI users who are already familiar with intermediate topics such as data modeling and basic DAX expressions or familiarity with other coding/ programmatic languages (i.e. R, Python, SQL).

The course is aimed at power users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.

Completion of Data Academy’s Intro to PowerBI and Intermediate Power BI courses is required. This course assumes a good working knowledge of how PowerBI works. Heavy use is made of the query editor and familiarity is assumed. This course is not designed as a refresher course, but as the next stage in training for advanced Power BI analysts.

Upcoming courses scheduled

View the Course Calendar to see a list of upcoming classes. To get notified when enrollment opens for a class, complete the Course Interest Form and select the class (or classes) you’re interested in.

After completing the interest form, you will get an email when enrollment opens 3 weeks prior to class. Enrollment is not guaranteed as sometimes there are more interested employees than available seats.

Note: You must get your supervisor’s approval to attend any Data Academy courses.