# Power Query Bootcamp (Self-Paced)

Canonical URL: <https://www.graduateschool.edu/courses/power-query-bootcamp-self-paced>

## Overview

Learn how to efficiently clean, organize, and reshape data using Power Query, a powerful feature built into Excel and Power BI. In this hands-on, self-paced course, you’ll streamline data preparation for analysis and reporting by importing datasets, setting data types, filtering unwanted information, and creating calculated columns to support clearer insights.

You’ll also work with tools such as Pivot, Unpivot, append, and merge to transform and combine data from multiple sources using common join types. The course covers ways to automate and optimize workflows by duplicating and referencing queries, using parameters, managing query dependencies, and troubleshooting with the Advanced Query Editor to support repeatable, reliable reporting.

## What you'll learn

- Navigate the Power Query Editor to clean and prepare raw data for analysis in Excel and Power BI
- Shape and transform data by adjusting data types, rounding values, and filtering records
- Apply advanced tools such as calculated columns, grouping, and creating columns from examples
- Restructure datasets using Transpose, Pivot, and Unpivot techniques to support reporting needs
- Combine data from multiple sources with joins and appends, including inner, outer, and anti joins
- Automate and refine workflows using query 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

## Pricing

**Tuition:** $299