🏪 Vrinda Store Data Analysis

📘 Overview

This project presents an in-depth analysis of Vrinda Store's data using Microsoft Excel to uncover valuable insights into sales trends, customer behavior, and product performance.

Through data exploration and visualization, this analysis aims to:

• Inform Business Strategies: Provide actionable insights to strengthen marketing campaigns, optimize inventory, and refine pricing strategies.
• Understand Customer Behavior: Identify customer preferences and buying patterns to enable targeted outreach and improve customer experience.

---

📊 Data Summary

The dataset contains comprehensive details including:

• Products: Channel, category, amount, and date.
• Sales: Gender, age, customer ID, order ID, and order details.
• Additional Data: Quantity, ship city, ship state, and size.

---

🔍 Data Visualization

Performed through interactive and advanced Excel visualizations such as:

• Bar Charts: Comparing sales across various ship states.
• Line Charts: Tracking sales and orders pattren .
• Pie Charts: Showing gender-wise distribution.

---

❓ Key Business Questions

1. Compare the sales and orders using a single chart.
2. Which month recorded the highest sales and orders?
3. Who purchased more — men or women in 2022?
4. What are the different order statuses in 2022?
5. List the top 10 states contributing to the sales.
6. What is the relation between age and gender based on number of orders?
7. Which channel contributes the maximum sales?
8. Which is the highest-selling category?

---

📈 Analysis and Insights

🧾 Top Contributing Channels

🔹 Key Insights:

• 👩 Women are the major buyers — contributing 65% of total sales.
• 🏙️ Top 3 states: Maharashtra, Karnataka, and Uttar Pradesh.
• 👨‍🦳 Adult age group (30–49 years) contributes the most — around 50% of total sales.
• 🛒 Top performing channels: Amazon, Flipkart, and Myntra.

---

💡 Final Conclusion

To boost Vrinda Store's sales, focus marketing efforts on:

🎯 Target Audience:

• Women aged 30–49 years
• Located in Maharashtra, Karnataka, and Uttar Pradesh

📢 Strategy:

• Run ads, offers, and coupons on high-performing platforms like Amazon, Flipkart, and Myntra.

---

🧰 Tools & Technologies Used

• Microsoft Excel
• Pivot Tables & Charts
• Dashboard Visualization
• Data Cleaning

---

🏁 Final Note

This analysis helps Vrinda Store make data-driven decisions to increase sales, improve targeting, and enhance customer satisfaction.
📧 Data Analyst | Data Science Enthusiast