This repository contains a sales dashboard created using Microsoft Excel for the Vrinda store. The dashboard is designed to analyze annual sales data for the year 2022. Its purpose is to help the Vrinda store understand its customers better and strategize to increase sales in 2023.
The main objective of this project is to generate an annual sales report for 2022 to gain comprehensive insights into their customer base and strategize for increased sales in 2023.
- Compare the sales and orders using a single chart
- Which month got the highest sales and orders?
- Who purchased more - men or women in 2022?**.
- What are the different order statuses in 2022?
- List the top 10 states contributing to sales.
- What is the relation between age and gender based on number?
- Which channel is contributing to maximum sales?
- What is the highest-selling category?
- Women comprise approximately 65% of our customer base.
- The top states for sales are Maharashtra, Karnataka, and Uttar Pradesh, collectively accounting for around 35%.
- The 30-49 age group contributes to roughly 50% of our sales.
- Predominantly, sales originate from Amazon, Flipkart, and Myntra, constituting approximately 80%.
To enhance sales performance, focus on targeting women aged 30-49 in these states and intensify promotions on Amazon, Flipkart, and Myntra platforms.