Curriculum
- 8 Sections
- 74 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Module 1 – Introduction to Power BI12
- 1.1What is Power BI? Overview and key features
- 1.2Understanding Business Intelligence concepts and importance
- 1.3Power BI Components: Desktop, Service, Mobile App, Gateway
- 1.4Power BI Architecture and Workflow
- 1.5Power BI Building Blocks (datasets, reports, dashboards, workspaces)
- 1.6Installation and setup
- 1.7Power BI Desktop Interface: Home, Report, Data, and Model views
- 1.8Flow of Work in Power BI
- 1.9Power BI Practical Task
- 1.10Power BI Pro Tip
- 1.11Power BI Learning Outcome
- 1.12Quiz 1Copy10 Minutes13 Questions
- Module 2 – Data Extraction & Connectivity8
- Module 3 – Data Cleaning & Transformation7
- Module 4 – Data Modelling & Relationships11
- Module 5 – Advanced DAX and Calculations12
- 5.1DAX Syntax and Context (Row vs Filter)
- 5.2Calculated Columns, Measures, Tables
- 5.3DAX Operators and Logical Expressions
- 5.4Aggregations: SUM, COUNT, AVERAGE
- 5.5Iterators: SUMX, AVERAGEX, COUNTX
- 5.6Filter Functions: CALCULATE, FILTER, ALL, ALLEXCEPT
- 5.7Relationship Functions: RELATED, USERELATIONSHIP, CROSSFILTER
- 5.8Time Intelligence: YTD, QTD, MTD, PREVIOUSYEAR, NEXTMONTH
- 5.9Ranking, cumulative totals, KPIs
- 5.10Practical Task
- 5.11Pro Tip
- 5.12Learning Outcome
- Module 6 – Data Visualization & Dashboards10
- 6.1Types of visuals: Table, Matrix, KPI, Card, Chart, Map, etc.
- 6.2Customizing visuals and themes
- 6.3Filters, slicers, and hierarchy-based analysis
- 6.4Drill-through and bookmarks
- 6.5Page navigation, buttons, and selection pane
- 6.6Conditional formatting and custom tooltips
- 6.7Power BI Q&A and AI visuals
- 6.8Practical Task
- 6.9Pro Tip
- 6.10Learning Outcome
- Module 7 – Power BI Service, Security & Deployment13
- 7.1Power BI Service Overview
- 7.2Workspaces, Reports, Dashboards, Apps
- 7.3Power BI License Types (Free, Pro, Premium)
- 7.4Publishing and sharing reports
- 7.5Scheduling data refreshes
- 7.6Data Gateway setup and management
- 7.7Deployment pipelines: Dev → Test → Prod
- 7.8Row-Level Security (RLS): static & dynamic
- 7.9Collaboration in Service
- 7.10Usage metrics, alerts, and subscriptions
- 7.11Practical Task
- 7.12Pro Tip
- 7.13Learning Outcome
- Capstone Projects & Interview Preparation4
What is Power BI? Overview and key features
Understanding Business Intelligence concepts and importance
Next