Skip to content
woodfrog

·

Analytics
Fintech, Series CCase study, anonymised

Fewer dashboards, clearer answers.

A fintech had 240 dashboards and still could not say why a number moved. None of the 240 was kept. The business now runs on eight new dashboards built around its decisions, and they open in 3 seconds instead of 15.

240 dashboards to 8Schematic
Typical load time: 15 seconds before, 3 seconds after.
240 to 8Dashboards before and after. All eight are new
$72kSaved in year one by replacing the old licence
15s to 3sTypical load time, same data
6 weeksFixed scope, fixed fee
WhoA Series C fintech, anonymised
EngagementSix weeks, fixed scope, fixed fee. Reference calls are possible after the audit, if the client agrees.
BuiltA properly tuned Superset reporting stack and eight dashboards built around decisions
Before and after

240 dashboards became eight.

Before
  • A new dashboard for every new question
  • Nothing was ever retired
  • Typical load time of 15 seconds
  • Opening one rarely settled anything: ask an analyst, wait, then Excel
After
  • Eight dashboards, each built around a decision
  • Each has a named owner
  • Typical load time of 3 seconds
  • The number and the decision sit on the same screen
The problem

240 dashboards, one big licence, no answers.

Nobody planned this. It built up one reasonable request at a time. Someone needed a number no dashboard showed, so a new one was built. The old one stayed, because retiring it was nobody's job. Repeat until 240 dashboards sat on a six-figure licence.

What was broken
  • Nothing was ever retired.
  • The licence grew with the pile of dashboards.
  • Some dashboards repeated another with a different filter. Some had not been opened in months.
  • They loaded in 15 seconds. Above ten, people stop bothering.
  • Opening one rarely ended the argument.
You might be here if
  • Every new question gets a new dashboard and nothing comes off.
  • Some of your dashboards repeat each other, and some are never opened.
  • Yours take more than ten seconds to load.
  • Opening one rarely settles anything, so you ask an analyst and wait.

Why it mattered. Speed decides whether a dashboard is opened at all. Under a few seconds, people check a number mid-conversation. Above ten, they stop bothering.

The approach

Start from the decisions, not the dashboards.

The tempting move was to lift all 240 onto something cheaper. Our view was different: the problem was never usage. It was that opening a dashboard rarely ended the argument. So we started from the decisions the business makes, and treated speed as a reason people would use the dashboards, not a nice extra.

The old estate
240 dashboardsOn a six-figure licence
Analyst and Excel loopWhat it really produced
woodfrog built
A four-question testDone in Week 1
A tuned Superset stackBuilt for speed
Eight decision dashboardsNew, not moved
The decisions
What the business decidesEach dashboard starts here
Named ownersFor the dashboard and the decision
$72k saved in year one
Deliberately not doneMoving any of the 240 across
None of the 240 became one of the eight.schematic
The solution

A test first, then eight dashboards built new.

What was built
  • Week 1 test: every dashboard was asked four questions. Does it carry a decision? Does it have a named owner? Is it a duplicate? Is it still opened?
  • Duplicates were merged and dead dashboards retired, not moved.
  • Eight new dashboards, each built backwards from a decision.
  • A properly tuned Superset stack, not "installed and left".
  • A cut-over off the old licence in weeks 5 to 6, bringing load time from 15 to 3 seconds on the same data.
How it ran, six weeks
Wk1Wk2Wk3Wk4Wk5Wk6
Audit
Test ready
Rebuild
Eight new dashboards
Cut over
Off the old licence
The impact

Faster, cheaper and clearer.

From 240 dashboards to 8Number of dashboards in use
Before
240
After
8, all built new
080160240
None of the 240 was kept. The eight were built new, around decisions.
Load time fell under 10 secondsMedian dashboard load, in seconds
Above 10s, people stop bothering
Before
15s
After
3s
0s5s10s15s
Same queries, same data volumes. The 10-second line is our rule of thumb, not a measurement.
$72kSaved in year one by replacing a six-figure BI licence with a tuned, embedded Superset stack. Signed off by the client's Finance team.
Cut your dashboards down to the ones that decide things.A short call, or record a message. A person replies within one business day.
Contact usCertified Services Partner, Claude Partner Network