Delta BI
Home
AboutCompany overviewTeamMeet the team
ServicesConsulting servicesSmartMaintainPredictive maintenanceFinance AutomationFinance automation
Case StudiesBlog
MaritimeEnergyLogisticsManufacturing
Request a data assessment
enespt
Home
AboutTeam
ServicesSmartMaintainFinance Automation
Case StudiesBlog
MaritimeEnergyLogisticsManufacturing
Request a data assessment
enespt

Data foundations that move operations forward.

Delta BI

Data you can act on. Built for asset-heavy industries.

Solutions

  • All services
  • Power BI consulting
  • Tableau consulting
  • SmartMaintain
  • Finance Automation
  • Predictive maintenance

Industries

  • Maritime
  • Energy
  • Logistics
  • Manufacturing

Company

  • About
  • Team
  • Case Studies
  • Blog
  • Contact

Get in Touch

consulting@deltabisolutions.comLinkedIn

© 2026 Delta BI Solutions. All rights reserved.

Back to Case Studies
Supply Chain LogisticsTransIberia Logistics (name changed)

Long-Haul Route Optimisation & Driver Scheduling

Long-haul trucks travelling through a European motorway interchange

Case study. Client names are changed for confidentiality. Results are measured against each client's pre-project baseline.

18%
Fuel Cost Reduction
Diesel spend fell by €2.1M annually through deadhead elimination and fuel-optimal corridor selection.
94%
On-Time Delivery Rate
Up from 79% — eliminating €1.2M in annual SLA breach penalties from key automotive clients.
12%
Fleet Utilisation Gain
Active vehicle hours per day rose from 6.4 to 7.2, enabling a 38-truck reduction in required fleet size.
31%
Driver Hours Violations Cut
Automated tachograph compliance reduced regulatory fines and driver fatigue incidents across the fleet.
Case studyClient names are changed for confidentiality. Results are measured against each client's pre-project baseline.

The Challenge

TransIberia Logistics operates 340 heavy goods vehicles serving automotive and grocery clients across Spain under strict delivery windows. Their scheduling system relied on dispatcher experience and static Excel route templates. Rising diesel prices, EU drivers' hours rules (EU Regulation 561/2006), and an increasingly dense delivery network were driving €1.2M in annual SLA breach penalties and a deadhead mileage ratio of 23%. Fleet utilisation sat at 64%, with dispatchers spending 5 hours each morning building daily plans that were obsolete by 09:00.

Our Approach

  1. 1

    Integrated real-time telematics from all 340 vehicles — GPS position, fuel consumption, speed, and engine load — into a central data lake via an FMS/OBD connector, creating a live operational picture for the first time.

  2. 2

    Built a digital twin of Spain's road network using HERE Maps API enriched with historical toll costs, road-grade profiles, and dynamic traffic patterns by corridor and time-of-day.

  3. 3

    Developed a multi-objective VRP solver incorporating delivery time windows, EU 561/2006 driving and rest-period constraints, vehicle load capacities, and vehicle-specific fuel efficiency curves.

  4. 4

    Created a 7-day rolling driver scheduling engine that optimises shift patterns against tachograph rules while minimising overnight costs.

  5. 5

    Deployed a real-time re-routing service that recalculates affected routes within 90 seconds whenever a traffic incident, delivery cancellation, or driver hours alert is detected.

  6. 6

    Integrated automated ETA feeds into client TMS portals and customer notification systems, replacing manual dispatcher phone calls.

The Solution

We replaced TransIberia's dispatcher-driven Excel workflow with an automated planning engine. Every morning at 04:00, the optimiser generates a complete 7-day route and schedule plan for all 340 vehicles, accounting for traffic, driver hours, vehicle capacity, and fuel costs simultaneously. Dispatchers transitioned from plan builders to exception managers, handling only the 4% of trips that deviate from plan. The re-routing service closes the loop in real time, keeping plans executable throughout the day.

Tech Stack

ML / AI

Google OR-Tools

VRP solver with time windows, capacity, and EU 561/2006 drivers' hours constraints.

Integration

HERE Maps Routing API

Road network modelling with toll costs, gradient profiles, and real-time traffic.

Data Engineering

Apache Kafka

Real-time telematics event stream from 340 vehicle FMS/OBD units.

PostGIS (PostgreSQL)

Geospatial route storage, depot catchment zones, and delivery-point indexing.

Python (Pandas, NumPy)

Telematics cleaning, fuel-efficiency modelling, and feature engineering pipelines.

dbt + Snowflake

SQL transformation layer and cloud warehouse for historical route performance analytics.

Visualisation

React + Mapbox GL JS

Dispatcher control tower with live vehicle positions, route overlays, and ETA heatmaps.

Power BI

Executive KPI reports for fleet utilisation, fuel benchmarks, and EU compliance dashboards.

“
We used to pay dispatchers to build plans that drivers had abandoned by 09:00. Now the system re-plans itself, our drivers finish on time, and we have not missed a contractual window in four months.
Head of Fleet Operations, TransIberia Logistics (name changed)

Related reading

→

ERP Data Integration: How to Unify Your Business Data

Connecting SAP, Oracle, and beyond to a modern analytics stack · 7 min read

Face a similar challenge?

Send us your challenge. We will reply to arrange a conversation and scope the next step.

Start with the decision

Turn one operational challenge into a measurable data plan.

Tell us about your challenge. We will reply to arrange an assessment and identify a practical route to delivery.

Request a data assessment