Three self-hosted tools that answer questions a BI dashboard stopped answering: what the numbers looked like on any past day, what a rep will actually be paid, and whether last night's data pipeline ran.
When the team's BI tool was discontinued, every team fell back on its own historical archive. Those archives didn't reconcile with each other, they stored only final numbers rather than the underlying data, and answering "how did we look at this point last quarter?" mid-quarter was close to impossible.
One daily archive of the whole book, stored at rep grain, viewable exactly as it stood on any past date — no retroactive revenue. A two-handle timeline slider makes any two snapshots comparable, so a delta is whatever pair you point at rather than a fixed window.
Any two snapshots, any delta.
Reps couldn't easily answer "what do I earn at 112%?", and the plan mechanics — a stepped threshold, a ramp to full base, then marginal accelerator bands — live in a document rather than anywhere you can actually run a number through. Managers, meanwhile, had no structured way to flag a value that looked wrong.
One shared compensation engine that every page includes, so the schedules exist in exactly one place and can't drift between the rep-facing calculator and the manager review. Around it, a self-serve front end and an approval queue that keeps edits auditable rather than silent.
Threshold → ramp → marginal bands.
Automated reports fail quietly. You find out when someone opens a dashboard and the numbers look wrong — and because dashboards feed each other, one broken upstream job silently poisons everything downstream of it.
Every script posts a signed receipt when it finishes. The tracker holds those receipts and, crucially, holds a dependency graph between dashboards — so when an upstream report fails, everything downstream is automatically marked blocked instead of quietly serving stale numbers.
One failure, cascaded downstream.