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 advanced users
Data modeling
Model shape, relationships, storage mode and where to transform data so the model stays fast.
€3,5002 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 already build semantic models and want to make them faster and handle harder modeling cases too.
- 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're new to Power BI. Power BI Fundamentals is for you.
- You're mainly after writing M code. The Power Query M Language course is for you.
What you take away
What you can do on Monday
- Design a model as a star or a snowflake schema.
- Solve many-to-many and relationships through a bridge table.
- Choose between Import, DirectQuery and Direct Lake based on cost and speed.
- Optimize relationship paths between tables and understand how DAX reads relationships.
Program
What the course covers
- Model schema
- Star and snowflake schema. Facts and dimensions, granularity, helper and bridge tables. How to think about field parameters and calculation groups as part of the model.
- Relationships
- Cardinality, filter direction, active and inactive relationships, bridge tables.
- Import and DirectQuery
- Which data calls for Import and which for DirectQuery, what each then costs to run, and what the limitations are.
- Direct Lake
- How to use your Power BI knowledge to design a model in Fabric for optimal Direct Lake performance.
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,500, travel beyond 50 km from Brno quoted separately |
| Online | Same program, exercises in shorter blocks | €3,500 |
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.