VRINDA Retail Store Data Analysis
About this project
GitHub Link to get the: Dataset of this Project
Link to the Project: View Project
Hello Everyone! I have analyzed the "Vrinda Store Annual Report" and created a powerful dashboard using Excel to gain insights that can assist Vrinda store
๐ Objective The primary objective of โVrinda Store Annual Report 2023โ was to analyze customer behavior and sales performance and grow more in 2024.
๐ข Steps followed: ๐ Data Extraction-Data was extracted in form of Excel(.XLSX) sheet. ๐ Data cleaning- This will ensure accuracy and reliability of raw data. Inconsistent values and NULL entries were fixed. ๐ข Data Processing: Two columns โAge Groupโ and โMonthโ were added for deeper analysis of dataset. ๐ Data analysis: Pivot Tables were created for uncovering patterns and trends. ๐ Data Visualization: Various Charts, graphs and slicers were created for visualizing the key insights.
๐ Insights: ๐ Highest sale was done in the month of March. ๐ Women are more likely to purchase (64%). ๐ Adult age group (30-49) contributes the most. ๐ Top performing states are Maharashtra, Karnataka and Uttar Pradesh. ๐ Amazon, Myntra and Flipkart contributed the most.
โ Conclusion: Target women customers of age group (30-49) years living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/coupons/offers available on Amazon, Myntra and Flipkart.
