Home / Work / Operations dashboard
One screen instead
of nine spreadsheets.
A Canadian logistics operator ran its day across a tangle of spreadsheets nobody fully trusted. We built a single internal dashboard that pulls live from their systems, shows real-time KPIs, and flags what needs attention before it becomes a problem.
The challenge
Nine spreadsheets, none of them agreed.
Shipments, fleet, billing and customer status each lived in its own spreadsheet, updated by hand at different times by different people. Numbers rarely matched, and the weekly report was a half-day stitching exercise.
By the time a problem showed up in a sheet, it had usually already cost them. Managers were making decisions on data that was stale before they opened it.
Our approach
Connect the systems, not copy from them.
Instead of replacing the tools that worked, we built a data pipeline that reads from each source on a schedule and lands everything in one trustworthy database — the single place the whole team can rely on.
On top of it we shipped a fast, role-aware web app so dispatch, finance and leadership each see the view that matters to them, without exporting a thing.
What we built
A live operations cockpit.
One pipeline feeding one app, designed around the decisions the team actually makes every day.
- Unified data pipelineScheduled connectors pull from their TMS, accounting and spreadsheets into one clean, validated database.
- Real-time KPI boardOn-time delivery, fleet utilisation, open invoices and margin, all live and refreshed automatically.
- Exception alertsThe dashboard flags late shipments, idle assets and overdue accounts before they turn into fires.
- Role-based viewsDispatch, finance and leadership each get a focused view, with permissions that fit their job.
- One-click reportingThe weekly report that took half a day now generates itself, ready to share in seconds.
- Yours to keepThe code, the data and the infrastructure are theirs — no lock-in, documented and handed over.
The outcome
Everyone finally trusts the number.
The team now starts the day on one screen that's always current. Around fourteen hours a week of manual reporting and reconciliation simply disappeared.
Problems surface while there's still time to act, and meetings start from the same agreed figures instead of arguing over whose spreadsheet is right. The dashboard has become the place the business runs from.
Built with
Start here
Tired of running on stale spreadsheets?
We'll map your data sources and show you what one live source of truth could look like. A 30-minute call, in English or French.