Retail Analytics · RFM Customer Insights
UCI Online Retail dataset · transformed with dbt + DuckDB · static site, rebuilt hourly · self-managed VPS
Total Revenue
£8,911,408 (₹1,136,204,508)
Customers
4,372
Orders
22,190
Avg Order Value
£402 (₹51,203)
Returns Value
£611,342 (₹77,946,116)
Return Rate
6.4%
Repeat Customers
70.0%
INR figures are an approximate reference conversion (£1 ≈ ₹127.5) — the source dataset's real currency is GBP.
Revenue trend
Revenue by customer segment (RFM)
Customers by segment
Revenue by country (map)
Top products by revenue
Revenue by country (chart)
Customers — search, filter, sort (interactive)
Customer ID Country Segment Orders Lifetime Revenue (£)
Architecture: UCI dataset → DuckDB (raw) → dbt (staging + marts + RFM segmentation) → Python/Plotly static site generator (systemd timer, hourly) → this static HTML page (client-side JS for search/filter/sort/date-grain, no server calls). Last generated: 2026-08-24 15:53 UTC