# Power Query Bootcamp

Canonical URL: <https://training-nyc.com/courses/power-query-course>

## 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 show you how to streamline your process for analysis and reporting.

 
- **Master the Power Query Editor:** Get familiar with Power Query’s interface as you import and transform datasets. Practice altering data types, rounding values, and filtering out irrelevant rows before loading.
- **Transform and Reshape Data:** Use tools like Transpose, Pivot, and Un-Pivot to restructure data for better usability. Create calculated columns and group values to support your analysis.
- **Combine and Merge Datasets:** Append and merge data from multiple sources using a variety of join types, including inner, outer, and anti joins. Develop workflows that consolidate data.
- **Optimize and Automate Queries:** Duplicate and reference queries to save time, create parameters to automate tasks, and troubleshoot issues using the Advanced Query Editor. Learn to manage dependencies and streamline query refreshes.

## 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.

## Prerequisites

Participants should have knowledge equivalent to our [Excel Bootcamp](https://www.nobledesktop.com/classes/excel-bootcamp).

## Curriculum

#### Getting Started with Power Query

- The Data Analysis Process
- What Is Power Query?
- The Power Query Interface
- Power Query Options & Settings
- One – Extracting
- Two – Transforming
- Three – Loading
- Four – Refreshing
- Benefits of Power Query

#### Transpose, Pivot, and Un-Pivot

- Transformations Overview
- Introduction to Transforming Data
- Removing Rows by Filtering Data
- Removing, Renaming & Reordering Columns
- Loading Your Transformations
- Applied Steps
- Saving Transformations
- Data Type Transformations

#### Combining Data from Two or More Data Sets

- Relationships
- Appending Two Tables
- Appending Multiple Tables
- Query Organization
- Appending Multiple CSVs
- Appending Data with Different Column Headers
- Merging Tables
- Merging via Composite Columns
- Inner Joins
- Right & Left Anti Joins
- Appending Multiple Worksheets

#### Duplicating and Parameters

- Duplicate & Reference Queries
- Remove Duplicates
- Deleting Queries
- Replacing Errors & Values
- Removing Top/Bottom Rows
- Using First Row as Headers
- Removing Blank Rows

#### Steps, Groups and Dependencies

- Transformation Steps Level 1
- Splitting Columns
- Merging Columns
- Trim, Clean, and Changing Case
- Transformation Steps Level 2
- Filling Down
- Sorting
- Extracting
- Math Calculations
- Unpivot
- Pivot
- Transpose
- Split Columns into Rows
- Group By
- Grouping by Dates/Times
- Date/Duration Calculations
- Conditional Columns
- Columns from Examples
- Extracting from Data Sources
- Getting Data from Excel
- Getting Data from CSV
- Getting Data from PDF
- Getting Data from Websites

## Schedule
- Jun 18, 2026 10:00am–5:00pm — NYC
- Sep 18, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $299