Power BI — Data Visualization & Dashboards
Transform raw data into compelling interactive business intelligence reports. Learn Power Query ETL, Star Schema data modeling, DAX measures, time intelligence, and cloud publishing.
Course Structure & Tracked Topics
Click on any module to view live sessions and the exact list of topics tested & tracked for attendance.
Session 1: Introduction & Environment Setup
Import web data and create preliminary card metrics.
Session 2: Power Query Data Transformation (ETL)
Session 3: Data Modeling & Star Schema
Ingest 4 disparate files into Power Query, enforce types, and construct a verified Star Schema relationship model.
Session 4: Core Visuals & Conditional Formatting
Session 5: Advanced Visuals & Interactivity
Configure drill-downs from country down to city-level sales.
Session 6: Introduction to DAX Formulas
Session 7: Intermediate DAX & CALCULATE
Author CALCULATE and ALL measures to compute market share percentages.
A 2-page interactive report with custom DAX measures for profit margin %, synchronized date slicers, and drill-downs.
Session 8: Time Intelligence DAX Functions
Session 9: Dashboard UX, Bookmarks & Tooltips
Session 10: Cloud Publishing & Final Presentation
Executive SaaS Business Performance & Churn Dashboard
Construct a multi-page Power BI dashboard analyzing MRR, ARR, customer churn, and representative quota attainment with YoY time intelligence.
What You Will Be Able To Do
Prerequisites
Basic Excel understanding recommended.