Power Query Bootcamp

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