Mastering Intermediate DAX - Power BI, Power Pivot & SSAS

Overview

Data Analysis and data modellingmade easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Syllabus

• Introduction to DAX
Overview of DAX and its importance in data analysis
Differences between DAX, Excel formulas, and SQL
• DAX Syntax and Functions
Understanding syntax rules and function categories
Commonly used functions in DAX
• Calculated Columns and Measures
Distinction between calculated columns and measures
Creating and using calculated columns
Creating and using measures
• Data Types and Filtering
Exploring DAX data types
Using filter functions to refine data analysis
• Time Intelligence Functions
Introduction to time-related calculations
Using functions like DATEADD, SAMEPERIODLASTYEAR, and TOTALYTD
• Advanced DAX Concepts
Understanding context: row context vs. filter context
Leveraging context transitions and CALCULATE function
Working with variable functions for optimized calculations
• DAX Optimization Techniques
Best practices for writing efficient DAX
Mitigating common performance bottlenecks
• Practical Data Modelling
Designing data models with DAX in mind
Role of relationships in Power BI, Power Pivot, and SSAS
• DAX in Power BI
Implementing DAX calculations within Power BI reports
Utilizing DAX for dynamic reporting and user interactions
• DAX in Power Pivot for Excel
Integrating DAX within Power Pivot tables
Enhancing Excel-based data models with DAX
• DAX in SQL Server Analysis Services (SSAS)
Applying DAX within SSAS models
Deploying calculated measures and KPIs in SSAS
• Case Studies and Hands-On Projects
Real-world examples of DAX use cases
Guided projects to consolidate learning
• Review and Course Conclusion
Recap of key concepts
Final Q&A session to address student queries
• Additional Resources
Recommended readings and online resources for further learning
Community forums and networks for ongoing support and learning

Taught by

Paula Guilfoyle CPA

Subjects

Business