Get startedGet started for free

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.

This exercise is part of the course

Case Study: Competitor Sales Analysis in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise