Overview

Power Query, an integral business intelligence tool within Excel, facilitates the seamless import of massive datasets into the data model within a single workbook. Employing a user-friendly graphical interface and the Power Query Editor, it enables the retrieval of data from diverse sources, subsequently allowing for comprehensive cleaning, transformation, and reshaping according to specific requirements. By establishing a query once—with the option to save all steps—you can effortlessly reuse it, refreshing the data whenever updates occur. This not only streamlines the data cleaning process but also minimizes the likelihood of manual errors.

Objectives

The objectives of this 2-days training program are as follows:

1. Able to Extract, Transform, Load data from external sources into working Excel file
2. Able to use Power Query application in Excel to consolidate and merge data from multiple tables
3. Able to use Power Pivot application in Excel to manage data table relationships