Get startedGet started for free

Transforming sales data for analysis

Now that you've combined many tables to accumulate the sales dataset for the company, you will need to transform it to a shape that is suitable for financial analysis. The company's financial department works with separate models for each region so you will need to aggregate the data by region. They are also interested in knowing who the top performing salesperson is for each region.

If you lost any progress, load the workbook 2_4_sales_analysis.pbix from the Exercises folder on the Desktop.

This exercise is part of the course

Data Transformation in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise