Module 1 — Introduction to Power BI

Topics:

• What is Power BI?
• Components of Power BI ecosystem
• Power BI Desktop vs Service
• Business Intelligence concepts
• Power BI workflow overview

Hands-on:

• Navigating the Power BI interface
• Importing first dataset

Module 2 — Connecting and Loading Data

Topics:

• Data sources supported in Power BI
• Import vs DirectQuery
• Connecting to:
  • Excel
  • CSV
  • Databases
• Data refresh concepts

Hands-on:

• Connect to multiple datasets
• Load and preview data

Module 3 — Data Transformation with Power Query

Topics:

• Introduction to Power Query
• Cleaning data
• Removing duplicates
• Changing data types
• Splitting and merging columns
• Appending and merging queries

Hands-on:

• Clean messy business data
• Build reusable transformation steps

Module 4 — Data Modeling

Topics:

• Relationships
• Star schema basics
• Fact and dimension tables
• Cardinality
• Model view best practices

Hands-on:

• Create relationships between tables
• Build a simple data model

Module 5 — Data Visualization & Dashboard Design

Topics:

• Charts and visuals
• Slicers and filters
• Drill-down functionality
• KPI cards
• Formatting and themes
• Dashboard design best practices

Hands-on:

• Build an interactive sales dashboard

Module 6 — Introduction to DAX

Topics:

• What is DAX?
• Measures vs calculated columns
• Basic DAX functions:
  • SUM
  • CALCULATE
  • IF
  • DIVIDE
  • COUNTROWS
• Time intelligence basics

Hands-on:

• Create KPIs using DAX measures

Module 7 — Publishing & Sharing Reports

Topics:

• Publishing to Power BI Service
• Sharing dashboards
• Exporting reports
• Workspace basics
• Security considerations

Hands-on:

• Publish and share a report

Module 8 — Mini Project / Capstone Exercise

Activities:

• End-to-end dashboard creation
• Apply data cleaning, modeling, visualization, and DAX
• Presentation of participant dashboards