Answers to the question you searched for, with the numbers attached.
-
Deep dive
Reconciling what was sold with what was on air
A sales team asked for an occupancy screen. Underneath, three engines disagreed and the two systems shared ids only part of the time. How I rebuilt the engine, matched orders to schedules, and validated it per machine-day and against finance.
measured ▸ 460,691 machine-days compared with the source, 18 differences · order values matched finance 1,277 of 1,277 and 382 of 382
-
Deep dive
From 26 minutes to 8 seconds: replicating a legacy export
A finance team downloads a spreadsheet every morning that a vendor's legacy system builds with about 82,000 queries in 26 minutes. I rebuilt it with 9 queries in 8 seconds, and proved it equal cell by cell before anybody relied on it.
measured ▸ 26 min → 8 s · ~82,000 queries → 9 · 862,297 fields compared, 0 divergent · 515,530 cells 100% identical