Sales & Transaction Volume Over Time
Tracking monthly sales growth and order counts across 48 calendar months.
Transaction volume grew steadily from early 2021 through late 2023, peaking in October 2023 at $243.9k revenue (427 orders). The decline in late 2024 (down to 12 orders in Dec 2024) is a direct consequence of dataset sampling cutoff, not an organic business collapse.
Geographic Purchasing Patterns
Analyzing sales distribution, order density, and order value across 18 countries.
Order counts are evenly distributed across regions (North America: ~2,600, Middle East: 2,458, Europe: 2,446, Asia: 2,494). However, Egypt has the highest Average Order Value ($715.80), whereas UAE has the lowest ($437.91) due to differences in customer product basket selection.
Product Category & Subcategory Share
Comparing category gross revenue, order volume, and subcategory sales.
Order counts are nearly identical across all 5 main categories (~2,000 orders each). However, Electronics commands 64% of total revenue due to a high average unit price ($770.04), whereas Beauty & Health generates only $215.4k despite receiving 1,995 orders.
Pricing, Quantity & Discount Behavior
Exploring relationships between unit price, volume purchased per order, and discount rates.
The scatter plot and price band breakdown demonstrate that average quantity purchased remains essentially flat at ~2.7 units per transaction across all price levels (corr = -0.002) and discount tiers (corr = 0.0017). Because this cross-sectional dataset lacks controlled temporal price variation or demand shift indicators, it does not support estimating a causal price elasticity of demand.
Order Fulfillment & Return Rate
Customer Segment Performance
Payment Distribution
Order Transactions Explorer
Browse and inspect detailed order records matching the active dashboard filters.
| Order ID | Date | Country | Category | Product Name | Price | Qty | Discount | Revenue | Profit | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| ORD-000001 | 2023-01-18 | Mexico | Electronics | Xiaomi 13 | $520.40 | 7 | 0% | $3,642.80 | $1,198.69 | Delivered |
| ORD-000002 | 2023-11-13 | USA | Books & Media | Thinking Fast and Slow | $22.59 | 2 | 25% | $33.88 | $5.56 | Delivered |
| ORD-000003 | 2022-04-28 | Canada | Electronics | Bose QC45 | $241.30 | 1 | 0% | $241.30 | $79.89 | Processing |
| ORD-000004 | 2021-10-22 | Japan | Clothing | Summer Dress | $130.90 | 5 | 0% | $654.50 | $285.34 | Processing |
| ORD-000005 | 2023-08-06 | France | Clothing | Adidas Ultraboost | $74.51 | 3 | 20% | $178.82 | $60.13 | Delivered |
| ORD-000006 | 2021-06-25 | China | Clothing | Puma Running Shoes | $81.89 | 8 | 25% | $491.34 | $118.78 | Delivered |
| ORD-000007 | 2024-02-07 | Germany | Clothing | Chino Pants | $66.82 | 1 | 0% | $66.82 | $19.49 | Returned |
| ORD-000008 | 2022-06-05 | Jordan | Electronics | Google Pixel 7 | $975.79 | 1 | 50% | $487.89 | -$50.80 | Delivered |
| ORD-000009 | 2022-11-05 | France | Books & Media | Deep Work | $35.25 | 2 | 30% | $49.35 | $4.75 | Delivered |
| ORD-000010 | 2023-03-14 | Mexico | Home & Kitchen | Bookshelf 5-Tier | $110.12 | 1 | 40% | $66.07 | -$14.77 | Delivered |
| ORD-000011 | 2023-08-14 | Japan | Books & Media | Microsoft Office 365 | $233.65 | 1 | 5% | $221.97 | $66.85 | Delivered |
| ORD-000012 | 2022-10-23 | USA | Electronics | ASUS ZenBook | $1,018.41 | 2 | 0% | $2,036.82 | $687.73 | Returned |
| ORD-000013 | 2023-04-05 | Italy | Clothing | Adidas Ultraboost | $158.50 | 4 | 40% | $380.40 | -$14.50 | Delivered |
| ORD-000014 | 2022-06-30 | USA | Beauty & Health | Vitamin C Serum | $14.85 | 2 | 15% | $25.24 | $4.74 | Returned |
| ORD-000015 | 2023-07-30 | USA | Clothing | Hoodie Sweatshirt | $99.84 | 1 | 30% | $69.89 | $22.03 | Delivered |
Methodology, Validation & Data Limitations
I validated all 10,000 transaction records before constructing visualizations:
- Zero Missing Values: 0 nulls across 26 attributes.
- Exact Revenue Formula:
Revenue = Unit_Price × Quantity × (1 - Discount)matched with 0.00% variance. - Profit Verification:
Profit = Revenue - Costverified for all orders.
In cross-sectional analysis, corr(Unit_Price, Quantity) is -0.0021 and quantity per order is constant (~2.7 units):
- This dataset lacks controlled temporal price variation per SKU.
- Calculating a naive elasticity formula produces artificial near-zero elasticity.
- I explicitly treat price-volume behavior as descriptive rather than causal.
Monthly order volume peaks in October 2023 (427 orders) and drops off to 12 orders in December 2024:
- This late 2024 drop represents a dataset sampling cutoff.
- Extrapolating a predictive sales forecast would introduce heavy truncation bias.
- Historical trends are presented strictly as observed historical performance.