Compare Classes & Certificates

Which course is right for you? This tool allows you to compare any class or certificate program in our catalogue with the important information you need to make the right decision.

Remove
Key Information
Power Query Bootcamp
$299 6 Hours
Learn More
Download Syllabus
Overview
Learn to clean, organize, and reshape data quickly with Power Query, a powerful tool built into Excel and Power BI. This hands-on course will teach you how to streamline your data preparation process for analysis and reporting.
Prerequisite
Participants should have knowledge equivalent to our Excel Bootcamp.
Location
Live Online or Live Online
Schedule
Next start date: June 18, Thursday, 10–5pm
Other scheduling options Weekdays only
View full schedule
Certification
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Financing See our Climb Credit FAQ for more details
Target Audience
Anyone
What You’ll Learn
  • Navigate the Power Query interface, understand the data analysis process, and work with Power Query options, applied steps, and refresh behavior.
  • Clean and transform data by filtering rows, removing and reordering columns, changing data types, splitting and merging columns, and applying text cleanup techniques.
  • Create structured transformations using grouping, conditional columns, date and duration calculations, and columns generated from examples.
  • Reshape datasets using Pivot, Unpivot, Transpose, and split-to-rows techniques to support analysis and reporting.
  • Combine data from multiple sources by appending tables, worksheets, and CSV files, and merging data using inner and anti joins.
  • Organize and manage queries by duplicating and referencing queries, handling errors and values, removing duplicates and blank rows, and working with query dependencies.

Add Class or Certificate to Compare