POWER BI COURSE CONTENT
1️⃣ Power BI Desktop Introduction
- What is Power BI?
- Products & pricing (Pro, Premium, Desktop)
- Download & install Power BI Desktop
- User interface walkthrough
2️⃣ Data Source Connection
- Importing Excel, text/CSV, folders
- Loading Data vs Transform
- Intro to M‑Query Editor
- Applied steps, queries pane
3️⃣ Data Cleaning & Transformation
- Header promotion
- Renaming, replacing nulls
- Filter rows/columns
- Splitting & merging data
- Unpivot/pivot columns
- Creating calculated columns
4️⃣ Data Modeling & DAX
- Creating relationships
- Star schema vs snowflake
- DAX calculated columns
- DAX measures (SUM, COUNT, etc.)
- Date filter & slicer
5️⃣ Report Design & Visualization
- Visual types: table, chart, map, KPI
- Slicers, filters & drill-downs
- Formatting visuals & interactivity
- Bookmarks & publishing
6️⃣ Cloud Publishing & Gateways
- Publishing to Power BI Service
- Data refresh & scheduling
- Installing & configuring on-premise gateway
- Workspace deployment
- Basic permission management
