Quarry Analytics · B2B software
A reporting portal that turned 12-minute queries into 40 seconds
A rebuilt data pipeline and self-serve reporting portal for a B2B analytics company whose customers had outgrown overnight exports.
Sample project
- median report time
- 40 s
- infrastructure cost
- −38%
- missed nightly runs since launch
- 0
The challenge
Customer reports took minutes to load and the nightly pipeline failed often enough that support dreaded Monday mornings.
Our approach
- 01Profiled the slowest queries and redesigned the warehouse schema.
- 02Moved the pipeline to infrastructure as code with automated retries.
- 03Shipped a new report builder behind a feature flag, customer by customer.
The result
Reports load in under a minute, infrastructure costs fell and on-call became quiet.
“Our support queue for reporting basically disappeared.”
Next case study
Civic DeskStart a project
Got an idea worth building?
Share a few lines about what you have in mind and we'll reply with next steps.