Summary
Power Query empowers the modern Excel analyst to create a set of reusable instructions to automate repetitive cleaning and transformation steps that are used to prepare disparate data sources for analysis. This is the first step toward creating a well-organized data model by using the modern analytics suite of tools. In this module, you learned how to launch the Power Query Editor from within Excel and how the UI can help you perform common data cleaning and transformations, among several other abilities that Power Query offers. Your next step is to continue your learning journey by exploring how Power Query can transform your most difficult data challenges.
Reference links
For more information, select the following links: