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.
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.
Module 1: DAX Functionality Review
Module 2: Controlling Content & Values
Module 3: Context Control Functions
Module 4: Contexts In Relationships
Module 6: Time Intelligence Calculations
Module 7: Appendix : DAX Dashboard Techniques
0.00 average based on 0 ratings