A complete end-to-end business analytics project using Microsoft Excel, showcasing KPIs, trends, insights & professional dashboard design.
📌 Excel Dashboard File (.xlsx)
➡️ Ecommerce Dashboard.xlsx
📌 Dataset File (.xlsx)
➡️ Ecommerce Data set.xlsx
📌 Dashboard Screenshot (.png)
➡️ Ecommerce Dashboard Preview
This project presents a fully interactive E-Commerce Sales Dashboard built in Excel.
It analyzes multi-country sales data, customer segments, product categories, and operational metrics to deliver clear, visual business insights.
The dashboard is designed for:
- 📈 Decision makers who want a one-page performance view
- 📊 Analysts who want to explore trends, segments, and categories
- 🧠 Business stakeholders who need actionable insights, not just raw numbers
- Provide a consolidated view of overall e-commerce performance
- Analyze sales & profit across markets, regions, and countries
- Understand customer segment behavior (Consumer, Corporate, Home Office)
- Evaluate product category performance in terms of revenue, volume & profit
- Study time-based trends (monthly & yearly)
- Identify operational issues through order status and shipping analysis
- Present insights via a clean, user-friendly Excel dashboard
| Metric | Value |
|---|---|
| Total Records | 110,764 |
| Total Orders | 41,029 |
| Total Customers | 17,515 |
| Total Quantity | 284,209 |
| Time Period | 2016–2017 |
Data includes:
- 🛒 Product category, subcategory
- 👤 Customer ID, segment, location
- 🌍 Market, region, country, state, city
- 📦 Order details, shipping mode, order status
- 💰 Sales, profit, margin, quantity
- Removed duplicate records
- Cleaned inconsistent text fields (countries, categories, segments)
- Standardized date formats
- Verified numeric fields (Sales, Profit, Quantity)
- Created derived columns:
- Profit Margin %
- Profit per Order
- Average Order Value (AOV)
- Year, Month, Year-Month
- Grouped markets, regions and categories logically
- Built Pivot Tables for:
- Sales & Profit by Market / Region / Country
- Category-wise performance
- Customer Segment contribution
- Order Status & Shipping Mode
- Time-series trends
- Created KPI cards for:
- Total Sales, Profit, Margin %
- Total Orders, Quantity, Customers, AOV
- Added:
- Line charts for Sales & Profit trend
- Bar/column charts for Market, Category, Country
- Donut charts for Customer Segment & Shipping Mode
- Supporting tables for Top products & regions
- Applied a consistent color theme
- Used clear headings & sectioning
- Added slicers/filters for interactive analysis
- Structured dashboard for easy reading and storytelling
- 📘 Microsoft Excel
- 📊 Pivot Tables & Pivot Charts
- 📈 Excel Charts (Line, Bar, Column, Donut)
- 🧮 Excel Functions (IF, SUMIFS, AVERAGE, etc.)
- 🧹 Data Cleaning
- 📊 Exploratory Data Analysis (EDA)
- 🎯 KPI Definition & Calculation
- 🎨 Dashboard Design & Layout
- 📉 Trend & Time-Series Analysis
- 🌍 Market & Geo Analysis
- 👤 Customer Segmentation
- 🧾 Business Insight & Storytelling
- Europe & LATAM are the top revenue-generating markets.
- USCA (US & Canada) shows the highest profit margin (~10.4%).
- Central America and Western Europe are leading regions in total sales.
- Consumer Segment contributes the largest share of revenue & profit.
- Corporate Segment is a strong secondary contributor.
- Home Office segment is smaller, but remains consistently profitable.
- Fishing and Cardio Equipment are major revenue drivers.
- Cleats & Apparel are high-volume categories, supporting strong order counts.
- Some SKUs and categories have negative margins, indicating a need to adjust pricing/discounts.
- Revenue has increased year-over-year, but profit has slightly decreased, indicating margin pressure.
- October is the peak month in terms of sales.
- November shows a noticeable dip, hinting at post-peak slowdown or seasonal effects.
- Significant sales value is in Pending, On Hold, and Payment Review status → revenue not yet realized.
- Around 18–19% of line items are loss-making, requiring focus on pricing & discount policies.
- All shipping modes are generally profitable; Same Day shipping shows slightly better margins.
📸 Click the image link to view full dashboard
This Excel project transforms a raw e-commerce dataset into a clear, interactive, business-ready dashboard.
It enables stakeholders to:
- Monitor overall business performance
- Understand where sales & profits come from (markets, regions, countries)
- See who the customers are (segments & locations)
- Evaluate what sells best (categories & products)
- Identify operational inefficiencies (order status, shipping, loss-making items)
It is a strong representation of end-to-end data analytics skills using just Microsoft Excel.
This project demonstrates:
- ✅ Ability to handle real-world business data
- ✅ Strong Excel analytics & dashboarding skills
- ✅ Clear business understanding & KPI thinking
- ✅ Capability to convert data into actionable insights and visual stories
This repository is part of my Data & Business Analytics portfolio and reflects my approach to structured, professional, and insight-driven reporting.
#ExcelDashboard
#DataAnalysis
#BusinessAnalytics
#EcommerceAnalytics
#DataVisualization
#DashboardDesign
#ExcelProject
#AnalyticsPortfolio
#AshwinPanbude
-
📂 Dashboard File:
https://github.com/Ashwin18-Offcl/Excel-Ecommerce-Dashboard/blob/main/Ecommerce%20Dashboard.xlsx -
📂 Dataset File:
https://github.com/Ashwin18-Offcl/Excel-Ecommerce-Dashboard/blob/main/Ecommerce%20Data%20set.xlsx -
🖼 Dashboard Screenshot:
https://github.com/Ashwin18-Offcl/Excel-Ecommerce-Dashboard/blob/main/Ecommerce%20Dashboard.png