2025 Course Dates:  11/13, 12/18

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