Internal Ops Dashboard

Note: This is placeholder content. The full case study is pending client sign-off for publication.

The problem

A 40-person operations team was spending roughly 12 hours per week manually pulling data from four different SaaS tools and consolidating it into a shared spreadsheet for leadership reporting. Every Monday became a reporting fire drill.

The operations director came to us with a clear brief: eliminate the manual work, show the same numbers in real time, and do it without touching the existing SaaS contracts.

Our approach

We audited all four data sources in the first week and designed a lightweight event-collection service that polled each API on a schedule. The front end was a React dashboard with pre-built views matching the existing spreadsheet layout — minimising the change management burden on the team.

We built it in eight weeks with a two-engineer team. No dedicated PM — the operations director served as the product owner and reviewed demos weekly.

The outcome

• 60% reduction in manual reporting time within the first month
• Real-time visibility replaced the Monday-morning report
• The dashboard became the primary planning tool at the weekly leadership meeting

"We honestly didn't believe we could retire the spreadsheet. It's been three months and no one has touched it."

— Operations Director, name withheld