# Power Query Bootcamp (Self-Paced)

Canonical URL: <https://www.nobledesktop.com/classes/power-query-course-online>

## Overview

This course teaches students how to prepare and manage data using Power Query through a structured, step-by-step approach. Participants will learn to apply data transformations, reorganize datasets with pivoting and reshaping tools, and combine information from multiple files and tables.

The course also emphasizes building summarized views with grouping and conditional logic, creating new columns from examples, and maintaining organized queries through duplication, applied steps, dependencies, and data refresh processes.

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

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