Course Syllabus
🧱 Phase 1: Foundations (Week 1–2)
✅ Week 1: Power BI Basics & Data Visualization Concepts
🔍 Phase 2: Intermediate (Week 3–4)
✅ Week 3: DAX Fundamentals + Calculations
🚀 Phase 3: Advanced Modeling & Optimization (Week 5–6)
✅ Week 5: Row-Level Security (RLS) + Workspace Deployment
☁️ Phase 4: Azure, Cloud & Migration Scenarios (Week 7–8)
✅ Week 7: Power BI + Azure Data Stack
🤝 Phase 5: Integration + Stakeholder-Focused Delivery (Week 9)
✅ Week 9: Power Platform, APIs, and Embedded Analytics
✅ Week 1: Power BI Basics & Data Visualization Concepts
- Intro to Business Intelligence & Power BI Ecosystem
- Power BI Desktop vs Power BI Service vs Report Builder
- Connecting to data sources (Excel, CSV, SQL Server)
- Types of visuals: bar, pie, matrix, slicers, KPI, cards, maps
- Best practices in dashboard design (what hiring managers look for)
- Hands-on: Create first report from scratch
- Star schema vs Snowflake schema
- Fact vs Dimension tables
- Introduction to Power Query (M)
- Data transformation (remove nulls, change data types, pivot/unpivot)
- Merge/Append queries
- Hands-on: Build a simple star schema model and clean data in Power Query
🔍 Phase 2: Intermediate (Week 3–4)
✅ Week 3: DAX Fundamentals + Calculations
- Calculated columns vs measures
- SUM, COUNTROWS, DISTINCTCOUNT, AVERAGE
- CALCULATE, FILTER, ALL, REMOVEFILTERS
- Time Intelligence: YTD, MTD, QoQ, Running Totals
- Hands-on: Build Sales Analysis dashboard with KPIs, trends
- Basics of relational databases
- Joins (INNER, LEFT, RIGHT, FULL), WHERE, GROUP BY
- CTEs, subqueries, window functions (RANK, ROW_NUMBER)
- Writing queries against large datasets (Redshift, SQL Server, etc.)
- Hands-on: Write and test SQL queries for report datasets
🚀 Phase 3: Advanced Modeling & Optimization (Week 5–6)
✅ Week 5: Row-Level Security (RLS) + Workspace Deployment
- Static vs Dynamic RLS
- Roles, DAX filters, and testing security
- Workspace and app deployment process
- Scheduled refreshes, gateway configuration
- Hands-on: Apply RLS and deploy dashboards to test workspace
- Import vs DirectQuery vs Hybrid
- Optimize models and reduce size
- Aggregation tables
- Using Performance Analyzer in Power BI
- Intro to Paginated Reports (Report Builder)
- Hands-on: Create a paginated invoice report and optimize visuals
☁️ Phase 4: Azure, Cloud & Migration Scenarios (Week 7–8)
✅ Week 7: Power BI + Azure Data Stack
- Connect Power BI to Azure SQL, Synapse, Data Lake
- Azure Data Factory: pipelines, linked services, data flows
- Azure Databricks + Delta Tables for semantic modeling
- Microsoft Fabric overview (Lakehouse, Dataflows Gen2)
- Hands-on: Create a Power BI dashboard from Azure Synapse dataset
- Compare architecture and performance (Qlik vs Power BI)
- Reverse engineer Qlik dashboards (logic, expressions)
- Handling NPrinting equivalents in Power BI
- Spotfire to Power BI with IronPython logic mapping
- Hands-on: Rebuild a Qlik dashboard in Power BI using best practices
🤝 Phase 5: Integration + Stakeholder-Focused Delivery (Week 9)
✅ Week 9: Power Platform, APIs, and Embedded Analytics
- Power BI + Power Automate: Triggered workflows
- Power Apps integration
- REST APIs for Power BI datasets
- Power BI Embedded concepts (for SaaS companies)
- Hands-on: Create a Power BI alert workflow with Power Automate