Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Vrinda Store Sales Dashboard
Project type
Excel Data Analysis
# Objective :
Created this annual report for Vrinda Store to help them understand their customers better and drive sales growth in 2023 .
# Sample Questions
☆ Comparing sales and order
☆ Identifying the months with highest Sales .
☆ Analyzing the Gender-based purchasing patterns in 2022
☆Identifying the top 5 states contributing to sales .
☆ Exploring relationship between Age and Gender
☆ Identifying the channel contributing max in sales.
# Dashboard
created a dynamic and visually appealing Excel dashboard to present the findings which includes charts and tables that provide overview of vrinda store sales
# Skills and tools
Throughout this project i utilized advance Excel Functions ,data cleaning techniques Pivot tables , pivot charts and other data visualization tools🔧 .
# Key insights
■ Women are more likely to contribute as compared to men.
■ The Adult age group (30-49 yrs) contribute the most.
■ Amazon, Flipkart and Myntra contribute the most.
# conclusion to improve
Target the women customers of age group (30-49yrs) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra .
