DAX Tips, Tricks and Techniques

Overview

This course is all about learning an assortment of DAXtips, tricks, techniques and best practices in a wide range of areas including:

Syllabus

• Introduction to DAX
Overview of Data Analysis Expressions (DAX)
Importance and applications in data analysis
• Basic DAX Functions
Commonly used functions
Syntax and basic operations
• Time Intelligence Techniques
Date-based calculations
Using CALENDAR and CALENDARAUTO functions
• Calculated Columns vs. Measures
Differences and best use cases
Performance considerations
• Filter Context Techniques
Understanding row and filter context
Using FILTER, ALL, and RELATED functions
• Advanced Aggregations
Utilizing SUMX, AVERAGEX, and other iterator functions
Total and subtotal calculations
• Optimizing DAX Queries
Performance tuning strategies
Analyzing and optimizing query plans
• Common DAX Patterns
Reusable patterns for business scenarios
Pattern implementation and adaptation
• Debugging and Error Handling in DAX
Identifying and resolving common errors
Utilizing the IFERROR function
• Visualization Techniques
Best practices for integrating DAX in reports
Enhancing visuals with DAX
• Real-World Case Studies
Practical applications of learned skills
Case-based problem-solving exercises
• Conclusion and Best Practices
Recap of key techniques
Tips for continued learning and improvement
• Course Wrap-up
Q&A session
Resources for further study

Taught by

Randy Minder

Subjects

Business