Vrinda Store Sales Data

Ihsan Rahim

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.
Questions:
Compare the sales and orders using a single chart
Which month got the highest sales and orders?
Who purchased more men or women in 2022?
what are the different order statuses in 2022?
List the top 5 states contributing to the sales.
Relation b/w age and gender based on number of orders?
Which channel is contributing to maximum sales?
Highest selling category?
In this Project first, I clean the data remove duplicates and blanks, etc. After that, I validate the data and did data analysis using Pivot Table and for visualization used a Pivot chart and make a simple dashboard.
Sample Insight:
Women are more likely to buy as compared to men (65%)
Maharashtra, Karnataka, and Uttar Pradesh are the top 3
The adult age group (30-49 yrs) is max contributing (50%)
Amazon. Flipkart and Myntra channels are maz contributing (80%)
Final Conclusion to Improve Vrinda Store Sales:
Target women customers of the age group (30-49 yrs) living in Maharashtra, Karnataka, and Uttar Pradesh by showing ads/offers/
coupons available on Amazon, Flipkart, and Myntra.
Like this project

Posted Jun 1, 2024

Vrinda Store Sales Data

Bike Sales Data
Bike Sales Data
Data Analysis, Data Cleaning
Data Analysis, Data Cleaning
Analysis of Mobile 2023
Analysis of Mobile 2023

Join 50k+ companies and 1M+ independents

Contra Logo

© 2025 Contra.Work Inc