The Vrinda Store wants to create an annual sales report for 2022. So that, the owner of the Vrinda store can understand their customers and grow more sales in 2023.
- Compare the sales and orders using single chart
- Which month got the highst 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 of orders
- Which channel is contributing to maximum sales?
- Highest selling category?
- Verify data for any missing values and anomalies, and sort out the same.
- Made sure data is consistent and clean with respect to data type, data format and values used.
- Create additional column like Age Group and Month required for data analysis.
- Created pivot tables and Charts according to the questions asked.
- All charts created using pivot tables merge into one dashboard and apply slicer to make dashboard interactive and dynamic.
- Women customers are more likely to buy compared to men (~65%)
- The states of Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (~35%)
- The Adult age group (30-49 yrs) is max contributing (~50%)
- 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.