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
185 Madison Ave, NYC or Live Online
Schedule
Next start date: September 18, Thursday, 10–5pm
Other scheduling options Weekdays only
View full schedule
Certification
Software Included
Microsoft Office (1 month)
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 Editor to clean and prepare raw data for analysis in Excel or Power BI.
  • Transform and shape data using techniques like altering data types, rounding values, and filtering rows.
  • Use advanced tools such as calculated columns, grouping, and column creation from examples.
  • Restructure datasets with Transpose, Pivot, and Un-Pivot tools to suit your reporting needs.
  • Combine data from multiple sources using joins and appends, including inner, outer, and anti joins.
  • Automate and optimize queries with duplication, parameters, query dependencies, and the Advanced Editor.

Add Class or Certificate to Compare

Yelp Facebook LinkedIn YouTube Twitter Instagram