Description
This course is specifically designed for experienced Power BI users who want to deepen their knowledge and skills in DAX (Data Analysis Expressions). DAX features are an essential part of Power BI that enables powerful data analysis and calculations. This course focuses on developing advanced DAX skills, enabling participants to perform complex calculations and extract deep insights from their data. Through hands-on exercises and examples, participants will learn how to effectively apply DAX within their Power BI projects.
Objectives
After completing this Power BI course, you will be able to:
- Work with (bidirectional) relationships in the model
- Add measures, calculated columns and calculated tables to the model
- Protect your data so that the end user only sees the data he is allowed to see
- …
Target Group
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 is perfect for professionals who want to get more out of their data and perform advanced analytics within Power BI.
Prerequisites
Participants should have taken the introductory training course “Power BI: Core Features 1” or have a solid foundation of Power BI.
Contents
Part 1 Calculations (DAX)
- Context (Difference between row context and filter context)
- Functions (depending on time)
- Filter functions (ex: All, AllSelected, Filter, Selectedvalue, Removefilters)
- Time intelligence functions (ex: DateAdd, DatesBetween, DatesINPeriod, DatesYTD, SamePeriodLastYear)
- Logic functions (ex: If, Switch, Coalesce)
- Aggregation functions (ex: Countrows, SumX, Countblank, Distinctcount)
- Relation functions (ex: Userelationship, Crossfilter, Relatedtable)
- …
- Calculate and CalculateTable
- Add context
- Change context
- Remove context
- Context transition (row context becomes filter context)
- Using variables in measures
- What if parameters
Part 2 Security
- Row-level security (limit the data in a report to what may be visible to the end user)
