Qlik Case Studies ILCo delivers superior reporting with QlikView and saves millions through improved forecasting and decision-making
Edit This Case Study Record
Qlik Logo

ILCo delivers superior reporting with QlikView and saves millions through improved forecasting and decision-making

Qlik
Analytics & Modeling - Real Time Analytics
Mining
Supply Chain Visibility
Predictive Maintenance
Data Science Services
System Integration
ILCo, the Integrated Logistics Company, operates the Dalrymple Bay Coal Chain, a major coal supply chain made up of 14 stakeholders, including mining companies, rail and terminal operators, rail network manager and government agencies in the northern Bowen Basin part of central Queensland, Australia. The industry is responsible for millions of tonnes through coal exports and the smallest process improvements can lead to millions of dollars in savings. However, during ILCo’s first two years of operation it became apparent that there was a lack of transparency and understanding in how the 14 participants, who all rely on each other, work together. Each of the companies was collecting its own data and measuring what they believed was important. However, this didn’t take into account was important to the other participants. For example, rail operators were reporting on train cancellations whereas punctuality was important to their supply chain partners. In order for the coal chain to work as efficiently as possible a new, holistic approach was needed – one where the information collected and shared could be used for mutual benefit and profit.
Read More
ILCo is the independent operator of the Dalrymple Bay Coal Chain, a major coal supply chain made up of 14 mining companies, train line operators, logistics companies and government agencies in the northern Bowen Basin part of central Queensland, Australia. The industry is responsible for millions of tonnes through coal exports and the smallest process improvements can lead to millions of dollars in savings. To find those savings ILCo knew they needed to measure what was happening, share the information and then act on what they learned. However, during ILCo’s first two years of operation it became apparent that there was a lack of transparency and understanding in how the 14 participants, who all rely on each other, work together.
Read More
ILCo engaged a consultant to define common performance indicators across the coal chain. They ended up with a list of 79 key performance indicators that were custodian and manager of the solution. Working with the solution designer, SIBA Solutions, who created the performance management framework, ICLo used QlikView as the analytics tool. ILCo implemented the SIBA PMF QlikView solution as a way of tracking the 79 performance measures. By having ILCo and the 14 participants look at a common data set it is now possible to work cooperatively and find ways to deliver improvement value right through the entire coal supply chain. The data is collected by each of the participants in their different systems and exported as comma delimited CSV files. This is then aggregated in the SIBA PMF QlikView application. While the data loading process could be considered low tech it enabled ILCo and the participants to accelerate the deployment of the PMF application so that the benefits could be realised as soon as possible.
Read More
By having a single version of the truth all of the participants in the Dalrymple Bay Coal Chain are able to focus on improving the performance of the coal chain rather than wasting time arguing over which data is correct.
This has led to improved operational forecasting and smarter decisions when it comes to infrastructure investment.
The payback on ILCo’s investment in the SIBA QlikView PMF was realised almost instantly.
The availability of accurate and agreed data through the entire coal chain has led to smarter investment decisions.
Download PDF Version
test test