Excel_Vindra_Store_Analysis

Objective 🎯 :

At Vindra Store, mission is crystal clear: aim to create an Annual Sales Report for 2022 that not only reveals insights into our customers but also sets the stage for unprecedented sales growth in 2023 and beyond.

Insights:

1. Women are more likely to buy compared to Men(~65%)
2. Maharashtra, Karnataka and Uttar Pradesh are the top 3
3. Adult age group(30-49yrs) is max contributing(~50%)
4. Amazon, Filpkart and Myntra channels are max contributing(~80%)

Final Conclusion to improve Fashion store sales:

Target women customers of age group (30-49 yrs) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra

Tool

Excel