The Power BI Advanced Course is designed for professionals who want to elevate their Power BI skills with advanced DAX calculations, evaluation contexts, API integrations, and real-time streaming data. Participants will gain in-depth knowledge of filtering techniques, row-level security, and advanced data modeling while creating high-performance reports and dashboards.
By the end of this course, participants will be able to :
- Master advanced DAX functions and evaluation contexts.
- Implement dynamic Row-Level Security (RLS) with DAX.
- Utilize filtering techniques for optimized data analysis.
- Work with API and real-time streaming data sources.
- Customize reports with drill-throughs and tooltips.
- Implement advanced Power Query M Language for data transformations.
Module 1: Data Model
Module 2: Data Analysis Expressions (DAX) – Introduction
Module 3: DAX – Measures and Filters
Module 4: DAX – The CALCULATE Function
Module 5: DAX – Evaluation Contexts
Module 6: DAX – The Rules of Evaluation
Module 7: DAX – Contexts & Relationships
Module 8: DAX – The FILTER Function
Module 9: DAX – Variables
Module 10: Row Level Security
Module 11: Report Features
Module 12: Date Dimension
Module 13: Extended Topic A – API Data Sources
Module 14: Extended Topic B – Streaming Data Sources
Module 15: Extended Topic C – Files in Folders
Module 16: Additional Study (Extended Topic D) – Power Query M Formula Language
Module 17: Extended Topic B – Query Parameters (Dynamic Web Query)
Module 18: Extended Topic C – Group By
Module 19: Data Normalisation Appendix
Microsoft Power BI - Intermediate
-
PRICE (2 Days) Physical
-
PRICE (2 Days) Online
Language
English, Malay