Vrinda Store Data analysis

Objective- Vrinda store wants to create an annual sales report for 2022.

So that,they can understand their customer and grow more sales in 2023.

Sample question:

Ques 1: Compare the sales and orders using single chart

Ques 2: Which month got the highest sales and order?

Ques 3: Who purchased more - men or women in 2022?

Ques 4: What are the different order status in 2022?

Ques 5: List top 10 states contributing to the sales?

Ques 6: Relation between age and gender based on numbers of orders?

Ques 6: Which channel is contributing to maximum sales?

Ques 6: Highest selling category?

Insights

Women are more likely to buy compares to men(65%)

Maharashtra, Karnataka and Uttar pradesh are top 3 states

Adult group (30-49 years) is max contributing

Amazon, Flipkart and Myntra are max contributing (80%)

Final conclusion to improve sales:

Target women customer of age gropup (30-49 years) living in Maharastra, Karnataka and Uttar pradesh by showing ads/offer/coupons available on Amazon, Flipkart and Myntra.