Transforming data

Now that you have successfully imported all the data into Power Query Editor, it's time to explore and clean the raw data to prepare it for reporting.

In this exercise, you will perform various Query Editor transformations, including filling null values, changing data types, splitting columns, and more.

We do not recommend doing so, but if you lost progress, you can load the solution workbook of the previous exercise 1_1_loading_data_solution.pbix from the Exercises folder.