DAX is a powerful tool in the arsenal of every Business Intelligence developer working within the Microsoft ecosystem. However, like any tool, it must be used wisely—great power comes with great responsibility.

Beyond Power BI, DAX knowledge is transferable to Analysis Services (both on-premises and in the cloud) and Excel’s Power Pivot, where its journey first began.



Who should attend?
This workshop will be conducted in Czech language and is designed for anyone working with DAX—whether you’re a beginner looking to build a strong foundation or an advanced user aiming to refine your expertise.

You’ll gain new insights, practical experience, and hands-on learning to improve your DAX skills in real-world scenarios.


1. DAX Language Essentials
Key concepts and best practices
Practical examples of DAX applications
How DAX is used across different Microsoft platforms
2. Effective DAX Usage in Various Scenarios
Calculated Columns vs. Transformations: When to use each
Understanding Measures: Their role in different scenarios
Calculated Tables: When to use them—and when to avoid them
Row-Level Security (RLS): Implementing secure data access with DAX
Performance Optimization: Enhancing VertiPaq storage and memory efficiency
Debugging & Performance Tuning: Fixing slow reports and optimizing performance
3. Hands-on DAX Development
Solve real-world problems with hands-on exercises
Improve fluency in DAX, data modeling, and reporting
Apply practical examples to enhance understanding
Key Takeaways
By the end of this workshop, you will:

Understand when to use Calculated Columns vs. Measures
Learn common pitfalls to avoid in DAX
Design efficient data models with performance in mind
Develop techniques for analyzing and debugging performance issues
Gain a wealth of practical examples to apply in your work
And most importantly—have an engaging and productive learning experience!