Microsoft® Power BI® Intermediate: From Data Modeling to Interactive Dashboards

Course Description:

This intermediate-level course takes Power BI users beyond the basics and into the world of scalable, professional-grade reporting. Participants will gain hands-on experience in modeling complex datasets, transforming queries for clean analysis, and building dashboards that tell compelling, data-driven stories. Key topics include designing star schemas, creating DAX measures with variables, developing drill-through and dynamic visuals, and publishing reports with secure data access. By the end of the course, users will have the skills to deliver powerful, interactive reports that support enterprise-level decision-making and performance tracking.

Course Objectives:

By the end of this course, participants will be able to:

• Build and manage star schema models for efficient data analysis

• Apply advanced Power Query transformations including merging, appending, and grouping data

• Create dynamic, interactive visuals and custom tooltips

• Develop professional DAX measures using variables and logic

• Implement drill-through reports and page navigation features

• Apply Row-Level Security (RLS) and publish reports to Power BI Service

• Set alerts and goals within dashboards for real-time monitoring

Course Highlights:

• Designing efficient Power BI workspaces and themes

• Connecting live data from APIs and web sources

• Using Power Query for merge, append, and group operations

• Building star schemas and custom date tables

• Writing advanced DAX with variables for calculations and logic

• Creating dynamic visuals, custom tooltips, and responsive dashboards

• Implementing drill-through pages and back buttons for interactivity

• Publishing to Power BI Service with Row-Level Security

• Setting alerts and tracking business KPIs using dashboards and goals