Video Training: DAX and Calculations in Power BI
This course is part of the Power BI from Rookie to Rock Star Training.This training is designed for data modelers, who have the data prepared to be modeled for analysis. Usually, people who take this course need to also take the Power Query video course to learn about the step before the modeling. In this training, you will learn detailed modeling practices of Power BI, and DAX unleashed.
In this training, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real-world challenges of a BI solution.
The training continues with more focus on DAX; we will talk about the evaluation context in DAX, which defines the mindset and the way of thinking when you are writing DAX expressions. You will learn about DAX function categories such as Aggregation functions, Iterators, Filter functions, parent-child functions, time intelligence functions, functions dealing with relationships, etc. You will learn all scenarios through hands-on examples of real-world data.
At the end of this training, you will be able to design the proper data model in Power BI, understand all relationship requirements and implement the right relationship, write complex DAX expressions for your analytics need, and put them all together to build the best model for your data analysis solution using Power BI.