SERVICE

Advanced Power BI: Mastering DAX (self-paced)

What to know

Prerequisites

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).

Completion of Data Academy’s Intro to PowerBI and Intermediate Power BI courses is required. This course assumes a good working knowledge of PowerBI. 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.

About the 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.

Duration: 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.

Location: The course is fully self-paced and online.

What to do

1. Review the course learning objectives

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. You will learn:

  • 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

2. Join the interest list

Fill out our Course Interest form to get a notification email when courses open for enrollment.

This email will include a short Enrollment Form that you will need to fill out to get on the waitlist for that scheduled class. Seats are granted on a first-come, first-served basis so please complete the enrollment form as soon as you can.

Note that filling out the course interest form does NOT guarantee enrollment in any course.

More details

Resources