Operations Dashboard for a Logistics SMB

Replaced a wall of spreadsheets with one unified operations view.

Next.js
Node
Postgres
Redis

THE PROBLEM

The fleet manager ran the business out of twelve Google Sheets linked by pray-and-hope formulas. Every question about a shipment required three tabs and a phone call.

WHAT WE DID

01
Normalized the data model into Postgres — shipments, drivers, vehicles, fuel, incidents — with migration scripts that preserved the historical sheets.
02
Live driver GPS ingestion (existing telematics provider) so the dashboard shows real positions, not yesterday's snapshots.
03
Role-based access so dispatchers see their region, the owner sees everything, drivers see their own day.
04
Mobile-optimized views for the yard and on-the-road use.

OUTCOME

One source of truth. The fleet manager estimates it saves around ten hours a week of reconciliation, and the owner can finally answer 'how are we doing?' without a phone call.

HAVE A PROJECT LIKE THIS?

Let’s talk about yours.

Start a project →