Skip to content

khanimrangithu/Excel_Vrinda_Store_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Excel_Vrinda_Store_Analysis

Project Objective

Vrinda Store wants to create an annual sales report for 2022. So that, Vrinda can understand their customers and grow more sales in 2023.

Project Questions

  • Compare the sales and orders using single chart.
  • Which month got the highest sales orders?
  • What are different order status in 2022?
  • List top 5 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? etc.

Project 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%)

Conclusion

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.

About

Vrinda Store analysis and Dashboard using Advanced Excel

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published