Power BI — Basic to Advanced with Real Projects — syllabus 2026
Power Query, data modelling, DAX and dashboard design across 12 modules, with 10 projects and interview prep mapped to how Power BI interviews are weighted.
Module-wise syllabus
Tap a module to see every topic. The same syllabus is used in our classroom and live online batches.
01Business Intelligence & Power BI4 topics
- What BI is and its role in decisions
- Power BI ecosystem; Desktop vs Service
- Licensing overview & installation
- Power BI interface
02Data Sources & Connectivity3 topics
- Excel, CSV / text, SQL Server & web sources
- Import mode vs DirectQuery; live connection
- Data refresh basics & best practices
03Power Query — Data Transformation5 topics
- Remove duplicates, replace values, split & merge columns
- Data types, sorting, filtering, first row as header
- Group By, pivot & unpivot
- Custom columns & merge queries
- Applied steps & refreshing queries
04Data Modelling & Relationships4 topics
- Fact & dimension tables
- Relationships, cardinality & cross-filter direction
- Star & snowflake schema
- Multiple tables & date tables
05DAX Fundamentals4 topics
- Calculated columns vs measures
- SUM, AVERAGE, COUNT, MIN / MAX
- Variables in DAX
- Row context & filter context
06Intermediate DAX & Time Intelligence4 topics
- SWITCH and logical functions
- CALCULATE & FILTER
- TOTALYTD, SAMEPERIODLASTYEAR, DATEADD
- KPIs & dynamic measures
07Data Visualisation & Reporting6 topics
- Bar, column, stacked, clustered & 100% charts
- Line, area, combo, ribbon, waterfall, funnel, scatter
- Pie, donut, treemap, maps, gauge, cards & multi-cards
- Table, matrix, decomposition tree, Q&A
- Slicers, report / page / visual-level filters, sorting
- Drill down, drill through & tooltips
08Advanced Visuals & Dashboard Design4 topics
- Custom visuals & combo charts
- KPI & card visuals
- Dashboard design best practices
- Colour themes, branding & interactive reports
09Advanced Power Query & Parameters3 topics
- Parameters & dynamic data sources
- Merge vs append queries
- Query folding & performance
10Advanced DAX & Performance6 topics
- Evaluation contexts; RELATED & RELATEDTABLE
- Iterators: SUMX, AVERAGEX, COUNTX; RANKX
- ALL, ALLEXCEPT, VALUES, FILTER, CALCULATETABLE
- Text, blank-handling & table functions (ADDCOLUMNS, SUMMARIZE, UNION)
- CALENDAR / CALENDARAUTO, TOTALMTD / QTD / YTD, PARALLELPERIOD, running totals
- Optimising measures & large datasets
11Power BI Service & Deployment4 topics
- Publishing reports & creating dashboards
- Sharing & workspace management
- Row-Level Security (RLS)
- Scheduled data refresh
12Power BI for MIS & Real-World Use Cases4 topics
- MIS report design
- Finance, sales, HR & operations dashboards
- End-to-end Power BI project
- Interview & project preparation
Projects & practice
Programmes that include Power BI
| Programme | Duration | Fees |
|---|---|---|
| Advance MIS & Analytics | 4–6 months | ₹20,000 |
| Professional MIS & Analytics + Job Placement | 6–8 months | ₹30,000 |
| Professional Data Science & AI (GenAI, ML & Agentic AI) | 10–12 months | ₹75,000 + GST |
Learning only Power BI? See the Power BI course page or the local pages for Dwarka Uttam Nagar Janakpuri .
Frequently asked questions
Can I download the Power BI syllabus as a PDF?
Yes. Use the “Download syllabus PDF” button on this page — enter your name and mobile number and the PDF opens instantly.
How long does the Power BI course take?
It is taught inside our programmes: Advance MIS & Analytics (4–6 months, ₹20,000); Professional MIS & Analytics + Job Placement (6–8 months, ₹30,000); Professional Data Science & AI (GenAI, ML & Agentic AI) (10–12 months, ₹75,000 + GST). Module-wise batches are also possible — ask the counsellor.
Is it online or classroom?
Both. Classroom batches run at our Dwarka, Uttam Nagar and Janakpuri branches, and live online batches are available.