Fashion Store Data Analysis Using Excel

📍Download the dataset from here.

📍Download the complete report from here.

Objective

Fashion Store wants to create an annual sales report for 2023. So that, this store can understand their customers and grow more sales in 2024. Implemented an advanced Fashion Store Dashboard using EXCEL.

Sample Insights

• Women are more likely to buy compared to men (~65%)

• Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (~35)

• Adult age group (30-49 yrs) is max contributing (~50%)

• Amazon, Flipkart 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