Logistics giant Linfox is embarking on a big data-crunching exercise that will give its control centres the ability to predict hazards and help drivers navigate around them.
The company is using a SAP HANA in-memory analytics database engine to crawl about 12 million real-time records generated by telematics equipment on a subset of its 5000-plus truck fleet.
Real-time truck positions are mapped geographically. Desk-based controllers in centres in Western Australia and Thailand can drill through the data to street level to work out why trucks might be delayed or over the speed limit in a particular location.
The HANA-backed system also interrogates millions more historical data records to check if the same issues have occurred in that same area before, and maps the result.
It is hoped the speed with which this data-crunching occurs will allow control centres to quickly intervene if they recognise history repeating.
"We want to be looking at right-now's information to determine what's going wrong and how can we tailor it to get a better result," chief information officer and supply chain president, John Ansley, told SAP's Sapphire Now event.
He said having the HANA system allowed the company to to get the information, crunch it in real time and compare it against trend data.
"If we see something that's occurring today that looks like something that happened weeks ago, and we know that gave us a bad outcome, we can actually do something more quickly about it."
Ansley said that something might mean messaging drivers "before they get to a danger spot".
No need for speed
In one of several technical demonstrations of the system, the company focused on locations where trucks briefly exceeded speed limits. A cluster was identified, and drill-down into the map initiated.
A terrain view showed mountains and hills nearby, and the problems were limited to a single traffic lane, pointing to a downhill run.
"We could be messaging the trucks as they're approaching this area and say, 'Please take caution, you're about to approach a long downhill run where you're likely to overspeed'," Ansley said.
"So we can really have some influence here if we've done the predictive work first, and figured out exactly where these areas are for us."
Linfox is also turning the system to tackle problems with idle assets. Improvements could result in utilisation, financial and sustainability benefits for the company.
"If we've got a vehicle that's waiting to be unloaded or loaded at a customer site, should we be charging the customer for that?" Ansley said.
"Is that a demurrage instance where we should be saying, 'Hey. We've got an agreement with you that says we won't be here for any longer than half an hour or 45 minutes. If we're here two or three hours we start to renegotiate our contract and make it make sense for both of us'."
A technical demonstration of the big data system turned up several clusters of idling trucks.
Ansley identified one cluster as being Linfox's workshop, and two adjacent clusters as "refrigerated components".
"They will look like their idling but actually it's OK for them to be idling because its refrigerating containers, so if they're not idling then the product's going off," he said.
"So this is a good instance of idling. But we can drill into these things."
Ansley said it is possible to drill down to the unique resource ID of an individual truck when investigating instances of idling.
We can ... see which truck it was and why was it idling for this amount of time," he said. "And if the reason was that the driver just wanted to keep his air conditioning going so that the cabin was cool when he got back in, well, we'll talk to the driver.
"We'll make sure they understand that's not an appropriate use of fuel or an appropriate emission of greenhouse gases."
Read on for routing examples that save Linfox money ...