Vrinda Store Sales Analysis

Using Excel to do : 1- Data Cleaning 2- Data Formatting 3- Data Analysis 4- Pivot Table 5- Static & Interactive Dashboard 6- Giving insights & final conclusion

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 Vrinda 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.)

Thanks for your support in my first steps in data analysis onboarding.. 🙌

Google Drive : https://drive.google.com/drive/folders/1mObMfO2N81ZwTAFHdzU_UgEAqsG4OQRI