Module 1: Introduction to Power BI

• What is Business Intelligence (BI)?
• Introduction to Microsoft Power BI
• Components of Power BI (Power Query, Power Pivot, Power View, Power Map)
• Power BI Desktop & Power BI Service Overview
• Installation & Interface Tour

Module 2: Power Query – Data Extraction & Transformation

• Importing Data from Excel, Web, SQL, PDF, CSV
• Data Cleaning & Transformation
• Removing Errors & Duplicates
• Column Splits, Merges, Replace Values
• Data Shaping & Formatting
• Advanced Data Transformation

Module 3: Data Modeling

• Understanding Data Models
• Star & Snowflake Schema
• Relationships: One-to-Many, Many-to-One
• Active vs Inactive Relationships
• Calculated Columns & Measures
• Hierarchies

DAX (Data Analysis Expressions)

• Introduction to DAX
• Calculated Columns vs Measures
• Aggregation Functions (SUM, AVG, MIN, MAX)
• Time Intelligence Functions
• Logical & Text Functions
• Filter Functions
• Advanced DAX Concepts

Module 5: Data Visualization

• Creating Reports & Dashboards
• Using Visuals Effectively
• Pie Charts, Bar Charts, Line Charts, Donut Charts
• Cards, KPIs, Gauges
• Maps & Geographic Visuals
• Slicers & Filters
• Custom Visuals in Power BI

Module 6: Advanced Power BI Features

• Drill-Through & Drill-Down
• Bookmarks & Page Navigation
• Tooltips (Custom Tooltips)
• Report Themes
• Row-Level Security (RLS)
• Q&A Visual
• AI Insights

Module 7: Power BI Service (Cloud)

• Publishing Reports
• Workspaces
• Sharing Dashboards
• Apps in Power BI
• Scheduled Data Refresh
• Collaboration Features

 Module 9: Projects

Students will build 3–5 live dashboards, such as:

• Sales Performance Dashboard
• HR Analytics Dashboard
• Financial Dashboard
• Inventory Management Dashboard
• Marketing & Social Media Dashboard