Description

This training is designed for professionals who want to take their Power BI skills to the next level. The course dives deeper into the advanced aspects of Power BI, with a strong focus on query editing and data modeling. Participants will learn to perform complex data analyses, write their own query functions, and apply advanced data modeling strategies. Building on the basic knowledge gained in "Power BI: Core Features 1," participants are equipped with the tools and techniques needed to develop more efficient and effective BI solutions.

Objectives

After this Power BI training, you will be able to:

• Use query editor functions that aren't available through the interface

• Write your own query functions

• Use parameters in queries

• Identify the advantages/differences between a star schema and a snowflake schema

• Optimize a model

Target audience

This course is intended for professionals who already have basic knowledge of Power BI, for example through taking the "Power BI: Core Features 1" training or through relevant work experience. It's ideal for those who want to expand their skills in data modeling and query editing to carry out more complex analyses and reports.

Prerequisites

You have taken the "Power BI: Core Features 1" training or have solid basic knowledge of Power BI.

Contents

Part 1: Power Query

• Pros and cons of the different connection types: import, direct connection and live connection

• Defining parameters

• Query folding

• Introduction to M: the language of Power Query (defining constant values, generating lists, using functions not accessible through the interface, referencing other steps or queries)

• Generating a dynamic date table

Part 2: Data modeling

• Star schema versus snowflake schema

• Relationships between tables (single versus cross-filtering, active versus non-active relationships)

• Optimizing the model (Vertipaq engine / xVelocity in-memory analytical engine, setting custom sort order, data categories, default summarizations...)

• Defining hierarchies

• Composite models

• When to use multiple date tables?