Outlines
MICROSOFT EXCEL : POWER QUERY
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 :
Understanding Power Query
Importing data
Transforming data:
Cleaning and shaping data:
Combining data:
Automating data transformations:
Import/connect to external data from multiple sources.
Automate the data transformation & data cleansing processes.
Combine data from multiple sources into a single source.
Merging data without the need of formulas such as VLOOKUP, INDEX&MATCH.
Perform calculation to aggregate data.
Outcome
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
Introduction To Power Query
Appending Data From Multiple Sources / Formats
Merging Tables
Power Query Formulas
Transforming Data
Cleaning Dirty Data
