Description
You’ve followed the introductory course ‘Power BI: Core Features I‘, so you know that Power BI is a very powerful tool. You’re familiar with its basic features, but there are still some aspects you’d like to know more about. During this two-day training, we’ll walk you through the phases again, but we’ll start where we left off in Part 1. The queries are more complex, which allows us to optimise our model. The calculations in the model will be more complex as well and we’ll discuss additional features. We won’t focus on the ways in which you can create an attractive report, but on how you can prepare data in Power Query and on calculations via DAX.
Objectives
After this training, you’ll know how to:
- Use functions in the query editor that are not available through the interface
- Write your own query functions
- Use parameters in queries
- Point out the advantages/differences between a star scheme and a snowflake scheme
- Optimize a model
Target Group
Everyone who knows the basics of Power BI and wants to learn more.
Prerequisites
You have completed the course ‘Power BI: Core Features I‘ or have a solid basic knowledge of Power BI.
