Fleet / IoT · 2025–2026
Fleet Management Dashboard
A control tower that joins the operations ERP (trips, assignments) with the GPS platform (live positions, geofences): live trips desk, dispatch board, yard and idle reports, pending-close detection and route-difference checks on one screen.
- Context
- In-house at Ashwheelz, Aramco-certified transport and equipment rental group in Saudi Arabia, where I am Technical Head
- Role
- IoT integration, build, operations
- Stack
- Python · Flask · Leaflet / Google Maps · Teltonika GPS via Gulf Axis · Microsoft Graph (OTP) · PostgreSQL on Railway · pytest
Updated 11 Nov 2026
The problem
Trips lived in the operations ERP, vehicle positions in the GPS vendor's portal, fuel in a third system. Nobody could answer 'where is the vehicle for this trip right now', trips finished on GPS but stayed open in the ERP for days, and vehicles made unexplained movements that only showed up in fuel bills.
What I built
A Python service that signs in to both portals the way a person does. The GPS vendor's REST API is disabled on this tenant, so it calls the web endpoints the portal itself uses. It matches every live vehicle to its trip and driver, applies client-site geofences, and runs the checks on a schedule. Write-back to the ERP happens only on an explicit confirm. Everything else is a dry run.
- Live trips desk with late / at-risk alerts
- Dispatch board: ranked free vehicles, matcher by client → vehicle class → nearest
- Yard geofence report (hours in yard per vehicle) and idle-time report
- Pending-close detector: GPS says finished, ERP says open → alert after 60 minutes
- Trip route and difference reports: ERP km vs GPS km vs expected
- Irrelevant movements with thresholds per vehicle class, mandatory notes and a nightly scan
- POI / geofence sync, categorised activity log with Excel export
- Daily offline-vehicle email and WhatsApp notifications to drivers and coordinators
Outcome
Dispatchers work from one screen, open-but-finished trips are caught the same hour instead of at month end, and unexplained kilometres have a name and a note next to them.
Screens
Want this for your company?
The engagement is described on the Fleet management dashboard service page: who it is for, what you get, how it runs, and the questions I get asked.
Offered through Tech Solutions
This kind of system is delivered commercially by my company, Tech Solutions. The matching pages there:
Notes from this build
Have a process like this?
Send me the thing your team does by hand every week. I will tell you honestly whether it is worth automating, even when the answer is no.
