Real analyses on real datasets — showing exactly the kind of work I deliver to clients.
Full end-to-end analysis of 541,910 transactions from a UK-based online retailer covering December 2009 through December 2011 — product performance, seasonal demand, geographic opportunity, pricing efficiency, and customer value.
| Rank | Customer ID | Revenue | Orders | Avg order |
|---|---|---|---|---|
| 1 | 14646 | £280,206 | 77 | £3,639 |
| 2 | 18102 | £256,438 | 145 | £1,768 |
| 3 | 17450 | £194,551 | 55 | £3,537 |
| 4 | 16446 | £168,472 | 28 | £6,017 |
| 5 | 14911 | £143,825 | 201 | £715 |
| 6 | 12415 | £124,914 | 87 | £1,436 |
| 7 | 14156 | £117,379 | 72 | £1,630 |
| 8 | 17511 | £91,062 | 115 | £792 |
| 9 | 16029 | £81,024 | 63 | £1,286 |
| 10 | 12971 | £77,183 | 95 | £813 |
| Product | Price | |
|---|---|---|
| Ceramic storage jar | £1.25 | +over |
| WW2 gliders | £0.21 | +over |
| Jumbo bag retrospot | £1.95 | +over |
| White heart t-light | £2.95 | +over |
| 72pk cake cases | £0.55 | +over |
| Product | Price | |
|---|---|---|
| Cakestand 3 tier | £12.75 | -under |
| Rabbit night light | £34.95 | -under |
| Umbrella stand | £22.50 | -under |
| Xmas tree large | £19.95 | -under |
| Paper craft birdie | £2.95 | -under |
A second end-to-end analytics project is currently in development. Have a data challenge? Get in touch — your business could be the next case study.
Check back soon or get in touch to discuss your specific data challenge.
Discuss your project →