📊 Multi-Channel Sales Performance Tracker

Excel-Based Business Intelligence Dashboard

By: Shavilya | Data Analyst

This repository showcases a business-focused Excel dashboard built to analyze multi-channel e-commerce sales performance.
The dashboard enables stakeholders to track revenue, orders, customer demographics, sales channels, geography, and order fulfilment performance through interactive visualizations.

---

📸 Dashboard Preview

---

🎯 Project Objective

The objective of this project is to:

• Transform raw e-commerce data into actionable business insights
• Analyze sales trends, customer behavior, and operational performance
• Build a single-page executive dashboard using Excel
• Enable dynamic filtering using slicers (Month & Category)
• Present insights in a clear, decision-ready format

---

🧩 Key Business Questions Answered

• How are orders and revenue trending month over month?
• Which sales channels contribute most to revenue?
• What is the gender and age distribution of customers?
• Which states drive the highest revenue contribution?
• What percentage of orders are delivered vs cancelled/returned?

---

📊 Dashboard Components & Insights

🔹 Sales Performance

• Monthly Orders & Revenue Trend
• Identifies seasonality and demand fluctuations

🔹 Channel Analysis

• Revenue Share by Sales Channel
• Amazon and Myntra emerge as major contributors

🔹 Customer Demographics

• Customer Distribution by Gender
• Customer Demographics by Age Group & Gender
• Women customers dominate across adult and senior segments

🔹 Geographic Performance

• Top States by Revenue Contribution (%)
• Maharashtra and Karnataka lead overall revenue share

🔹 Order Fulfilment

• Order Fulfilment Status Breakdown
• Over 90% orders successfully delivered, indicating strong operations

---

🗂️ Files in This Repository

• Dashboard_Excel.xlsx
  → Main Excel file containing:

  • Pivot tables
  • Interactive slicers
  • Business charts
  • Final dashboard sheet

• README.md
  → Project documentation

• LICENSE
  → MIT License

---

🧪 Dataset Overview

The dataset represents e-commerce transactions and includes:

• Order & customer identifiers
• Gender and age
• Sales channel (Amazon, Myntra, Flipkart, etc.)
• Product category & quantity
• Order amount & currency
• Order status (Delivered, Cancelled, Returned, Refunded)
• Shipping geography
• B2B indicator

Dataset used strictly for analytical and portfolio purposes

---

🛠 Tools & Techniques Used

Tools

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Slicers & Filters

Techniques

• Data cleaning & transformation
• Aggregation & grouping
• Percentage contribution analysis
• Trend analysis
• Dashboard design & layout optimization

---

📈 Key Takeaways

• Sales show clear monthly seasonality
• A small number of channels contribute the majority of revenue
• Women customers account for ~70% of total orders
• Adult age group is the largest revenue contributor
• Order fulfilment efficiency is operationally strong

---

▶️ How to Use the Dashboard

1. Download or clone the repository
2. Open Dashboard_Excel.xlsx in Microsoft Excel
3. Use Month and Category slicers to explore insights
4. Review trends, distributions, and performance metrics

---

🤝 Connect With Me

LinkedIn
🔗 https://www.linkedin.com/in/shavilya-rajput-9674141a0/

GitHub
🔗 https://github.com/shavilya

---

📜 License

This project is licensed under the MIT License.