Become a Master of

DAX

The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.

Why Learn DAX?

This is the course of the Mastering DAX workshop.
DAX is the native language of Power BI, Power Pivot for Excel, and SSAS
Tabular models in Microsoft SQL Server Analysis Services. The training is
aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services
developers that want to learn and master the DAX language.
The goal of the course is to teach all the features of DAX, providing the
knowledge to write formulas for common and advanced business
scenarios. The course is made up of over 12 meetings, plus the
package of individual exercises.

1-hour BI Sessions

Power-BI-Data-Sources-What-You-Can-Connect-How

1. Introduction to DAX
2.Table functions
3.Evaluation contexts

4. The CALCULATE function
5. Advanced evaluation contexts
6. Iterators

7. Building a date table & Time intelligence in DAX
8. Hierarchies in DAX Querying with DAX
Data lineage and TREATAS
9.Expanded tables Arbitrarily shaped filters ALLSELECTED and shadow filter contexts
10. Segmentation
Many-to-many relationships
Ambiguity and bidirectional filters
11.Relationships at different granularities
12. Calculation groups