Power BI

Duration: 3 weeks

1. Introduction to Power BI

• What is Power BI?

• Components of Power BI:

  • Power BI Desktop

  • Power BI Service (Cloud)

  • Power BI Mobile

    
    

• Why use Power BI (advantages over Excel & other tools)

• Installing Power BI Desktop

2. Power BI Basics

• Power BI interface (ribbons, panes, fields, filters)

  
  

• Importing data:

  
  

  • From Excel

  • From CSV

  • From databases (SQL Server, MySQL, etc.)

    
    

• Data sources overview (cloud, on-premise, APIs)

• Saving and sharing a PBIX file

3. Power Query (ETL in Power BI)

• Introduction to Power Query Editor

  
  

• Data transformation basics:

  
  

  • Remove/rename columns

  • Change data types

  • Filter rows

  • Split & merge columns

  • Remove duplicates

• Applied steps concept

4. Data Modeling

• Relationships between tables

• Primary key & foreign key concepts

• Star schema vs Snowflake schema (basic idea)

• Importance of data modeling in Power BI

• Creating relationships manually
  
  
  

5. DAX (Data Analysis Expressions) – Basics

• What is DAX?

• Difference between Calculated Columns and Measures

• Common DAX functions:

  
  

  • SUM(), AVERAGE(), COUNT(), MIN(), MAX()

  • CALCULATE() (basic use)

  • DISTINCTCOUNT()

    
    

• Simple calculated measures (e.g., Total Sales, Profit Margin)

6. Visualizations

• Types of visuals in Power BI:

  
  

  • Bar chart, Column chart, Line chart

  • Pie & Donut charts

  • Table & Matrix

  • Cards & KPIs

  • Maps

    
    

• Formatting visuals (colors, labels, legends)

• Filters, slicers & drill-through

• Creating dashboards with multiple visuals
  
  
  

7. Power BI Service (Cloud)

• Publishing reports from Power BI Desktop to Power BI Service dashboards in Service

• Sharing reports with others

• Basic understanding of workspaces

8. Projects

• Sales Dashboard (Excel data → Power BI)

• Student Performance Dashboard

• Simple HR Dashboard (Employees, Departments, Salaries)