DAX Power Pivot - 10 Easy Steps for Intermediates

Overview

This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners.

Syllabus

• Introduction to Intermediate DAX and Power Pivot
Review of Beginner Concepts
Overview of Intermediate Goals
• Advanced Data Modeling Techniques
Defining Relationships Between Tables
Using Advanced Table Functions
• Intermediate DAX Functions and Calculations
Understanding CALCULATE and FILTER Functions
Utilizing Time Intelligence Functions
• Advanced Power Pivot Data Analysis
Implementing Hierarchies
Creating and Using KPIs (Key Performance Indicators)
• Complex Measures and Calculated Columns
Writing Measures with Intermediate Complexity
Leveraging CALCULATE for Conditional Logic
• Performance Optimization Techniques
Fundamentals of DAX Query Optimization
Best Practices for Data Model Efficiency
• Handling DAX Errors and Debugging
Common DAX Errors and Their Solutions
Tools and Techniques for DAX Troubleshooting
• Using DAX for Advanced Reporting and Visualization
Integrating DAX with Power BI and Dashboards
Custom Visualizations Using DAX Insights
• Advanced Scenario Analysis with DAX
Using What-If Analysis
Sensitivity Analysis Techniques
• Working with Large Data Sets
Techniques for Scaling DAX Solutions
Memory Management and Data Compression
• Project: Building an Intermediate-Level Power Pivot Dashboard
Applying Intermediate Techniques in a Real-World Scenario
Peer Review and Feedback Session
• Course Summary and Next Steps
Recap of Key Learnings
Preparing for Advanced DAX Topics and Future Learning Paths

Taught by

Gilly Dow

Subjects

Business