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