image
Customer Story

GHD + Alteryx

GHD Key Stats

Industry: Consulting
Department: BI/Machine Learning
Region: Australia

Hours of Cleansing Reduced to 30 Seconds

Contact Us

Data Accuracy Match

Explore Our Products

Increase Predictive Capability

Calculate Your ROI

Searching for a solution

The state government in Melbourne, Australia contracted the machine learning (ML) team at GHD, a global consulting company, to improve container supply chain processes through the collection and understanding of large datasets from industry, government, and transport software service providers.

The team, led by Nikita Atkins, Data Science Global Leader, GHD, used Alteryx to narrow 100 million shipping container and commodity records down to 1.9 million with a 99.9965% match accuracy rate.

Additionally, using Intelligence Suite, they were able to forecast and build predictive models to better estimate where containers were going, what commodities they held, capacity level of each container, and how long it would take for them to return from their destination to the origination point to better assess government spending and infrastructure investment.


What took my team almost a year to complete, and other firms longer to do in previous years, is now replicable and can be done in a matter of weeks.

Challenge

Every five years, the Port of Melbourne (PoM) in Australia is required to track all shipping containers that enter and exit. Understanding where freight moves is critical to ensuring the correct infrastructure, industrial land, planning controls, and policy settings are in place to support efficient supply chains.

The PoM was utilizing more than 57 independent groups to track the data in over 60 different formats. This process typically takes hundreds of hours of manual time and resources, and historically, the forecasting rate fell below 30%. Additionally, they were unable to complete a successful match analysis – until recently.


Solution

In 2019, Nikita Atkins and the machine learning team at GHD were able to develop a predictive modeling process and champion the commodities and container survey. They used Alteryx to gather data from September to October 2019 (over 250,000 container trips) standardize it, combine it, and de-dupe 100 million records provided and include over 200 business rules before making the data consumable. They were able to compare their final data set of 1.9 million records to the PoM and found that their data cleansing with Alteryx yielded a match of 99.9965%.

They used Alteryx Intelligence Suite to build 10 predictive models and compare their effectiveness. They narrowed their selection and were able to estimate a container’s location — including its origination and destination point, the commodities held, the capacity level of each container, and provide insight into what a container’s return trip ending point and timeline was.

After completing this process, Nikita’s team gathered the exact data from the PoM and compared it to what their Alteryx Intelligence Suite model had forecasted. The results showed their work had a 77% accuracy rate in tracking the trip cycle of commodities and shipping containers. This was undoubtably the highest predictive yield PoM had ever expected.


Results/Business Impact

The insights GHD developed with Alteryx Intelligence Suite gives the local and state government an understanding of where containers are going and where commodities are being purchased to better inform decisions in transport infrastructure and network planning. In turn, this enables the delivery of a faster, focused, and more productive supply chain.
	IDC InfoBrief dynamic 432x767
White paper
3 min to read

IDC Survey Spotlight: Finance and Accounting Digital Transformation Use Cases

Get insights from IDC Survey Spotlight: Finance and Accounting Digital Transformation Use Cases. See how 14 finance and accounting BPO service providers are using advanced technology

Finance
Read Now
colleagues white-boarding
Use Case
4 min to read

Partner Capability Matrix

Create a one-stop dashboard of partner capabilities to educate sales on what each partner has to offer.

Education
Energy & Utilities
Entertainment & Media
Read Now
Dark background blue dots of lights in varying shades
Blog Post
5 min to read

Leveraging Alteryx for a Successful Job Search

Learn how Mike Davis' experience with Alteryx put him ahead of the competition.

Analyst
Alteryx Designer
Data Prep & Analytics
Read Now

Transform Your Analytics

Get ready to unlock hidden insights in your data

Free Trial