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 drillthrough 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 drillthrough 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 drillthrough 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