The Vrinda Store wants to create an annual sales report for 2022. So that, the owner of the Vrinda can understand their customers and grow more sales in 2023 & 2024.
-
Compare the sales and orders using single chart.
-
Which month got the highest sales and orders?
-
Who purchased more-men or women in 2022?
-
What are different order status in 2022?
-
List top 10 states contributing to the sales?
-
Relation between age and gender based on number.
-
Which channel is contributing to the sales?
-
Highest selling category?
-
Percentage of Total Orders delivered
-
Dashboard Interaction view Dashboard
- Verify data for any missing value and anomalies, and sort out the same.
- Made sure data is consistent and clean with respect to data type, data format and values used.
- Created pivot table according to the questions asked.
- Merge all pivot table into one dashboard and apply slicer to make dynamic.
- Women are more likely to buy compared to men (~65%)
- The states of Maharashtra, Karnataka and Uttar Pradesh are the top 3 product buyers.
- The adult age group (30-49 years) is max Contributing (~50%) and buys the most products.
- The maximum number of products customer orders from Amazon, Flipkart and Myntra Channels.
- More than 90% of the products delivered
To improve the sales of Vrind Store, a strategic marketing plan focused on woman aged 30-49 years Residing in Maharashtra, Karnataka and Uttar Pradesh should be implemented. This demographic Represents a key consumer segment, as they often make significant household and lifestyle Purchases. The approach should include targeted digital marketing campaigns and personalized Promotions to capture their attention.