Trainer
Vojtěch Šíma
Microsoft MVP. In his courses he passes on what he builds and measures for clients himself, and works on your data if you provide it.
For intermediate users
Advanced DAX
How DAX works inside: row and filter context, CALCULATE, querying in DAX, optimizing measures and user-defined functions (UDFs).
€3,1002 days · At your company, or online · up to 12 people recommended
per group, excl. VAT
- TrainerVojtěch Šíma, Microsoft MVP
Who it's for
Who the course is for
- People who write DAX measures and want to understand how they work under the hood and how to write them better.
- Before the course we recommend a short knowledge test. It's optional, and we use it to adjust the program so nobody sits through material they already know.
Who it's not for
When another course suits you better
- You haven't written DAX yet. Start with Power BI Fundamentals.
- A slow refresh is what bothers you. Data Modeling is for you, or go straight for a Performance Audit.
What you take away
What you can do on Monday
- Explain row and filter context on your own measure.
- Predict what CALCULATE does to the filters.
- Build time intelligence on your own calendar table.
- Use calculation groups instead of dozens of similar measures.
- Write your own DAX functions (UDFs) and use them in measures.
Program
What the course covers
- Row and filter context
- Where each context comes from, what context transition is, and how to work with them correctly.
- CALCULATE
- How CALCULATE works with filters, how to change and nest them, and how to write expressions optimized for speed.
- Time intelligence
- Designing and working with a calendar table. Time intelligence functions such as MTD and YTD, and native comparisons across periods.
- Calculation groups
- Creating them, format string expressions, and their order relative to other measures.
- User-defined functions
- How to write your own UDFs, how to use evaluation modes, and how to plug them into everyday measures.
Trainer
Price and formats
At your company, or online
| Format | Who it's for | Price |
|---|---|---|
| At your company | For one team, on your data | €3,100, travel beyond 50 km from Brno quoted separately |
| Online | Same program, exercises in shorter blocks | €3,100 |
The price is for the whole group, however many people attend. Demos and exercises run on your data if we agree on it before the training, otherwise on sample data. The price is the same either way.
After the course
What happens after the course
- The same test again. Anyone who took it before the course sees their progress in numbers.
- A call 30 days later. What made it into daily work and where people got stuck.
- A look at your model. On the call we can look at the model people work on after the course.
When the model misbehaves
Performance Audit
We measure slow reports and long refreshes and fix the most expensive spots. We back up the before and after with numbers.
FAQ
What you ask us most
- Can you train us on our own data?
- Yes, if we agree on the data before the training. The price is the same with or without your data. From experience we go for your data, because people know it and work with it more easily.
- Can the course run online?
- Yes, in person or online. The program is the same, the exercises are just split into shorter blocks.
- How many people can attend?
- We recommend 12 at most, so there's time to go through the exercises with everyone. The price is per group and doesn't depend on headcount.
- Do we get a certificate?
- We don't issue certificates. Anyone who takes the knowledge test before and after the course sees their progress in numbers. For the PL-300 certification, take our course PL-300 Exam Prep.
Contact
Tell us when you're planning the training
How many people, when and where. We'll get back to you within two working days with a date and a program.
- Emailinfo@daatlers.com
- Phone+420 777 542 792, David Polleč
- Where we areBrno, but we'll meet you anywhere.