This project consists of an excel dashboard on the Super Store data. Concepts like Excel functions, Pivot Tables, Excel charts, etc were used in this. Along with the dashboard, it presents some business insights in a report created on a separate worksheet.
Find 3 Key Findings and 3 Key Solutions to increase the Sales in Super Store.
The first tab of the excel file contains the dashboard which displays various charts and vizuals. The second tab of the file has the report with key findings and suggestions. Rest of the tabs have additional information referred by the second tab.
- Super Store is giving a lot of discounts on Binders, despite it already being one of their top selling products in all the customer segments across all regions.
- Super Store is spending too much of their discount budget on their stores in Central region. Stores especially in Southern region are comparatively lacking in discounts.
- Only one product was sold in 50.65% of the total orders.
- Delivery duration in Central region is comparatively slow. Average delivery in Central region takes 0.21 days more for Home Office consumers than overall delivery duration average for the same.
- Discounts should be reduced from Binders (Sub-category) or Office supplies (Category) in general, as they have decent enough sales. Discount budget should be disbursed to the stores in Southern region for sales spree to attract customer attention.
- In case of their online stores, investment shall be made on machine learning techniques so that people buying only one product from a category shall be recommended with other related products from that same category.
- In case of offline stores, Super Store shall invest in Planograms (Product Display). More information about how planograms leading to improved sales can be found in the referred link.
- Delivery duration should be reduced in the stores in Central region by introducing ship mode upgrades wherever it's possible. Decreased delivery duration may lead to increase in sales.