Skip to content

Sanyarastogi28/Fashion_Store_Data_Analysis_Using_Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 

Repository files navigation

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

Releases

No releases published

Packages

No packages published