The Challenge
LogiTrack's operations team was spending 15+ hours per week manually pulling shipment data from three different ERPs, formatting it in Excel, and emailing static PDFs to stakeholders. Data was always at least 48 hours stale, decisions were being made on outdated information, and analysts were burning out on rote copy-paste work.
The Solution
I built a live Power BI dashboard connected directly to LogiTrack's PostgreSQL warehouse via an incremental dbt pipeline that refreshes every 30 minutes. A Python-based data quality layer flags anomalies (late shipments, missing carrier codes) before they reach the dashboard, and a scheduled Resend email digest delivers a one-page summary to leadership every morning at 7 AM — no manual intervention required.
Results
94%
Reduction in manual reporting hours
30 min
Data refresh cadence (was 48 hrs)
15 hrs/wk
Analyst time reclaimed
3 ERPs
Unified into a single source of truth
Tech Stack
“Charles delivered exactly what he promised — on time and with zero drama. Our dashboard has become the single most-used tool in the ops team. I can't imagine going back to the spreadsheet nightmare we had before.”
Marcus Osei
Head of Operations, LogiTrack Ltd