Week 1: Introduction to Power BI & Data Connections
- What is Business Intelligence & Power BI?
- Power BI interface & navigation
- Connecting to Excel, SQL, and CSV datasets
- Import vs DirectQuery methods
Hands-on: Connect and explore a dataset
Week 2: Data Transformation with Power Query
- Data cleaning & shaping in Power Query
- Handling missing values & duplicates
- Merging & appending datasets
- Creating calculated columns & measures
Hands-on: Clean and transform sales data
Week 3: Data Modeling & DAX Basics
- Understanding relationships in data models
- One-to-many and many-to-many relationships
- Introduction to DAX (Data Analysis Expressions)
- Common DAX functions (SUMX, CALCULATE, FILTER, etc.)
Hands-on: Build a star schema for analysis
Week 4: Visualization & Dashboard Design
- Designing interactive reports & dashboards
- Using slicers, drill-through, and filters
- Advanced charts (maps, waterfall, gauge, KPI cards)
- Publishing & sharing reports on Power BI Service
Mini Project: Create an executive business dashboard
