Summary
This has been a very long chapter as we went through special uses of Power Query – how it allows you to connect directly to over 100 data sources and carry out data transformations. We went through some common transformations such as appending data, merging data, unpivoting columns, filling series, and replacing values. I also shared with you some important tips to keep in mind as you work toward boosting your competence in the use of Power Query. Lastly, we examined how to load your transformed data and get a hang of the M code that powers everything in Power Query.
In the next chapter, we will explore the use of PivotTables and Power Pivot to create the analysis and dashboards you desire after using Power Query to pull in the clean data required.
