Advanced DAX Training: Understand and Optimize Power BI Data Models.
With DAX we have the ability to include business logic in calculations in order to enrich our business intelligence models.
The course will take place in a classroom with no more than 15 students in order to maintain a good level of interactivity.
Before attending this course, it is recommended that students have a desire to learn more about DAX and prior exposure to the DAX calculations.
Understanding of dimensional modelling and knowledge about any functional programming language is recommended too, but not necessary.
By the end of this course, you will be able to understand the key functions in DAX, the different elements that can be created with DAX and the different context involve in it. You could perform a variety of query´s using DAX, debugging and optimizing it.
Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEd’s, PASS BA, PASS Summit, DevWeek London, and PAW Chicago and London.Paco, a Microsoft Data Platform MVP and SolidQ North America Managing Director, is the PASS Big Data Virtual Chapter Leader, SQL Saturday Barcelona Organizer and assistant at the PASS Atlanta BI User Group. He is finishing his PhD thesis about “Analyzing Social Data with Machine Learning.” He is an MCT and MCP on BizTalk Server and SQL Server. He is coauthor of Microsoft Training Kit 441.
Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEd’s, PASS BA, PASS Summit, DevWeek London, and PAW Chicago and London.
Besides, trying to share knowledge to community through SolidQ and personal blog, collaborating with TechNet performing webcast and speaking in events.
Brett is also Chapter Leader for the Triangle SQL Server User Group (TriPASS) and a published author of numerous articles and books
Module 1. Introduction to DAX
- What is DAX?
- What can you create with DAX?
- Data types.
- DAX and relationships.
Module 2. DAX functions overview
- DAX functions overview.
- Filter and row context.
- What-If and parameters.
Module 3. Contexts and Advanced DAX.
- CALCULATE and CALCULATETABLE.
- More about Filter and Row contexts.
- Time Intelligence.
- Context transitions.
Module 4. Internals and Optimization.
- Debugging DAX code.
- DAX Studio.
- Query optimization.