The Store wants to create an annual sales report for 2022. So that the owner of the Store can understand the customers and grow more sales in 2023 and 2024.
- 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?
- Percentage of Total Orders delivered.
Dashboard Interaction View Dashboard
- 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.
- Created pivot tables according to the questions asked.
- Merge all pivot tables into one dashboard and apply slicer to make dynamic.
- 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.
- More than 90% of the products delivered.
To improve the sales of Store, a strategic marketing plan focused on women 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.