Course Objectives

Participants attending this course will learn about Power Query and its features, including the ability to import, transform, and clean data from various sources. The course also will teach how to import data from various sources, such as Excel spreadsheets, text files, databases, and web sources. Participants will understand how to transform data using Power Query, including filtering, sorting, grouping, and pivoting data.

Cleaning and shape data using Power Query, including removing duplicates, splitting and merging columns, and dealing with errors and inconsistencies in data will also be taught. Besides that, participants will learn how to combine data from multiple sources using Power Query, including merging and appending data, and using lookup functions. 

At the end of the course, participants will be taught how to automate data transformations using Power Query, including creating and managing queries

Below are listed training objectives :


Upon successful completion of this course, the delegate should be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data, perform data transformation and data cleansing.

Course Outline