The Power of Power Query
How to import and transform data in Power BI and Excel
Not a Medium member? Access premium content for free on my website:
Let’s talk about making your life easier while working with multiple data sources and cleaning raw data, which is often messy and unstructured. To make sense of this data, you need a tool to transform, clean and shape data into meaningful analysis. Power Query is a data transformation and preparation tool that helps you reshape, clean, and combine data from multiple sources. It is a free, self-service ETL (extract, transform, load) tool built into Power BI and Excel.
With Power Query, you can collect multiple data sources, merge tables, pivot and unpivot columns, remove duplicates, and perform a variety of transformations using a user-friendly interface. But, that’s not it! Power Query allows you to use M code, used to create a custom function and perform advanced data transformations.
Let’s use Power Query together to clean and transform your data.