Description

This course is specially designed for experienced Power BI users who want to deepen their knowledge and skills in DAX (Data Analysis Expressions). DAX functions are an essential part of Power BI that enable powerful data analysis and calculations. This course focuses on developing advanced DAX skills, enabling participants to perform complex calculations and gain deep insights from their data. Through hands-on exercises and examples, participants will learn how to apply DAX effectively within their Power BI projects.

Objectives

After this Power BI training you will:

• Work with (bidirectional) relationships in the model

• Add measures, calculated columns and calculated tables to the model

• Be able to secure your data so end users only see the data they're allowed to see;

• …

Target audience

This course is ideal for data analysts, business analysts, and Power BI developers who already have experience with Power BI and want to expand their analytical skills. It's perfect for professionals who want to get more out of their data and perform advanced analyses within Power BI.

Prerequisites

Participants should have taken the introductory training "Power BI: Core Features 1" or have a solid foundation in Power BI.

Contents

Part 1 Calculations (DAX)

• Context (difference between row context and filter context)

• Time intelligence functions

• Calculate and CalculateTable

• Using variables in measures

• What-if parameters

Part 2 Security

• Row-level security (restricting the data in a report to what should be visible to the end user)