← AI Ops Analyst

Chapter 3 · 70 min · free

Reconcile or it didn't happen

It's Wednesday, 9:15am. Yesterday you ripped a filter out of `churn_rate` and the board number snapped back to the truth. But fixing one metric taught you something uncomfortable: nobody at Ledgerline can walk a single headline number on Thursday's deck back to the raw rows that produced it. Activation, revenue, NPS, gross margin — each one passes through six derived tables, and every table is a place a definition can quietly drift. This morning the finance lead pings you: 'the deck's MRR is $4.21M, but the Stripe export says $4.06M — which one do I present?' You have one day to make every number on that deck reconcilable, and to wrap the ones that already moved in tests that go red the instant the next silent drift lands. In the next 70 minutes you'll trace a number to raw, catch a reconciliation gap, read an agent that audits its own math, and ship the tests that make Thursday defensible.

You'll walk out able to

  1. Walk any headline metric back to the raw rows that produced it, table by table
  2. Spot a reconciliation gap and name which derived layer introduced it
  3. Tell an honest rounding difference from a definition bug that hides money
  4. Write drift tests that go red the instant a metric is silently redefined
  5. Read an agent that reconciles its own numbers and catch when it fakes the tie-out
Your first task

Which layer lost the money?

The deck says MRR is $4.21M. The Stripe export says $4.06M — a $150K gap, every month. The finance lead wants to know which number to present Thursday. You open the two models that sit between Stripe and the deck. Both changed last sprint. One of them is inflating MRR.

What you'll answer

Read both changes. Which one makes the deck's MRR read $150K higher than the raw Stripe revenue?

Free · no card · we save your progress

Save your progress & earn the certificate

You've seen the opening — keep going free. 6 tasks · auto-graded · finish in 70 min and the certificate is yours. Free forever · no card.

No password. To sign in on your phone, request an emailed code on the sign-in page.

Already started? Sign in with an emailed code instead.