rajat7377 / vrinda-store-data-analysis-2022-excel

Vrinda-Store-Data-Analysis-2022-Excel

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.

In this Excel project , process I went through:

Step 1: Data Cleaning

Step 2: Data Processing

Step 3: Data Analysis

Sample Insights:

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

-> Maharastra,Karnataka and Uttar Pradesh are top 3 states (~35%)

-> Adult age group (30-49 years) is max contributing(~50%)

-> Amazon, Flipkart and Myntra channels are max contributing(~80%)

Final Conclusion To Improve Vrinda Store Sales In 2023:

Target women customers of age group (30-49 years) living in Maharastra, Karnataka and UP by showing ads/offers/coupans available on Amazon, Flipkart, and Myntra.