General info

This is a one-day training course. Select the desired start date at the top right of the screen for practical information regarding the training (location, price, registration, etc.).

Course overview

DAX is simple, but not easy. With this course, we dig deeper inside of the technical aspect of the Data Analysis eXpression used in Power BI. The goal of the course is to teach you various use cases on how to write performant DAX. We provide you with the best practices and knowledge to write formulas for common and advanced business scenarios.

Who should attend this training

This course is intended for Power BI developers and business users who want to take their DAX knowledge to the next level.

Course Objectives

At the end of this course you are able to build a Power BI report with confidence, and know all the ins-and outs of the Power BI tool with regards to structure, best practices and cool data storytelling techniques.

Prerequisites

We recommend that attendees of this course have: 

• at least followed a Power BI Fundamentals training or equal experience
• basic knowledge of DAX
  
  

Course Content

• Basic fundamentals of BI
• Recap on DAX concepts like row and filter context
• Aggregation functions
• Text functions
• Iterator functions
• Filter functions
• Time intelligence
• Advanced data modeling techniques to alter relations and change filters
• Use DAX to augment your report design