Mastering DAX Workshop_Mar 15-17, 2023
DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power Pivot for Excel, Power BI Desktop and at Analysis Services developers that want to learn and master the DAX language. The goal of this three-day , classroom course is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. All the attendees will receive a copy of the book, The Definitive Guide to DAX - 2nd edition . Topics DAX Basics Table Functions Evaluation Contexts Filter and Row Context Evaluation Contexts and Relationships CALCULATE Context transition Iterators Time Intelligence Calculations DAX as a Query Language Advanced Table Functions Advanced Evaluation Context Understanding Cross filters Data lineage Advanced Relationship Handling Physical Relationships Weak Relationship...