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.