Business Overview
High-level KPIs and performance snapshot across all orders
Total Revenue
$1.26M
Across 1,200 orders
Total Orders
1,200
Jan 2023 – Jun 2025
Avg Order Value
$1,054
Per transaction
Cancelled Orders
250
20.8% cancellation rate
Delivered Orders
231
19.3% successful delivery
Monthly Revenue Trend
Total revenue per month — Jan 2023 to Jun 2025
Order Status Distribution
Breakdown of all 1,200 orders by current status
Revenue by Product Category
Which products drive the most revenue
Revenue by Year
Annual revenue comparison (2025 partial: Jan–Jun)
Top Product: Chair
Chair leads revenue at $195,620 with 562 units sold — highest in both value and volume.
High Cancellation Rate
20.8% of orders were cancelled. This is the single largest order status — worth investigating.
Instagram is #1 Referral
Instagram drives 259 orders (21.6%), edging out Email (250) and Google (241).
Online Payments Lead
Online is the most used payment method (258 orders), with all 5 methods evenly spread.
Revenue Analysis
Monthly, annual and coupon-driven revenue breakdown
Full Monthly Revenue (Jan 2023 – Jun 2025)
30-month revenue trend — each bar is one month
Year-over-Year Revenue
2025 is partial (6 months only)
Coupon Code Usage
Which coupon drives more orders
Top Revenue Months
Ranked by total monthly revenue
Product Performance
Revenue, quantity, and order distribution across 7 product categories
Revenue by Product
Total sales value per product
Units Sold by Product
Total quantity sold per category
Revenue Share (Pie)
Proportional contribution to total revenue
Revenue per Unit (Avg Unit Price)
Estimated average revenue per unit sold per product
Order Status Analysis
Fulfilment pipeline — how orders flow from placed to delivered
Cancelled
250
20.8%
Returned
247
20.6%
Pending
237
19.8%
Shipped
235
19.6%
Delivered
231
19.3%
Order Status Donut
All 1,200 orders categorised by final status
Revenue by Order Status
How much value falls in each status bucket
Order Status × Product Heatmap (Revenue $)
Which product has most cancellations / returns?
| Product | Cancelled | Delivered | Pending | Returned | Shipped | Total |
|---|
Customer & Marketing Insights
Payment methods, referral sources, and coupon adoption
Payment Methods
How customers prefer to pay
Referral Sources
Where customers discover the brand
Coupon Code Split
Which discount drives more orders
Referral Source Performance (Orders)
Detailed ranking of all traffic channels
Raw Data Table
First 100 rows from the dataset — all 1,200 records loaded
| # | Order ID | Date | Customer | Product | Qty | Unit Price | Payment | Status | Referral | Total |
|---|