Vrinda Store Annual Sales Report 2022

Objective/Business Problem Vrinda Store aims to create an annual sales report for the year 2022 to gain insights into customer behavior. The goal is to understand customer patterns, improve sales strategies, and enhance overall growth for the year 2023.

Questions Answered

• Comparison of Sales and Orders: Visualized sales and orders data using a single chart.
• Highest Sales and Orders: Identified the month with the highest sales and orders.
• Gender-based Purchases: Analyzed whether men or women made more purchases in 2022.
• Order Status: Identified different order statuses in 2022.
• Top 10 Sales-contributing States: Listed the top 10 states contributing to sales.
• Age and Gender Analysis: Explored the relationship between age groups and gender based on the number of orders.
• Sales Channel Analysis: Determined the channel contributing the most to sales.
• Highest Selling Category: Identified the highest selling category.

Steps Followed

• Understanding the Problem: Analyzed the requirements and objectives of the report.
• Data Cleaning: Cleaned and preprocessed the raw data for analysis.
• Data Processing: Processed the cleaned data to extract relevant features for analysis.
• Data Analysis: Applied various analytical methods to answer the specified questions.

Insights Generated

• Women made approximately 65% of the purchases, indicating a significant female customer base.
• The top three states contributing to sales were Maharashtra, Karnataka, and Uttar Pradesh, accounting for nearly 35% of total sales.
• The age group of 30-49 years was the most significant contributor to sales, constituting almost 50% of the customer base.
• Amazon, Flipkart, and Myntra were the primary sales channels, contributing to nearly 80% of the total sales.

Final Conclusion and Recommendations To improve Vrinda Store's sales for 2023, the following strategies are suggested:

• Target Women Customers: Focus marketing efforts on women, who constitute a significant portion of the customer base.
• Age Group Targeting: Specifically target the age group of 30-49 years, which showed the highest purchasing activity.
• Geographical Focus: Concentrate on customers from Maharashtra, Karnataka, and Uttar Pradesh, as these states are the major contributors to sales.
• Channel Optimization: Enhance marketing and promotions on platforms like Amazon, Flipkart, and Myntra, which are the primary sales channels.

Note: This analysis was conducted using Microsoft Excel 365, leveraging its latest features for robust data analysis and visualization.

Special Thanks

Rishabh Mishra https://www.youtube.com/watch?v=gTK5rNhWJyA Excel Dataset Download: https://bit.ly/3X381ok