Abstract:
If you want to show more than simply the data provided by the data source and implement calculations in Power BI or Analysis Services Tabular you have to learn to write Data Analysis Expression (DAX). This workshop starts at entry level and jump-starts you into the world of even complex calculations within 8h. In the first module Markus will introduce the basic syntax, functions and concepts (which are best of bread, taken from Excel, SQL and MDX). Then you will learn that you can exchange complexity in the data model with complexity in DAX (and the other way around) in real world examples. Beginners usually struggle to fully understand the differences between calculated columns and measures. That’s why we will dedicate two modules on them. In the last module Markus will pick your brain with complex challenges and advanced techniques, which you can then take as template to apply on your own use cases.

Modules:
1. Syntax and Basic Functions
2. Data Model and DAX - A Symbiosis
3. Calculated Columns
4. Measures
5. Advanced Techniques