Built a lightweight Power BI model that merges EDI 214s, telematics pings, and WMS scans to compute OTIF, dwell, and lane reliability at carrier, lane, and day granularity; using it we cut detention 18% in 90 days across 4 DCs. If you want the.pbix plus the SQL/DAX patterns for time-window logic and early/late bins, I’m happy to share and would appreciate benchmark targets by mileage band.