The DAX Workshop - Part 1

Overview

The DAXWorkshop is a course that allows the student to get proficient in the DAX language by practicing on all sorts of common business scenarios. Approximately 45 practice exercises, and a half-dozen tutorials, exist covering most of the important parts of the DAX language.

The focus of this course is not so much on teaching the language, although there is a lot of that. The main focus is working through exercises to clearly show how the DAX language can be used to solve common business reporting requirements.

Syllabus

• Introduction to DAX
Overview of DAX and its role in data analysis
Basic syntax and functions
• Getting Started with DAX
Setting up the environment
Creating and editing DAX expressions
• Data Manipulation
Understanding calculated columns and measures
Basic aggregation functions (SUM, AVERAGE, COUNT)
• DAX Context and Filtering
Row and filter context
Using CALCULATE and FILTER functions
• Time Intelligence
Introduction to time-based calculations
Functions like DATEADD, TOTALYTD, and SAMEPERIODLASTYEAR
• Advanced DAX Functions
Working with iterator functions: SUMX, AVERAGEX
Joining tables with RELATED and RELATEDTABLE
• Common Business Scenarios Workshop
Profit and loss calculations
Sales forecasting
Inventory management
• Advanced Filtering Techniques
Using ALL, ALLEXCEPT, REMOVEFILTERS
Context transitions and complex filter logic
• Performance Optimization
Best practices for efficient DAX queries
Analyzing and improving query performance
• Troubleshooting and Debugging DAX
Common errors and issues
Debugging with DAX Studio
• Capstone Project
Real-world business scenario application
Presenting and interpreting results
• Conclusion and Next Steps
Review of key concepts
Guidance for further learning and practice

Taught by

Randy Minder

Subjects

Business