Data-Analysis-Excel

Link: https://1drv.ms/x/c/4dd5d180b862703c/EcjRYrvIlJlMkGOcDKxPUP4B5sgvOw0if1AytoiAwGmfKw?e=CD25Lb

Objective

R.B Mart Store wants to create an annual sales report for 2022. So that, R.B Mart can understand their customers and grow more sales in 2023

Sample Question

1. Commpare The sales and orders using single chart.
2. Which month got the highest sales and orders.
3. Who Purchased more men or women in 2022.
4. What are the different order statusin 2022.
5. List top 5 states contributing to the sales.
6. Relation between age and gender based on number of orders.
7. Which channel is contributing to maximum saes. 8.Highest selling category?

Sample Insights

1. Women are more likely to buy compared to men(-64%).
2. Maharashtra, Karnataka and uttar Pradesh are top 3 States.
3. Adult age group (30-49 years) is max contributing (50%).
4. Amazon, Fipkart and Myntra channels are max contributing(80%).

Final Conclusion to improve R.B Mart Store Sales:

Target Women customers of age group(30-49 years) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.