GETTING STARTED WITH POWER QUERY
Introduction to Power Query
Getting Familiar with the Power Query Editor
First Data Clean Up for a Pivot Table
Tweaking our Query until the data is correct
Rounding data
Altering Data Types
Filtering out data before we load it
Advanced Calculated Columns
Grouping Columns
Using Columns From Examples
TRANSPOSE, PIVOT AND UN-PIVOT
Pre-preparing messy data
Appropriating our data with Transpose
Un-Pivoting Data
Pivoting Data
Creating a Pivot Chart
COMBINING DATA FROM TWO OR MORE DATA SETS
Appending data
Introduction to Merging data
Left Outer Join
Right Outer Join
Full Outer Join
Inner Join
Left Anti Join
Right Anti Join
More appending with bigger data sets
Going deeper with Merging data
4.DUPLICATION AND PARAMETERS
Duplicating Queries
Speeding up query editing with duplication
Filtering duplicated queries
Working with References
Parameters
STEPS, GROUPS AND DEPENDENCIES
Functions
Dealing with Errors
Steps Part 1: Troubleshooting Queries
Steps Part 2
Queries and Groups
Advanced Query Editor
Query Refresh
Dependencies
Revisiting Combining Queries