Dashboards
Six boards, originally built in Metabase on PostgreSQL and ported here to a static site. Five share one governed sales model over the UCI Online Retail II dataset (a UK giftware wholesaler, Dec 2009 – Dec 2011, ~1.06M order lines with a synthetic cost layer); the sixth runs on a standalone synthetic dataset. Every filter runs in your browser.
All five retail boards tie to the same control totals: £20,110,181 of net revenue on 11,402,654 units.
| Board | What it answers |
|---|---|
| Trading Overview | How the business is trading and where — revenue, margin, orders and AOV by month, market and category, plus year-over-year seasonality. |
| Pricing & Margin | Where margin is made and lost across the price ladder — margin rate by price band, SKU volume vs margin, top SKUs below the blended rate. |
| Merchandising | What is selling, what is dead, what is coming back — active SKUs, return rate by month and product, category performance, price-band mix. |
| Customer & Loyalty | Who the customers are and how loyal — RFM segments, repeat rate, account vs guest revenue, lifetime-value distribution, top accounts. |
| Bestsellers | Which products carry the business — revenue concentration curve, SKUs to half of revenue, hero SKUs by month, 2010 → 2011 movers. |
| Benchmark · Period Comparison | Period-comparison benchmark grid: current vs prior year or prior period by category, gender, brand or product, with colour-coded deltas. |