Vrinda store data analysis project using Excel

This is a Data analysis project using Excel of Vrinda store sample data which is a Garment store, Which does their business across India.

1. Vrinda Store Data Analysis Using Microsoft Excel By Santu Jana

2. What is the total number of orders? 31047 What is the total revenue generated? ₹ 2,14,41,209 What is the average order value? ₹ 691

3. How many orders are placed by each gender?

4. What is the distribution of orders across different age groups?

5. Which product category has the highest sales volume? Set - ₹ 1,06,01,722.00 Which shipping city has the most orders? BENGALURU- 2689

6. What is the most popular order channel (e.g., online, in-store)?

7. How many orders are B2B versus B2C?

8. What is the most ordered size for each product category? Category Most ordered size Blouse L Bottom XXL Ethnic Dress L Kurta L Saree Free Set M Top M Western Dress L

9. What is the average age of customers placing orders? 39 Which size is the most commonly ordered? M

10. What is the trend in the number of orders over time (e.g., monthly or yearly)?

11. Which SKU is the most expensive? 3.37% What is the return rate (orders with status indicating returns)? JNE3797-KR-L (Western Dress) - ₹ 2,00,856.00 How many unique customers have placed orders? 28440

12. What is the distribution of orders by order status (e.g., completed, pending, cancelled)?

13. Which shipping state has the highest average order value? Nagaland What is the correlation between age group and order value? 0.005 (There is no correlation)

14. Insights Women are more likely to buy compared to men. Adults age group (31-49 yrs ) are likely to buy compared to old and young age group. Online channels are maximum contributing. January-March are the peak months for the sales. B2B orders are very less compared B2C orders. Bengaluru is the city w

15. Thank You!