Vrinda Store wants to create an annual sales report for 2022 so that Vrinda can understand its customers and increase sales in 2023.
- Microsoft Excel
- Download the dataset from Google Drive.
- Compare the sales and orders using single chart.
- Which month got the highest sales and orders?
- Who purchased more - Men or Women?
- What are different order status in 2022?
- List top 10 states contributingto the sales?
- Relation between age and gender based on number of orders.
- Which Channel is contributing maximum to the sales?
- Highest selling category?
- See the dashboard from Google Drive.
- Women customers are more likely to buy products compared to men (~65%).
- The states of Maharashtra, Karnataka and Uttar Pradesh are the top 3 product buyers.
- The adult age group (30-49 yrs) is max contributing (~50%) and buys the most products.
- The maximum number of products customer orders from Amazon, Flipkart and Myntra channels.
To improve sales of Vrinda Store, women customers of the age group (30-49 yrs) living in Maharashtra, Karnataka and Uttar Pradesh must be targeted by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.