Sector: Logistics / Fleet Operations
Engagement: Analytics build
Service: Analytics & Power BI
SAT%
Automated trailer tracking rate, visible for the first time
Trailer GPS automation dashboard, bridging live and manual tracking during system transition
During a transition from manual reporting to live GPS-based tracking, the organization was receiving trailer data from two sources simultaneously, live GPS signals and older manually-updated files. Leadership needed a clear, accurate way to measure automation progress and identify which trailers were still relying on manual updates, so they could prioritize the transition.
Built a Power BI dashboard integrating both live GPS feeds and manually-updated tracking files. Created virtual tables and used DAX functions (CALCULATE, LOOKUPVALUE) to prioritize live GPS data whenever available, automatically falling back to manual data when needed. Designed the dashboard to track Status of Automated Trailers (SAT%) across regions, carriers, and trailer types while flagging discrepancies between data sources to surface gaps in automation.
Live GPS
Prioritized over manual data automatically via DAX
Weeks
Operations teams gained a centralized, automated view of trailer tracking status for the first time. The dashboard made it immediately clear which trailers were still dependent on manual tracking, allowing teams to prioritize transition efforts and improve overall fleet tracking accuracy within weeks of deployment.
To improved tracking accuracy across the fleet