excel-data-analysis-mahalaxmi-store

objective: Mahalamxi superstore wants to create an annual sales reports for 2022 ,so that owner can understand their customer and grow more sale in 2023.

QUESTIONS:

1. Compare the sales and orders using single charts?

2. Which month got the highest sales and orders?

3. Who purchased more men - women in 2022?

4. What are the different order statuses in 2022?

5. List the top 10 states contributing to sales.

6. Relationship between age and gender based on number of orders?

7. Which channel is contributing to maximum sales?

8. What is the highest-selling category?

REPORT SAMPLE Insights

1. women are more likely to buy compared to men (65%)

2. Maharashtra, karnataka, and Uttar Pradesh are top 3 state (35%)

3. Adult age group (30-48 year) is max contributing (50%)

4. amazon , flipkart and myntra channel are max contributing (80%)

   final conclusion targrt women customers of age group (30–49) living in Maharashtra, Karnataka, and Uttar Pradesh by having adds, offers, and coupons available on Amazon, Flipkart, and Myntra.