Skip to content

Latest commit

 

History

History
42 lines (24 loc) · 2 KB

README.md

File metadata and controls

42 lines (24 loc) · 2 KB
Raw

Bharat Store Data Analysis Project

Objective

The goal of the Bharat Store Data Analysis project is to create an annual sales report for 2022. This report aims to provide insights that can help Vrinda Store understand customer behavior and improve sales strategies for 2023.

Business Questions Explored

  1. Comparative Sales and Orders Analysis: Explore the relationship between sales and orders using a single chart.

  2. Highest Sales Month: Identify the month with the highest sales and orders.

  3. Gender-Based Analysis: Determine whether men or women made more purchases in 2022.

  4. Order Status Breakdown: Analyze the distribution of different order statuses in 2022.

  5. Top Sales Contributing States: List the top 10 states contributing the most to sales.

  6. Age and Gender Relation: Investigate the connection between age, gender, and the number of orders.

  7. Channel Contribution to Sales: Assess the impact of different channels on overall sales.

  8. Highest Selling Category: Identify the category with the highest sales.

Insights Gained

Key insights from the analysis:

  • Women accounted for around 65% of purchases, suggesting a strong female customer base.
  • The top three states for sales were Maharashtra, Karnataka, and Uttar Pradesh, making up about 35% of total sales.
  • The age group of 30-49 years contributed the most to sales, accounting for approximately 50% of orders.
  • Amazon, Flipkart, and Myntra were the most significant sales channels, contributing to about 80% of total sales.

Conclusion and Recommendations

Based on the insights, here are the conclusions and recommendations:

To boost sales in the future:

  • Target women aged 30-49, especially in Maharashtra, Karnataka, and Uttar Pradesh.
  • Utilize platforms like Amazon, Flipkart, and Myntra for targeted ads and promotions.

Feel free to explore the detailed analysis in the project files. For questions or collaboration, reach out to us. Thank you for your interest in the Vrinda Store Data Analysis project!