Customer description‍

An international logistics service provider active in road, air and sea freight. The company transports thousands of shipments worldwide every day and worked with multiple TMSs and external transport partners.

Challenge‍

Due to fragmented data from dozens of sources, real-time insight into shipment performance, delays and CO₂ emissions was missing. As a result, we responded to deviations and there were no optimizations.

Solution‍

A central data layer was developed that brought together data from the TMS, telemetry systems, partners and sensors. A real-time dashboard was built on this that gave operations, management and customers direct insights into performance, anomalies and sustainability.

Approach

1. Connect data sources
   Integration of internal and external data sources, including route information, tracking data, partner feeds and CO₂ calculations.
2. Building a data model
   Development of a standardized data structure to make performance comparable across modalities.
3. Real-time dashboard design
   KPIs such as ETA, delays, CO₂ per kilometer and first-time delivery were visualized in a Power BI dashboard.
4. Accompanying adoption
   Training and workshops for operations and management to structurally use the dashboards in daily processes.

Results

• 11% CO₂ reduction through smarter routing
• Anticipate delays and anomalies more quickly
• Higher customer satisfaction thanks to insight into shipment status
• From reactive to data-driven operation

Learnings

Thanks to the integration of real-time data and KPI visualization, the logistics service provider's way of working changed fundamentally. Instead of analyzing incidents afterwards, the team is now proactively focusing on performance and sustainability.

‍