Day 1 – Getting Started with Power BI

• Introduction and Overview of Power BI
• Understanding Power BI Interface and Components
• Loading data into Power BI
• Creating first basic visualization (Chart & Table View)

Day 2 – Data Cleaning with Power Query Editor

• Understanding Power Query Interface
• Extract & Transform data (Column from Example)
• Split Columns / Rows
• Clean, Merge and Append Tables

Day 3 – Advanced Data Cleaning & Modeling

• Unpivot data for better analysis
• Create Custom & Conditional Columns
• Generate Calendar Table using List.Dates()
• Build Basic Data Model using Relationships

Day 4 – Date Intelligence & Dashboard Basics

• Create Calendar Table using CALENDARAUTO()
• Add Month, Quarter, Year, and Weekday Columns
• Create Basic Measures and Cards
• Build “Target vs Actual Sales” Dashboard using
  Visuals, Slicers, Filters, and Cards

Day 5 – DAX Basics & Calculations

• Difference between Measures and Calculated Columns
• Create and test basic Calculated Fields
• Practice simple DAX functions for analysis

Day 6 – Final Project: HR Dashboard

• Combine all features learned throughout the course
• Create a complete HR Dashboard with visuals, slicers, and filters
• Final review and discussion on Power BI career path

Learning Outcomes

By the end of this 6-day class, you will be able to:

• Import, Clean, and Transform data in Power BI
• Create Data Models and Relationships
• Write Basic DAX Measures
• Design Interactive Dashboards
• Understand real-world reporting workflow