Vrinda Store Sales Data

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.