Conquering DAX 2019 [Fastrack]
Duration:
3 Days (24 Hours)
Class Size:
Maximum 25 participants
Class Type:
Physical Class
![Conquering DAX 2019 [Fastrack]](https://static.wixstatic.com/media/6bf57b_10e7d8b996ad4c948cb0b426890f3bf6~mv2.png/v1/fill/w_389,h_220,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Image-empty-state.png)
Course Overview
This workshop is a complete course about the DAX language. 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. This course covers the latest version of DAX 2019.
Who Should Attend?
Power BI users: Business users who are already using Power BI to build solutions and want to learn how DAX can enhance their work
Data analysts: Professionals who want to improve their data analysis skills, including business analysts, data scientists, and those involved in business intelligence
Power Pivot for Excel users: Users of Power Pivot for Excel who want to learn DAX
Analysis Services developers: Developers who want to learn DAX for SSAS Tabular models in Microsoft SQL Server Analysis Services
Anyone looking to improve Power BI proficiency: Anyone who wants to get more out of Power BI or Power Pivot for Excel
Course Objectives
After completing this course, students will be able to:
Understand all the features of the DAX language
Write formulas for common and advanced scenarios
Prerequisites
Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.
Course Modules
Module 1: Introduction to DAX
Module 2: Table Functions
Module 3: Evaluation Contexts
Module 4: CALCULATE Function
Module 5: Iterators
Module 6: Time Intelligence in DAX
Module 7: Hierarchies in DAX
Module 8: ALLSELECTED and Shadow Filter Contexts
Module 9: Segmentation
Module 10: Many-to-many Relationships