DAX Training

Power your Power BI model with DAX!

You can only unlock the full analytical power of dashboards in Power BI with Data Analysis Expressions (DAX). DAX is not a language you learn just by doing, theoretical knowledge is needed! This training covers all DAX language concepts required to write DAX, plus extensive exercises to get enough hands-on experience.

This training is perfect for

Data Analysts working with Power BI, who want to take their dashboards to the next level. Hands-on experience and knowledge of Power BI and data modeling are required to participate in this training. You can acquire this through our Power BI In a Day training, Data Modeling training or through work experience with Power BI.

What will you learn during the DAX training?

This training will provide you with the knowledge and experience needed to use Power BI for more than just analyzing data. You will have a theoretical understanding of this formula language to apply DAX successfully. 

Program

The program consists of four blocks that combine theory and practice.

• Introduction to DAX, with hands-on exercises to learn essential functions
• Tables and relationships
• Evaluation context, filter and row content
• Hands-on lab: Applying the DAX theory on a Power BI model

You will learn:

• To determine whether to use a measure or a calculated column
• How to aggregate a column in a measure
• How to aggregate an expression in a measure
• How to use the different function groups within DAX
• How to use columns from related tables in a DAX expression
• How to apply table functions
• The difference between row and filter context
• How to ignore filter context using ALL
• How to nest multiple row contexts
• How to use variables to make DAX code easier to read and ready for the right context 
• How to use CALCULATE to manipulate the filter context 
• How to use CALCULATE to trigger evaluation context transition 

Data Engineering Trainers

This Data Engineering training is brought to you by our training partner, GoDataDriven. GoDataDriven works with experts in their field who are always on the lookout for the most innovative ways to get the most out of data. Your trainer is a data guru who enjoys sharing his or her experiences to help you work with the latest tools. 

Data Engineering Learning Journey

In addition to this DAX training, Xebia Academy offers more Data Engineering courses together with GoDataDriven. Find an overview of these training courses here. 

Yes, I want to learn DAX!

After registering for this training, you will receive a confirmation email with practical information. A week before the training, we will ask you about any dietary requirements and share literature if there's a need to prepare. See you soon!

What else should I know?

• The training requires a laptop and Power BI. Power BI is available for free.
• This training is brought to you by our training partner, GoDataDriven.
• Literature and a nice lunch are included in the price.
• Travel & accommodation expenses are not included.