Power Query Course Online

8 Lesson

35 Hours

Add to Wishlist

igmGuru offers the best Power Query Training online worldwide. Our course covers important modules such as Data Import & Transformation, Merging & Appending Data, Advanced Transformations, Parameters & Conditional Logic, Power Query in Power BI, and many more. This course syllabus is crafted by industry experts with over 15 years of experience in data analytics and BI tools, with practical hands-on projects. We have successfully trained 350+ professionals globally. Enroll in our Power Query certification course to master data preparation skills, streamline workflows, and prepare for relevant certifications.

Enroll Now

Overview

Power Query is a tool in Excel and Power BI that helps you easily get data, clean it, and organize it. In these Power Query classes, our trainers teach you how to automate these tasks so your data is ready for reports and analysis quickly.

Objectives of Power Query Course

Learn to import data from various sources (Excel, CSV, databases, web).
Understand how to clean and transform data efficiently.
Automate repetitive data preparation tasks.
Merge and append data from multiple tables or sources.
Apply data shaping techniques such as splitting columns, changing data types, and removing errors.
Load transformed data into Excel or Power BI for analysis.
Gain skills to build repeatable and dynamic data workflows.

Prerequisites

Basic Excel skills (worksheets, tables, formulas).
Understanding of data types (text, numbers, dates).
Familiarity with basic data cleaning tasks (removing duplicates, splitting columns).
Basic computer navigation skills (files, folders, copy/paste).
Optional but helpful: knowledge of pivot tables and basic database concepts (joins, tables).

Who Should Enroll?

Data analysts looking to automate data cleaning and transformation.
Excel users who work with large or multiple data sources.
Business professionals preparing reports and dashboards.
Power BI users aiming to streamline data preparation.
Anyone interested in learning efficient and repeatable data workflows.

What You Will Learn

Import data from Excel, CSV, databases, and web sources.
Clean and transform data by removing duplicates, fixing errors, and changing data types.
Merge and append tables from multiple sources.
Automate repetitive tasks using query steps.
Shape and structure data for reporting and analysis.
Load data into Excel or Power BI for further analysis.
Create repeatable and dynamic data workflows.

Tools and Technologies Covered

Power Query (Excel & Power BI).
Microsoft Excel (tables, formulas, and integration).
Power BI Desktop (data connection and visualization).
Data sources including CSV files, Excel files, databases, and web data.
Data transformation techniques such as merge, append, split, filter, and clean.
Optional: basic DAX for data modeling.

Career Opportunities After Completing Power Query Training

Data Analyst.
Business Analyst.
Power BI Developer.
Excel Specialist / Reporting Analyst.
ETL / Data Transformation Specialist.
Financial Analyst / Operations Analyst.

Key Features

1 On 1 Training Option Available
24 X 7 Lifetime Support & Access
Small Batches Upto 10 Participants
Experienced & Professional Trainers
100% Job Assistance
Flexible Schedule

Course Curriculum

Lesson 1 - Introduction to Power Query

1. What Power Query is and why it’s used

2. Power Query Editor interface

3. How Power Query works (ETL basics)

4. Accessing Power Query in Excel & Power BI

Lesson 2 - Getting & Importing Data

1. Import from Excel, CSV/Text files

2. Import from databases (SQL, Access)

3. Import from web pages and other sources

4. Understanding queries and refresh

Lesson 3 - Basic Data Transformations

1. Filtering and sorting data

2. Removing duplicates and errors

3. Changing data types

4. Splitting and merging columns

5. Renaming and reorganizing columns

Lesson 4 - Combining Data

1. Merging queries (joining tables)

2. Appending queries (stacking data)

3. Using folder import to combine multiple files

Lesson 5 - Table Operations

1. Grouping & aggregation

2. Pivot and Unpivot data

3. Transposing tables

4. Basic calculated columns and indexing

Lesson 6 - Advanced Transformations

1. Conditional logic and custom column rules

2. Parameters and dynamic filters

3. Error handling and profiling data

4. Reordering and staging transformation steps

Lesson 7 - M Language Basics (Optional/Advanced)

1. Understanding M formulas

2. Editing in Advanced Editor

3. Custom functions and reuse patterns

Lesson 8 - Loading & Automation

1. Loading data to Excel table/PivotTable or Power BI model

2. Refreshing queries automatically

3. Managing query dependencies and performance

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

Course Fees

Online Class Room Program

US $ 799.00

100% Money Back Guarantee

Duration : 35 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 17 Jun 2026
Weekday Batch 22 Jun 2026
Weekend Batch 20 Jun 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Power Query Certification

After completing the Power Query Course and hands-on practical exercises, learners will receive a Course Completion Certificate. This certification validates your proficiency in importing, cleaning, and transforming data from multiple sources, merging and appending tables, performing advanced data transformations, automating repetitive data tasks, preparing data for reporting and analysis, and integrating datasets for use in Excel or Power BI in real-world business scenarios.

Reviews

Login

Email ID*

Password*

Forgot Password?

Power Query Course Online