How to learn DAX

Whether you are starting from scratch or have already learned the basics of DAX, this guide will show you all the steps to follow in order to master the Power BI and Analysis Services query language.
Are you a Power BI user?

Start here – you are a DAX Rookie.

1
free
Get an overview of all the features of Power BI.
2
free
Grasp the basics of the DAX query language.
3
free
Grasp the basics of building data models in Tabular.
4
free trial
Control the Tabular model used by Power BI.
5
free trial
Learn how to build data models properly in Tabular.
6
Consolidate your knowledge on data modeling.
7

Practice

Let's build Star Schemas and write simple formulas!
8
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

9
Consolidate your knowledge of DAX.
10

Practice

Let's work with complex formulas!
11
free trial
Learn how to make your DAX queries faster.
12
free
Learn the DAX best practices in common use cases.
Note that Optimizing DAX is not required to use patterns, but it is suggested for optimizations.
13
Learn how to use the DAX patterns in more depth with our video lectures.

You've achieved DAX mastery – you are now a DAX Guru!

Are you an Excel user?

Start here – you are a DAX Rookie.

1
Learn how to use the Power Pivot add-in for data analysis.
2
free trial
Learn how to master Power Pivot.
3

Practice

Let's build Star Schemas and write simple formulas!
4
free
Grasp the basics of building data models in Tabular.
5
free trial
Learn how to build data models properly in Tabular.
6
Consolidate your knowledge on data modeling.
7
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

8
Consolidate your knowledge of DAX.
9

Practice

Let's work with complex formulas!
10
free trial
Learn how to make your DAX queries faster.
11
free
Learn the DAX best practices in common use cases.
Note that Optimizing DAX is not required to use patterns, but it is suggested for optimizations.
12
Learn how to use the DAX patterns in more depth with our video lectures.

You've achieved DAX mastery – you are now a DAX Guru!

Are you an Analysis Services pro?

Start here – you are a DAX Rookie.

1
free trial
Learn how to master Tabular modeling in Analysis Services.
2
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

3
Consolidate your knowledge of DAX.
4

Practice

Let's work with complex formulas!
5
free trial
Learn how to make your DAX queries faster.
6
free
Learn the DAX best practices in common use cases.
Note that Optimizing DAX is not required to use patterns, but it is suggested for optimizations.
7
Learn how to use the DAX patterns in more depth with our video lectures.

You've achieved DAX mastery – you are now a DAX Guru!