Retail sales analysis

About this project

Retail store sales management wants to do sales analysis based on the sales data of for the years 2019 to 2021. The analysis includes trend analysis, Salesperson analysis, Top N products , Top N productgroups, Channel wise sales etc.

The analysis includes data cleaning, transformation, analysis and visualization with multiple dynamic parameters.

Technology used: Microsoft power BI, Excel, CSV files

The key insights:

1. Budget and revenue both decreased in 2021 compared to 2019/2020.
2. Wheat flower, oil, yeasts are the three top product groups and Tomato sauce, tea and cassava startch are three bottom product groups in terms of revenue.
3. Product 1968, 2026, 662 are the top 3 product and product 2598, 1834, 2398 are the bottom 3 product s in terms of revenue.
4. Carla, Julio , Gustavo are the top 3 sales performers and Julieta, Estevan, Julia are the bottom 3 sales performers in terms of revenue.