Data Analysis Expressions (DAX) Training
Level
AdvancedDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedData Analysis Expressions (DAX) Training
DAX (Data Analysis Expressions) is a programming language created by Microsoft. It is mainly used in data analysis tools such as Microsoft Power BI, Microsoft Excel Power Pivot, and Microsoft Analysis Services. DAX enables the creation of advanced calculations and expressions that support business data analysis, modeling, and visualization.
What You Will Learn
- This DAX training aims to teach participants the various aspects of the language, enabling them to work effectively with Microsoft Power BI, Excel Power Pivot, and Analysis Services.
Who is this training for?
DAX is essential for anyone working with Microsoft’s data analysis tools. It allows advanced calculations and analyses that are crucial for effective business data analytics.
Training Program
- Understanding contexts in DAX – row context, filter context, evaluation context, context transition
-
Time intelligence functions in complex scenarios
- Analysis “to date”
- Working with weeks
- Custom time ranges
-
Advanced calculations with DAX
- Advanced filtering in CALCULATE
- Using virtual relationships (TREATAS)
- Building rankings with DAX
- Using variables in DAX calculations
- Calculated tables in DAX
- Concept of “Filter as a table”
- Creating calculated tables in DAX
- Creating virtual tables for specific calculations
- Calculated groups in DAX
- Using calculations at the visualization level
- Creating visualization-level calculations
- When is it worth applying them?
- Creating queries in DAX
- Correct use of DAX
- Query performance analysis
- Best practices in DAX
