This project showcases a complete end-to-end data analytics workflow using Microsoft Excel. The goal was to analyze the 2022 annual sales data for Vrinda Store, identify key trends, and create an interactive dashboard to help the business make data-driven decisions.
By utilizing dynamic slicers, the dashboard allows stakeholders to filter data by Month, Channel, and Category, instantly updating the visuals to reflect the selected criteria.
Note: Replace the image path with your actual repository image path if different.
- Data Cleaning: Removing duplicates, handling missing values, and ensuring data consistency.
- Data Processing: Creating new columns, categorizing data (e.g., grouping ages into Adult, Senior, Teenager), and formatting.
- Data Analytics: Utilizing Pivot Tables and formulas to aggregate and summarize large datasets.
- Data Visualization: Designing intuitive charts (Combo charts, Pie charts, Bar charts, and Clustered Column charts) to represent complex data simply.
- Interactive Dashboarding: Connecting multiple Pivot Charts with Slicers to create a responsive, single-page executive summary.
The dashboard was built to answer the following critical business questions:
- What was the overall trend of sales and orders throughout the year 2022?
- Which gender contributes the most to the total sales?
- What is the current status of all orders (Delivered, Refunded, Returned, Cancelled)?
- Which geographical states generate the highest sales revenue?
- How does the age and gender demographic correlate with order volume?
- Which e-commerce channels (Amazon, Flipkart, Myntra, etc.) are the most profitable?
Based on the dashboard analysis, several actionable insights were discovered:
| Category | Insight |
|---|---|
| 📅 Peak Sales Period | Sales and order volumes peaked around March, followed by a gradual decline towards year-end. |
| 👩 Target Audience | Women account for 64% of total sales. Adult Women (~34.59%) are the largest single buying demographic. |
| 🗺️ Top Geographies | Maharashtra leads with ₹2.99M, followed by Karnataka (₹2.65M) and Uttar Pradesh (₹2.10M). |
| 🛒 Channel Performance | Amazon (35%), Myntra (23%), and Flipkart (22%) collectively drive 80% of total orders. |
| ✅ Operational Efficiency | 92% of orders are successfully delivered, with low return and cancellation rates of just 3% each. |
Based on the data insights, the following next steps are recommended for Vrinda Store:
- Targeted Marketing: Direct campaigns and promotional offers heavily towards Adult Women, as they are the highest converting demographic.
- Inventory & Supply Chain: Increase inventory distribution and local marketing in top-performing states — Maharashtra, Karnataka, and Uttar Pradesh — to further capture market share.
- Channel Optimization: Continue nurturing strong relationships with Amazon, Myntra, and Flipkart, while investigating why other channels (like Meesho and Nalli) are underperforming.
- Seasonal Promotions: Since sales dip in later months, introduce special Q4 promotions (October–December) to boost end-of-year revenue.
- Download the
.xlsxfile from this repository. - Open the file in Microsoft Excel.
- Navigate to the Dashboard sheet.
- Use the Slicers on the left-hand side (Month, Channel, Category) to filter the data.
- The charts will update dynamically based on your selections!
Created by [Prem kumar Gara] — Dedicated to transforming raw data into meaningful business insights. 🚀
Created by [Your Name / Rishabh] — Dedicated to transforming raw data into meaningful business insights. 🚀