Morning Session>>

1) Introduction to Power BI basics and interface overview.

2) Types of data sources supported by Power BI.

3)Importing data from Excel, CSV files, Databases

4) Direct Query vs. Import Mode.

5) Hands-on Exercise: Connect to a sample dataset.

6) Introduction to Power Query Editor.

7) Data cleaning techniques: Removing duplicates, handling missing values, splitting and merging columns

8) Transforming data: Filtering rows, changing data types, creating calculated columns

9) Hands-on Exercise: Clean and prepare a dataset.

10)What is data modelling & creating relationships between tables.

11) Understanding primary and foreign keys.

12) Introduction to DAX (Data Analysis Expressions)

13) Hands-on Exercise: Build a simple data model.

Afternoon Session>>

14) Overview of visualization types:

  • Bar charts, line charts, pie chartsMaps, tables, and matrices

  • Customising visuals: Formatting options, adding filters and slicers

  • Hands-on Exercise: Create a dashboard with multiple visuals.

15) Publishing reports to Power BI Service.

  • Sharing dashboards with others.

  • Setting up automatic data refresh.

  • Hands-on Exercise: Publish and share a report.Overview of visualization types:

16)Participants work on a mini-project using a sample dataset:

  • Clean the data

  • Create a data model

  • Develop visualizations

  • Publish and share their report