Course Syllabus
POWER BI
1: Introduction to Power BI, Installation, Interface & Navigation
2: Get Data (Excel, CSV, Text), Import Data
3: Power Query Basics – Data Cleaning, Rename, Remove Columns, Data Types
4: Power Query Advanced – Split, Merge, Replace Values, Fill Up/Down
5: Append Query, Merge Query & Close & Apply
6: Data Modeling & Relationships
7: Star Schema & Practice Dataset
8: DAX Introduction, Calculated Column & Measure
9: Basic DAX Functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT)
10: IF, SWITCH, DIVIDE & Variables
11: Date Table & Time Intelligence Basics
12: Card, KPI Card & Multi Row Card
13: Table & Matrix Visual
14: Bar Chart, Column Chart & Line Chart
Day 15: Pie Chart, Donut Chart & Tree map
16: Map Visuals & Filled Map
17: Gauge, Funnel & Waterfall Chart
18: Slicer, Hierarchy Slicer & Sync Slicer
19: Drill Down, Drill Through & Tooltip
20: Conditional Formatting & Data Bars
21: Visual, Page & Report Level Filters
22: Bookmarks, Selection Pane & Buttons
23: Page Navigation & Interactive Dashboard
24: Advanced DAX – CALCULATE, FILTER & ALL
25: TOPN, RANKX, Running Total, YTD & MTD
26: Dashboard Formatting & Design Tips
27: Sales Dashboard Project
28: HR Dashboard Project
29: Interview Questions, Practice Test & Viva
30: Final Dashboard Project, Power BI Service, Publish Report & Certificate Test
Practical Projects & Assessment
· Real-World Project
· Quiz + Practical Assignment
· Final Assessment & Certification
Bestseller
