Learn Microsoft
Power Bi
Course Contents
Module 1: Introduction to Power BI
- What is Power BI?
- Importance and application of BI tools
- Power BI vs Excel vs Tableau
- Power BI Ecosystem (Power BI Desktop, Service, Mobile)
- Installing and setting up Power BI Desktop
Module 2: Power BI Desktop Overview
- User Interface Tour
- Working with Workspaces
- Understanding File Types: PBIX, PBIT, PBIP
Module 3: Data Sources and Connections
- Connecting to different data sources:
- Excel, CSV, SQL Server, Web, SharePoint, Google Sheets, etc.
- Import vs DirectQuery vs Live Connection
- Data Refresh Mechanisms
Module 4: Power Query Editor – Data Cleaning & Transformation
- Power Query Editor overview
- Data types & columns
- Remove duplicates, nulls, blanks
- Merge, Append, Transpose Tables
- Column splitting, Conditional columns
- Grouping, Pivot/Unpivot
- Using Parameters & Custom Functions
Module 5: Data Modeling in Power BI
- Star vs Snowflake Schema
- Relationships (One-to-many, many-to-one)
- Cardinality & Cross-filter direction
- Create Calculated Columns & Measures
- Hierarchies and Sorting
Module 6: DAX (Data Analysis Expressions)
- Introduction to DAX
- Calculated Columns vs Measures
- Common DAX Functions:
- Aggregation: SUM, AVERAGE, COUNT
- Logical: IF, SWITCH
- Time Intelligence: YTD, MTD, SAMEPERIODLASTYEAR
- Filter: CALCULATE, FILTER, ALL
- Variables and Optimisation
Module 7: Data Visualization & Dashboarding
- Charts: Bar, Line, Pie, Combo, Waterfall, KPI, Doughnut, Card, TreeMap, Gauge
- Matrix vs Table
- Slicers, Filters, and Bookmarks
- Custom Visuals (Marketplace)
- Conditional Formatting
- Tooltips and Drill-through
Module 8: Advanced Visual Interactions
- Drill-down & Drill-up
- Sync Slicers Across Pages
- Dynamic Titles and Axis
- Buttons & Navigation
- Tooltips using report pages
Module 9: Power BI Service (Cloud)
- Publishing to Power BI Service
- Workspaces, Dashboards, Reports, Apps
- Creating & Sharing Dashboards
- Scheduling Data Refresh
- Row-Level Security (RLS)
- Usage Metrics & Report Insights
Module 10: Power BI with Excel & Other Tools
- Importing Excel models to Power BI
- Analysing Power BI data in Excel
- Using Power BI with PowerPoint, Teams, and SharePoint
- Power BI & Python/R Integration (Intro)
Module 11: Real-time Dashboards & Streaming Data
- What is real-time data in Power BI
- Streaming Datasets
- Pushing data using APIs or Power Automate
Module 12: Power BI + AI Features
- Q&A Visuals
- Decomposition Tree
- Smart Narrative
- Key Influencers
- Forecasting & Anomaly Detection
Module 13: Security, Governance, and Administration
- Q & A Visuals
- Decomposition Tree
- Smart Narrative
- Key Influencers
- Forecasting & Anomaly Detection
Module 14: Power BI Best Practices
- Naming Conventions
- Folder Structure & Documentation
- Performance Optimisation Tips
- Error Handling & Troubleshooting
Module 15: Capstone Project
- Real-world business use case
- Build ETL, model, visuals, and publish a report
- Presentation & Evaluation