In this course, Ross Hughes leans on 30+ years of working with data to teach you the amazing Power Query Tool. It starts easy but soon goes deep into using Power Query to gather and transform your data with joins, un-pivoting and M-language which will make your analysis & reporting much easier.
Course Curriculum
(Click for details)
MODULE 1: GETTING STARTED WITH POWER QUERY
1.1 Introduction to Power Query 1.2 Getting Familiar with the Power Query Editor 1.3 First Data Clean Up for a Pivot Table 1.4 Tweaking our Query until the data is correct 1.5 Rounding data 1.6 Altering Data Types 1.7 Filtering out data before we load it 1.8 Advanced Calculated Columns 1.9 Grouping Columns 1.10 Using Columns From Examples
MODULE 2: TRANSPOSE, PIVOT AND UN-PIVOT
2.2 Pre-preparing messy data 2.3 Appropriating our data with Transpose 2.4 Un-Pivoting Data 2.5 Pivoting Data 2.6 Creating a Pivot Chart
MODULE 3: COMBINING DATA FROM TWO OR MORE DATA SETS
3.1 Appending data 3.2 Introduction to Merging data 3.3 Left Outer Join 3.4 Right Outer Join 3.5 Full Outer Join 3.6 Inner Join 3.7 Left Anti Join 3.8 Right Anti Join 3.9 More appending with bigger data sets 3.10 Going deeper with Merging data
MODULE: 4.DUPLICATION AND PARAMETERS
4.1 Duplicating Queries 4.2 Speeding up query editing with duplication 4.3 Filtering duplicated queries 4.4 Working with References 4.5 Parameters
MODULE 5: STEPS, GROUPS AND DEPENDENCIES
5.1 Functions 5.2 Dealing with Errors 5.3 Steps Part 1: Troubleshooting Queries 5.4 Steps Part 2 5.5 Queries and Groups 5.6 Advanced Query Editor 5.7 Query Refresh 5.8 Dependencies 5.9 Revisiting Combining Queries