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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
