Course Number: ISI-1522

Collect, combine and transform data

Description

Using Power Query you can import, reshape and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI and other Microsoft products. Discover how to eliminate time-consuming manual data preparation, solve commons problems, avoid pitfalls and more

Prerequisites

Before attending this course, students must have:

-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of relational databases.
-Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
-Basic knowledge of data analytics equivalent to having attended course 10994.

List Price

$1595.00

Upcoming Classes

Available classes for Collect & Transform Data Using Power Query in Excel & Power BI
Start Date End Date Class Status Days Location Start Time
04/21/2026 04/22/2026 Seats Available Consecutive days Live Online 9:00am Enroll
06/23/2026 06/24/2026 Seats Available Consecutive days Live Online 9:00am Enroll
08/03/2026 08/04/2026 Seats Available Consecutive days Live Online 9:00am Enroll
10/20/2026 10/21/2026 Seats Available Consecutive days Live Online 9:00am Enroll
01/05/2027 01/06/2027 Seats Available Consecutive days Live Online 9:00am Enroll
All class times are Pacific Time Zone.