Working with Alteryx Premier Partner NCS NEXT, the GIT team implemented Alteryx. Initially, the platform functioned primarily as a data blending tool to help the team reconcile different types of data from over 100 applications, spanning finance, supply chain, sales, and more. Transactions, contracts, KPIs, mapping files, budgets, and more all needed to be matched up to create a full picture of the business’ performance and requirements.
The first use case started with a prototype for the accounting team, designed to reduce the amount of manual work involved in data preparation and reconciliation. Alteryx compares Jebsen’s bank account records to accounting entries in its Oracle ERP system, creating a spreadsheet that highlights any exceptions for the team to check. End to end, this process could take days using manual comparison methods — but now, it’s completed in minutes, allowing the accounting team to focus on the figures with full confidence that its sources are accurate.
“After this initial use case, we realized that Alteryx is a very powerful tool for ETL too,” says Tang. “There’s a huge range of pre-built connectors, so we can link up all our applications and consolidate our data.”
The GIT team collaborates with stakeholders across the business to identify repetitive manual processes in Jebsen’s finance, logistics, customer services, and other core functions. By targeting these time-consuming tasks, individuals are able to save hours in their workweek, which quickly adds up to huge time savings across the group.
As Tang explains: “Everyone is familiar with working in spreadsheets. But when there are a lot of worksheets, and each one contains multiple formula, it can take hours or days to try and trace any issues and understand how it all works. With Alteryx, we can make everything transparent, figuring out any discrepancies or problems within an hour.”
Before, it could take several months for the GIT team to be able to deliver a new use case with traditional data handling and development methods. But with Alteryx, a prototype can be ready in just two weeks; in less than a month, the team can take a process from ideation to MVP, then onto fine tuning and training.