Excel BI Tools: DAX Formulas for Dynamic Tables Course Outline
Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire.
This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement.
This course covers essential information needed for DAX-related reporting requirements. Specifically, it leverages the DAX language, teaching how to build models that extend the capabilities Power BI, Excel, or SQL Server Analysis Services. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time intelligence calculations.
Software Used During the Class
This class is for users of either Power BI, Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar DAX-related interface, the course will be taught using the Excel software. Users of Power BI and SQL Server should have no problems with the slight differences between products.
This course is aimed at Excel power-users, Power BI users who have a need to create dynamic reports that are based on the Excel / Power BI Data Model. Our Essential Data Preparation Skills for Data Mining course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server. For details on this companion course, go to
Essential Data Preparation Skills for Data Mining Using Power Query and M
While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either our "Analyzing Data with Power BI" or "Excel BI Tools" class or have similar experience.
DAX Functionality Review
Review Of Calculated Column
Review Of Measure
Rules Of DAX Measure
Formatting DAX Code
Controlling Content & Values
Context Control Functions
Additional Uses Of The All Function
Contexts In Relationships
Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Advanced Hierarchy Concepts
Time Intelligence Calculations
Working With Date Tables
Calculating Operating Periods
Working With Missing Periods
DAX Date Functions
Advanced Date Functions
Prior Year Functions
Appendix : DAX Dashboard Techniques
Advanced Slicer Techniques
View outline in Word