Gold Plan – Complete Curriculum
Advanced Power BI & Data Modeling
- Star Schema & Snowflake Schema
- Fact vs Dimension tables
- Relationships (Active / Inactive)
- Granularity & performance basics
DAX – From Fundamentals to Advanced
- CALCULATE & Context Transition
- FILTER vs ALL vs REMOVEFILTERS
- YTD, QTD, MTD, YoY growth
- SUMX, AVERAGEX, RANKX
- Performance-friendly DAX
Business Analytics & KPI Design
- Understanding business questions
- Defining KPIs (Sales, Ops, Finance)
- Variance & trend analysis
- Executive vs operational dashboards
Advanced Dashboards & Optimization
- Page navigation & drill-through
- Tooltip pages
- Dynamic titles & measures
- Performance optimization
Capstone Business Project
- Sales Forecast & Performance Analysis
- Banking / KYC Analytics Dashboard
- Operations Efficiency Dashboard