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
-
Advanced Time Intelligence
- Time intelligence functions in complex scenarios
- Analysis “to date” (YTD, QTD, MTD)
- Working with weeks
- Custom time ranges
-
Advanced Calculations with DAX
- Advanced filtering with CALCULATE
- Using virtual relationships (TREATAS)
- Building rankings with DAX
- Using variables in DAX calculations
-
Calculated Tables and Virtual Tables
- Calculated tables in DAX
- Concept of “filter as a table”
- Creating calculated tables
- Creating virtual tables for specific calculations
-
Calculated Groups and Visualization-Level Calculations
- Calculated groups in DAX
- Using calculations at the visualization level
- Creating visualization-level calculations
- When visualization-level calculations are worth applying
-
DAX Queries and Performance
- Creating queries in DAX
- Correct and effective use of DAX
- Query performance analysis
- Best practices in DAX
