Fremantle Ports turns to analytics for safer harbours

 

Faster ship turnarounds after BI upgrade.

Fremantle Ports has upgraded its reporting engine in an attempt to smooth out the conflicting schedules between raw materials arriving at the facility by rail and ships arriving at the port.

The new system, based on Cognos 10 software, has already been put to the test to make speedier decisions on the impact of natural disasters and the signing of new customers, according to a Ports executive speaking at IBM’s Business Analytics Forum in Melbourne.

The WA-Government owned enterprise has in many respects become a vital organisation to the Australian economy.

Much of the mining exports that have continued to stimulate the Australian economy throughout the global turbulence of the past five years have passed through the facility.

Fremantle Ports’ inner harbour is responsible for all container trade for Western Australia and also provides facilities for everything from motor vehicle imports, livestock exports, cruise ships and visiting Naval vessels.

The Outer Harbour facilities - in nearby Kwinana – handle the export of grain, petroleum, LPG, Alumina, mineral sands, fertilisers, coal and many other raw materials.

For several years, Fremantle Ports management had been using reports generated by the ageing Cognos 7 suite, and had skipped an upgrade to the next version due to more urgent priorities.

Collins Vuchocho, business systems consultant at Fremantle Ports, told the audience at IBM’s Business Analytics Forum that management were expressing dissatisfaction with the application and the quality of data arriving on their dashboards.

Vuchocho said several drivers pushed the company towards considering wholesale replacement of the system.

It was seen as an impediment to a scheduled SQL-based data warehouse upgrade, and users were more often than not using the software as a means of accessing data for download to Excel spreadsheets to make it more useful.

Further, many of the staff that had designed Fremantle Ports’ Cognos-based reports had since left the organisation.

“We couldn’t keep going with it any longer, but we were also fully reliant on it,” Vuchocho said. “All our revenue projections were based on it.”

Upgrade drivers

The global financial crisis brought on new demands for accountability from corporate management.

“We were being forced to report a lot sooner, and asked to predict what was going to happen in the future,” Vuchocho said.

His team went to market seeking a new analytics and business intelligence platform, with some key criteria in mind.

First and foremost, they sought improved performance and reliability. On that basis alone, staff fed up with using Cognos 7 were reticent to recommend an upgrade of the platform.

“We weren’t looking at upgrading as an option,” Vuchocho said. “We actually stood back and looked at Cognos as something we didn’t have.”

The requirements demanded that the new solution be well documented.

“The labour market in Western Australia is constantly changing,” he said. “We had to make sure that whoever comes into the IT department had enough resources to land by themselves.”

Ports wanted a reporting platform that would work on mobile devices for staff working off-site, such that they could enter data directly into the system whilst out on a ship during a ship inspection, for example.

The tool also had to be intuitive from a user’s perspective. The brief stipulated a need for more visual data.

The IT team even went to the extreme of stipulating that users of the system - Fremantle Ports’ Trade and Statistical Reporting team - had to approve of any new solution.

“We gave users the power to look at it and say yes or no,” Vuchocho said.

Testing the latest products on the market, the reporting team shocked all with their choice – an upgrade to Cognos 10.

“It’s interesting - they were the ones that didn’t want Cognos because of their experience on Cognos 7 - it was poison to us!”

The turnaround

Vuchocho gave the audience a number of scenarios to show that the team made the right choice.

The dashboards were put to use, he said, when northern Japan was cripped by earthquakes and tsunamis some 12 months ago. Management sought reports on precisely how many cars Australia imports from Japan through the port, how many were scheduled to arrive prior to the disaster, and  how many were due to arrive before the inevitable production delays made an impact further down the supply chain.

“We now have a platform with a lot more visibility. We can accurately say what country cargo is coming from, and the users can drill down into information instead of asking IT for it,” Vuchocho said.

Questions were also asked when the Costa Concordia cruise ship ran aground off Italy in mid-January. What if the same event occurred within Fremantle’s waters?

Fremantle Ports conducted disaster recovery tests to recreate such a scenario in its own waters. Again IT was asked for new reports.

“The first person to get hit is the IT department because management want all the information they can get to make a decision,” he said.

The real ROI on the Cognos upgrade came in May 2011 when Fremantle Ports signed a deal with Mineral Resources to use the Kwinana outer harbour as an export facility for iron ore.

Mineral Resources and Fremantle Ports spent $44 million on upgrading facilities at the port such that trains could deliver iron ore from MinRes’ Carina mine directly to be stockpiled at the Port and loaded onto ships for export.

Vuchocho told the audience that this new customer drove a greater need for efficiency at the port, which was already challenged by the varied cleaning, loading or unloading times associated with the many products being exported and imported.

“You have to be accurate - iron ore ships are quite big, so you have narrow tidal windows to work with,” he explained. “We were very happy about the extra revenue coming in, but the challenge of servicing that customer was more complex than we thought.

“We ran a very stringent SLA [service level agreement] – we had to turn around a ship in under 40 hours. And when you have multiple trains that are 3km or 4km long wanting to use the port – the knock on effect of any delay is so costly, we could not afford it.

“That mix of container trains, iron ore trains and ships coming in and out meant we needed a platform to analyse data quickly to make decisions in real time rather than once a week or once a month.”

The upgrade from Cognos 7 to Cognos 10 took between six to eight months. The team managed to simplify the process by consolidating the 77 reports generated from Cognos 7 down to 30, keeping the “simplest and most important” and redeveloping the remainder in Cognos 10.

But the success of the upgrade – which has seen the BI suite rolled out to far more staff – has seen the number of reports blow out to 82.

Vuchocho said the new system gives Fremantle Ports “a lot of freedom, to the point that staff want to explore more. People have been rejuvenated, they can create their own dashboards. They are asking for more than standard user training.”

Users have also sought out new modules and now the BI team is investigating use of IBM Cognos TM1 and IBM Websphere to see how its use can be extended further.

“We are looking at WebSphere for modeling, for predictive analysis around ensuring efficient handling of ships while in our harbours to better plan for landside logistics,” he said.

Copyright © iTnews.com.au . All rights reserved.


Fremantle Ports turns to analytics for safer harbours
Fremantle Ports 'outer harbour' - Kwinana Bulk Terminal.
 
 
 
Top Stories
Frugality as a service: the Amazon story
Behind the scenes, Amazon Web Services is one lean machine.
 
Negotiating with the cloud email megavendors
[Blog post] Lessons from Woolworths’ mammoth migration.
 
Qld govt to move up to 149k staff onto Office 365
Australia's largest deployment, outside of the universities.
 
 
Fremantle Ports 'outer harbour' - Kwinana Bulk Terminal.
Sign up to receive iTnews email bulletins
   FOLLOW US...

Latest VideosSee all videos »

The great data centre opportunity on Australia's doorstep
The great data centre opportunity on Australia's doorstep
Scott Noteboom, CEO of LitBit speaking at The Australian Data Centre Strategy Summit 2014 in the Gold Coast, Queensland, Australia. http://bit.ly/1qpxVfV Scott Noteboom is a data centre engineer who led builds for Apple and Yahoo in the earliest days of the cloud, and who now eyes Asia as the next big opportunity. Read more: http://www.itnews.com.au/News/372482,how-do-we-serve-three-billion-new-internet-users.aspx#ixzz2yNLmMG5C
Interview: Karl Maftoum, CIO, ACMA
Interview: Karl Maftoum, CIO, ACMA
To COTS or not to COTS? iTnews asks Karl Maftoum, CIO of the ACMA, at the CIO Strategy Summit.
Susan Sly: What is the Role of the CIO?
Susan Sly: What is the Role of the CIO?
AEMO chief information officer Susan Sly calls for more collaboration among Australia's technology leaders at the CIO Strategy Summit.
Meet the 2014 Finance CIO of the Year
Meet the 2014 Finance CIO of the Year
Credit Union Australia's David Gee awarded Finance CIO of the Year at the iTnews Benchmark Awards.
Meet the 2014 Retail CIO of the Year
Meet the 2014 Retail CIO of the Year
Damon Rees named Retail CIO of the Year at the iTnews Benchmark Awards for his work at Woolworths.
Robyn Elliott named the 2014 Utilities CIO of the Year
Robyn Elliott named the 2014 Utilities CIO of the Year
Acting Foxtel CIO David Marks accepts an iTnews Benchmark Award on behalf of Robyn Elliott.
Meet the 2014 Industrial CIO of the Year
Meet the 2014 Industrial CIO of the Year
Sanjay Mehta named Industrial CIO of the Year at the iTnews Benchmark Awards for his work at ConocoPhillips.
Meet the 2014 Healthcare CIO of the Year
Meet the 2014 Healthcare CIO of the Year
Greg Wells named Healthcare CIO of the Year at the iTnews Benchmark Awards for his work at NSW Health.
Meet the 2014 Education CIO of the Year
Meet the 2014 Education CIO of the Year
William Confalonieri named Healthcare CIO of the Year at the iTnews Benchmark Awards for his work at Deakin University.
Meet the 2014 Government CIO of the Year
Meet the 2014 Government CIO of the Year
David Johnson named Government CIO of the Year at the iTnews Benchmark Awards for his work at the Queensland Police Service.
Q and A: Coalition Broadband Policy
Q and A: Coalition Broadband Policy
Malcolm Turnbull and Tony Abbott discuss the Coalition's broadband policy with the press.
AFP scalps hacker 'leader' inside Australia's IT ranks.
AFP scalps hacker 'leader' inside Australia's IT ranks.
The Australian Federal Police have arrested a Sydney-based IT security professional for hacking a government website.
NBN Petition Delivered To Turnbull's Office
NBN Petition Delivered To Turnbull's Office
UTS CIO: IT teams of the future
UTS CIO: IT teams of the future
UTS CIO Chrissy Burns talks data.
New UTS Building: the IT within
New UTS Building: the IT within
The IT behind tomorrow's universities.
iTnews' NBN Panel
iTnews' NBN Panel
Is your enterprise NBN-ready?
Introducing iTnews Labs
Introducing iTnews Labs
See a timelapse of the iTnews labs being unboxed, set up and switched on! iTnews will produce independent testing of the latest enterprise software to hit the market after installing a purpose-built test lab in Sydney. Watch the installation of two DL380p servers, two HP StoreVirtual 4330 storage arrays and two HP ProCurve 2920 switches.
The True Cost of BYOD
The True Cost of BYOD
iTnews' Brett Winterford gives attendees of the first 'Touch Tomorrow' event in Brisbane a brief look at his research into enterprise mobility. What are the use cases and how can they be quantified? What price should you expect to pay for securing mobile access to corporate applications? What's coming around the corner?
Ghost clouds
Ghost clouds
ACMA chair Chris Chapman says there is uncertainty over whether certain classes of cloud service providers are caught by regulations.
Was the Snowden leak inevitable?
Was the Snowden leak inevitable?
Privacy experts David Vaile (UNSW Cyberspace Law and Policy Centre) and Craig Scroggie (CEO, NextDC) claim they were not surprised by the Snowden leaks about the NSA's PRISM program.
Latest Comments
Polls
Which bank is most likely to suffer an RBS-style meltdown?





   |   View results
ANZ
  21%
 
Bankwest
  9%
 
CommBank
  11%
 
National Australia Bank
  17%
 
Suncorp
  24%
 
Westpac
  19%
TOTAL VOTES: 1445

Vote