This repository contains an interactive Excel-based dashboard for analyzing and visualizing e-commerce sales performance across multiple dimensions.
The workbook consolidates raw transactional data with dynamic dashboards to provide actionable business insights.
Includes detailed order-level records with fields such as:
- Order & Shipping Details → Order ID, Order Date, Ship Date, Shipping Mode, Aging, Priority
- Product Details → Category, Sub-Category, Product Name
- Sales Metrics → Sales, Quantity, Discount, Profit
- Customer & Segment Info
- Geographic Details → City, State, Country, Region
- Time Attributes → Month, Financial Quarter, Year
Multiple dashboard sheets (Dashboard, dashboard1, dashboard2, dashboard3, dashboard4) track key KPIs:
- Total Sales & Profit trends
- Customer segmentation performance
- Regional & product-category insights
- Order fulfillment & shipping efficiency
Intermediate sheets (STEP 1, STEP 1a, step2, step2a, sheet2b, sheet 3, sheet 4) illustrate the data transformation pipeline from raw dataset → summary → dashboard visualizations.
- Business Analysis → Track profitability, sales trends, shipping efficiency
- Data Exploration → Understand customer segments, product categories, and regions
- Decision Support → Identify top-performing markets & optimize inventory/logistics
E COMMERCE PERFORMANCE DASHBOARD.xlsb→ Main Excel workbook with dashboards and dataDATASET.xlsx→ Original dataset in Excel formatsample_dataset.csv→ Preview file (first 100 rows) for GitHub-friendly inspection
Since the full dataset is large, a sample file is provided for quick viewing:
View Sample Dataset (100 rows)
Screenshots of the dashboards (from images/ folder):
excel dashboard data-visualization business-analytics ecommerce sales-performance profitability-analysis
Developed as part of an MBA Project on E-Commerce Performance Analysis & Data Visualization.