# Power Query Bootcamp

Canonical URL: <https://www.graduateschool.edu/courses/power-query-course>

## Overview

In this hands-on course, you’ll learn to prepare data efficiently with Power Query in Excel and Power BI. Explore the Power Query Editor to import, clean, and transform datasets; reshape information with tools like Pivot and Un-Pivot; and combine data from multiple sources using joins. You’ll also practice automating queries, using parameters, and optimizing workflows, giving you the skills to streamline data preparation for analysis and reporting.

## 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 — Live Online
- Sep 18, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $299