The DAX Workshop - Part 2

Overview

The DAXWorkshop Part 2 is a continuation of The DAX Workshop Part 1. It is a course that allows the student to get proficient in the DAX language by practicing on all sorts of common business scenarios.

Syllabus

• Review of DAX Workshop Part 1
Key concepts and functions
Common business scenarios covered
• Advanced DAX Functions and Usage
Time intelligence functions
Iterator functions
Error handling functions
• Data Modeling Techniques
Relationships and hierarchies
Calculated tables and columns
Optimizing data models for performance
• Advanced Calculations and Metrics
Complex calculated measures
Creating KPIs with DAX
Handling complex filtering
• Performance Optimization
Query optimization strategies
Efficient use of variables
Reducing cardinality in data models
• Real-world Business Scenarios
Sales analysis
Budget vs actuals
Customer segmentation
• Workshop and Case Studies
Hands-on exercises on various scenarios
Collaborative problem-solving sessions
Group projects with peer feedback
• Troubleshooting and Best Practices
Common pitfalls in DAX
Best practices for writing DAX formulas
Debugging and testing DAX code
• Final Project
Application of learned concepts to a comprehensive scenario
Presentation and peer review
• Course Recap and Q&A
Overview of key learnings
Addressing student questions and challenges
Next steps for further learning and practice

Taught by

Randy Minder

Subjects

Business