An interactive Microsoft Excel dashboard built to analyse 5,000 e-commerce transactions, uncovering insights across revenue, regional performance, customer satisfaction, and payment behaviour.
Built entirely in Microsoft Excel β no external tools or plugins required.
| Sheet | Description |
|---|---|
| Dashboard | Main view with KPI cards and all charts |
| Raw Data | All 5,000 transaction records |
| Data - KPI | Formula-driven metrics feeding the dashboard |
| Data - Category | Revenue, orders, rating & discount by product category |
| Data - Regional | Performance breakdown by region |
| Data - Payment | Order volume and revenue by payment method |
| Data - Annual Trend | Year-by-year revenue and order count |
- Revenue trends across years and product categories
- Regional performance β which regions lead in sales and customer satisfaction
- Payment method analysis β Card vs. Cash on Delivery vs. Digital Wallet
- Customer ratings by category and delivery speed
- Discount impact on average order value
- Source: Kaggle
- Records: 5,000 orders
- Fields: Order ID, Customer ID, Order Date, Product Category, Quantity, Unit Price, Discount, Revenue, Region, Delivery Days, Customer Rating, Payment Method
- Microsoft Excel (Charts, Formulas, Data Tables)
- Download
E-commerce_Sales_Analytics_Dashboard.xlsx - Open in Microsoft Excel (2016 or later recommended).
- Navigate to the Dashboard sheet for the full overview.
- Explore individual data sheets and pivot tables for deeper breakdowns.
Made by MarkFinley β feel free to connect on LinkedIn
