Unit III · Introduction to Power BI (≈11 hours)
1. Workflow & Components
- Desktop vs Service; dataset → model → report → dashboard.
- Power Query (ETL), Data Model, Power Pivot, visuals (charts, matrix, slicers, maps).
- Gateways, Report Server, content packs overview.
2. Data Connections
- Excel, CSV, web, and relational sources; DirectQuery vs Import.
- SQL basics and connecting to SQL Server/MySQL; table relationships.
3. Modeling & Visualization
- Star schema guidance; hierarchies; surrogate keys.
- Essential visuals: line/clustered column, card, matrix, map, decomposition tree.
- Design: color meaning, layout grids, interaction edit, bookmarks & buttons.
Banking case: Financial KPIs dashboard (revenue trend, YoY growth, segment mix), with slicers for region and product lines.