The primary goal of this project is to create an interactive dashboard in Microsoft Excel that analyzes Vrinda Store's 2022 sales data. This analysis aims to provide valuable insights into customer behavior, sales trends, and uncover opportunities for growth and improvement in 2023.
You can access the dataset here:
- Sales & Order Comparison: Visualize the relationship between total sales and total orders in a single chart 📊.
- Peak Sales & Order Month: Identify the month with the highest number of sales and orders 🗓️.
- Gender-Based Purchasing: Determine which gender (Male/Female) made more purchases 👩🦰👨🦰.
- Order Status Analysis: Analyze the different order statuses throughout 2022 📦.
- Top Performing States: Identify the top 10 states contributing the most to overall sales 🌍.
- Age-Gender Relationship: Explore the correlation between age and gender based on the number of orders 🧑🦳👩🦳.
- Channel Performance: Identify the best performing sales channel contributing to the most sales 🌐.
- Best-Selling Category: Identify the product category with the highest sales volume 🏷️.
-
Data Quality Assurance:
- Review of the dataset for any missing values or inconsistencies 🔍.
- Ensured data consistency by standardizing formats, data types, and values 🔧.
-
Data Analysis:
- Used pivot tables to organize and analyze the data based on the KPIs 📑.
- Merged multiple pivot tables into a single interactive dashboard 📊.
- Implemented slicers to allow dynamic filtering and data exploration 🔄.
You can check out the interactive dashboard here:
For a closer look at the analyzed data, click here:
- Gender Preference: Women customers account for approximately 65% of all purchases, indicating a higher preference for online shopping compared to men 👩🦰.
- Top-Performing States: Maharashtra, Karnataka, and Uttar Pradesh emerge as the top 3 states with the highest sales volume 🏙️.
- Age Demographics: The 30-49 age group is the primary consumer segment, contributing to 50% of all purchases 👨🦳👩🦳.
- Preferred Shopping Channels: Amazon, Flipkart, and Myntra dominate as the most popular online shopping platforms for Vrinda Store 🛒.
To optimize sales for Vrinda Store, a targeted marketing strategy should focus on:
- Female customers aged 30-49 years.
- Based in Maharashtra, Karnataka, and Uttar Pradesh.
- Shopping via popular platforms like Amazon, Flipkart, and Myntra.
By creating tailored advertisements, promotions, and exclusive offers for this demographic, Vrinda Store can maximize its growth potential and improve sales in 2023 📈🚀.
This dashboard analysis provides essential insights to help drive strategic decision-making and growth at Vrinda Store! 📊📅