This course turns Excel into a lightweight BI stack for decision-makers. You’ll learn to ingest messy data with Power Query, model it with relationships, and deliver refreshable dashboards that management can trust. We focus on durable patterns—star schema basics, context-aware measures, and simple, readable visuals that answer business questions fast. By the end, you’ll build a refreshable KPI pack tied to a calendar, regions, and product hierarchy, with one-click filters and consistent definitions, plus a short documentation sheet for handover.
Learning outcomes:
-
Clean and combine multi-file data with Power Query
-
Build a simple star schema and relationships in the Data Model
-
Create robust measures for KPIs and time analysis (intro)
-
Design readable dashboards with slicers and scenarios
-
Implement a repeatable refresh and handover checklist
Audience / Prereqs: Analysts, managers, PMs. Familiarity with Tables, SUMIFS/XLOOKUP helpful.
- BI Instructor: Syed Rehan Ali