Description

You've taken the introductory course 'Power BI: Core Features 1', so you know Power BI is a very powerful tool. You've mastered the basic features, but you may not yet have a ready answer to some questions. In this two-day training we revisit the different phases, but we build further on where we left off in the first part. The queries become more complex so we can optimise our model. The calculations in the model also become more complex, and we look at more functions. The focus here is no longer on the various ways to create an attractive report, but rather on preparing data in Power Query and on calculations via DAX.

Objectives

After this Power BI training you will:

• 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

Anyone who knows the basic principles of Power BI but wants to broaden their knowledge.

Prerequisites

You've taken the course 'Power BI: Core Features 1' or have a solid basic knowledge of Power BI.

Contents

Part 1: Powerful queries

• Pros and cons of import, direct and live connections

• Defining parameters

• Query folding

• Introduction to M (Power Query language): constants, lists, advanced functions, references to steps/queries

• Generating dynamic date tables

Part 2: Data modeling

• Star vs. snowflake schema

• Table relationships (single vs. cross-filtering, active vs. inactive)

• Model optimisation (VertiPaq/xVelocity engine, custom sort order, data categories, default summarizations)

• Defining hierarchies

• Composite models

• Using multiple date tables

Part 3: Calculations (DAX)

• Understanding row and filter context

• Using variables in measures

• What-if parameters

• Selected DAX functions (based on time and interest)

Part 4: Reports

• Using custom visuals

Part 5: Security

• Row-level security (RLS): limiting data visibility per user