DAX – Mastering DAX Foundations for Power BI

Demystifying DAX for Advanced Power BI Reporting

Background

What you’ll learn

  • Understand how the DAX engine works.
  • Understand Calculated Tables, Columns, Measures and when to use what.
  • Simplified understanding of DAX Evaluation Context, Row, Filter and Context Transition.
  • Understand the most used DAX functions.
  • Write Time Intelligence formulas.
  • Understand when to use Iterator functions.

Course Content

  • Introduction & Overview of DAX –> 10 lectures • 32min.
  • Understanding DAX Pillars and Functions –> 9 lectures • 41min.
  • Understanding how the DAX Engine works –> 9 lectures • 37min.
  • Manipulating Filters Context with CALCULATE() Function –> 14 lectures • 54min.
  • Time Intelligence Calculations in DAX –> 13 lectures • 52min.
  • Other DAX Calculations –> 5 lectures • 18min.

DAX - Mastering DAX Foundations for Power BI

Requirements

  • Students should be familiar with Power BI reporting already..
  • Some Excel formulas knowledge is an advantage but not necessary..
  • Students should have the latest version of Power BI for practice.

Background

 

DAX is the formula language of Power BI, Excel Power Pivot and SSAS Tabular. The formula language simply unlocks advanced capabilities for reporting in Power BI.

However, DAX is not an easy language to learn. Mastering it requires a proper understanding of the rudiments and a lot of constant practice.

In this course, I have used a very explanatory approach to ensure that you will understand, learn and master DAX faster than most courses where formulas ae being copied from a text editor without proper explanation of what is happening behind it.

As a Microsoft Most Valuable Professional for the Data Platform and a Microsoft Certified Trainer, I will be able to answer your DAX questions as you continue to develop your skills after this course.

 

What you will learn.

 

This course is suitable for all levels of Power BI users. You will learn from the introductory concepts to build a solid background. By the time you complete the course, you should have a better understanding of:

1. DAX usage in Power BI (Calculated Columns, Calculated Tables, Measures and Row Level Security)

2. The most important and used DAX functions

3. How the DAX Engine works behind the scenes

4. The CALCULATE function in DAX

5. Row Context, Filter Context and Context Transition

6. Time Intelligence functions and calculations

7. Other important DAX functions like RANKX and TOPN