Description

Introduction
This training focuses on the core ETL (Extract, Transform, Load) capabilities of Power BI using Power Query. Participants will learn to connect to multiple data sources, clean and transform raw data, and prepare it for analysis. The course emphasizes hands-on exercises to build practical skills for real-world BI scenarios.

Prerequisites

• Basic understanding of Power BI Desktop

• Familiarity with Excel or other spreadsheet tools

• Basic knowledge of databases and data types

Table of Contents
1. Introduction to Power Query
1.1 What is Power Query and its role in Power BI
1.2 Understanding ETL in BI workflows
1.3 Overview of Power Query interface and editor

2. Connecting to Data Sources
2.1 Importing data from files (Excel, CSV, Text)
2.2 Connecting to databases (SQL Server, Access, Oracle)
2.3 Accessing online data (Web, APIs, SharePoint)

3. Data Transformation Basics
3.1 Cleaning data: handling missing values and errors
3.2 Filtering, sorting, and grouping data
3.3 Renaming, splitting, and merging columns

4. Advanced Data Transformations
4.1 Pivoting and unpivoting tables
4.2 Creating calculated columns and custom transformations
4.3 Using parameters and conditional logic

5. Introduction to M Language
5.1 Understanding the M query language syntax
5.2 Editing queries with Advanced Editor
5.3 Creating reusable transformations with M

6. Combining and Shaping Data
6.1 Merging queries for relational data
6.2 Appending queries for stacking datasets
6.3 Managing query dependencies and refreshes

7. Optimizing Power Query Workflows
7.1 Best practices for performance and efficiency
7.2 Documenting transformations for collaboration
7.3 Debugging and troubleshooting queries

8. Hands-On Scenarios
8.1 Cleaning sales and customer data
8.2 Preparing datasets for dashboards and reports
8.3 Automating ETL processes in Power BI

By the end of this training, participants will be able to efficiently extract, clean, and transform data using Power Query, and create robust ETL pipelines that feed clean, analysis-ready datasets into Power BI reports and dashboards.