Power BI - Basics to Advanced Course Contents

...

Power BI - Course Contents

Module 1: Introduction to Power BI (Basics)
  • What is Business Intelligence (BI)?
  • Overview of Power BI Ecosystem
  • Power BI Desktop vs Power BI Service
  • Installing & Setting up Power BI Desktop
  • Power BI Interface Tour
  • Importing Data from Excel, CSV, Web, Databases
Module 2: Data Loading & Transformation (Power Query)
  • Understanding ETL (Extract, Transform, Load)
  • Power Query Editor Overview
  • Data Cleaning Techniques
  • Remove Errors
  • Remove Duplicates
  • Replace Values
  • Split Columns
  • Merge Queries & Append Queries
  • Data Types, Filters & Sorting
  • Using Parameters in Power Query
Module 3: Data Modeling (Intermediate)
  • Star Schema vs Snowflake Schema
  • Creating Relationships
  • Cardinality & Cross Filter Direction
  • Creating Date Table
  • Understanding Fact & Dimension Tables
  • Model Optimization Best Practices
Module 4: DAX (Data Analysis Expressions)
  • Basic DAX:
    • Calculated Columns vs Measures
    • Basic Functions: SUM(), COUNT(), AVERAGE(), DISTINCTCOUNT()
    • Text Functions, Logical Functions
  • Intermediate DAX:
    • Time Intelligence Functions
    • CALCULATE(), FILTER(), ALL(), ALLEXCEPT()
    • IF, SWITCH, RELATED, RELATEDTABLE
  • Advanced DAX:
    • Advanced Time Intelligence
    • Ranking Functions
    • Dynamic Measures
    • Virtual Tables
    • Troubleshooting DAX
Module 5: Data Visualization (Reports)
  • Visual Types & Use Cases
  • Tables, Matrices, Card Visuals
  • KPI & Gauge Charts
  • Bar Charts, Line Charts, Pie & Donut Charts
  • Slicers & Filters
  • Drill-through, Drill-down & Tooltips
  • Bookmarks & Page Navigation
  • Custom Visuals
Module 6: Power BI Service (Online)
  • Publishing Reports to Power BI Service
  • Creating & Managing Workspaces
  • Dashboards vs Reports
  • Power BI App
  • Sharing Reports & Permissions
  • Data Alerts
Module 7: Data Refresh & Automation
  • Scheduled Refresh
  • Incremental Refresh
  • Dataflow Introduction
Module 8: Security
  • Testing Roles
Module 9: Advanced Features
  • What-If Parameters
  • Field Parameters (Dynamic Visuals)
  • Drillthrough & Tooltip Pages
  • Sync Slicers
  • AI Visuals (Key Influencers, Decomposition Tree)
  • Python & R Integration (Optional)
Module 10: Exporting & Integration
  • Export to PDF, PPT, Excel
Module 11: Final Project
  • Real-Time Business Dashboard
  • Sales, Finance, HR or Operations Dashboard (Choose any one)
  • Complete end-to-end workflow from raw data to dashboard