Case Study

Rabattcorner: Cashback Platform Streamlines Analytics with Amazon QuickSight

Background

Rabattcorner, a cashback platform, needed an intuitive analytics layer to visualize Daily, Weekly, and Monthly performance across Gross Merchandise Value (GMV), Revenue, Payments, Average Order Value, Number of Transactions, Transaction Statuses, conversion rate, and more. The team had been using Looker, but sought the advantages of Amazon QuickSight—built-in machine learning insights (anomaly detection, forecasting, automated narratives), a simpler interface with natural-language query (NLQ) for non-technical users, high performance with the SPICE in-memory engine, and a cost-efficient pay-per-session model.

The Challenge

Rabattcorner set out to replace Looker with Amazon QuickSight while improving usability, performance, coverage of key KPIs, and overall cost efficiency.

  • Built-in ML insights: Achieve anomaly detection, forecasting, and automated narratives without stitching in external tools.

  • Ease of use for business users: Reduce reliance on LookML and enable ad-hoc analysis via natural-language query (NLQ).

  • Performance at scale: Speed up interactive dashboards and keep response times consistent on large datasets.

  • Cost control: Move from a fixed subscription to QuickSight’s pay-per-session model aligned to actual usage.

  • Comprehensive KPI coverage: Track Daily/Weekly/Monthly GMV, Revenue, Payments, AOV, Transactions, Statuses, and conversion in one place.

Our Solution

We implemented a QuickSight-based analytics stack and rollout plan tailored for fast performance and broad self-service adoption.

  • Role-based dashboard suite: Built Daily/Weekly/Monthly views for GMV, Revenue, Payments, AOV, Transactions, Statuses, and conversion.

  • SPICE acceleration: Modeled and loaded data into the in-memory SPICE engine for fast, interactive exploration.

  • ML-powered analytics: Enabled built-in anomaly detection, forecasting, and auto-generated narratives.

  • Self-service NLQ: Activated natural-language queries so business teams could ask questions directly.

  • Data validation & metric parity: Structured verification to ensure complex calculated fields matched legacy definitions.

  • Adoption & enablement: Phased pilot with power users, organization-specific documentation, and recorded trainings.

  • Performance governance: Established baselines, monitoring, and SPICE-capacity management to keep dashboards responsive.

The Result

The migration delivered measurable gains in speed, cost, and adoption, validated by a three-year TCO analysis.
  • Faster delivery: Report development time dropped from 2–3 weeks (Looker) to 3–5 days (QuickSight) (~70% faster).

  • Snappier dashboards: Load times improved from 5–7s to 2–3s, boosting usability and adoption.

  • Lower support effort: Ongoing effort reduced from 20 hrs/month to 8 hrs/month (60% reduction).

  • Higher adoption: Active business users increased from ~40% to ~75% thanks to NLQ and simpler workflows.

  • Built-in ML value: Anomaly detection, forecasting, and narratives delivered out-of-the-box—no external tools required.

  • TCO savings: Three-year total fell from $336,000 (Looker) to $167,600 (QuickSight)$168,400 saved (~50%), with ~40% lower licensing and 60% lower ops costs.

  • ROI & payback: >300% ROI in Year 1, payback in <3 months, and ~$56,000/year in ongoing licensing and labor savings.