Automated data reconciliation for fleet management

Case study with our client in State Government

Our client is a state government department in need of a solution to improve the efficiency of their fleet management. ​

Challenge: Overcoming data inconsistencies with machine learning solutions​

The existing fleet data was being matched to external third-party data once a month, but due to data inconsistencies, the required matching of data was a time-consuming, laborious task. This matching process is critical for enabling the state fleet team to perform qualitative checks for “Best Buy” evaluations against the pricing provided by manufacturers.​

The Department sought assistance to establish a Machine Learning (ML) Proof of Concept (PoC) for their fleet management workload.​

Solution: Proof of concept driven by data science ​

DataDivers initially worked with the Department to discover the various facets of the fleet management issues and data. We discovered that matching vehicles between their own dataset and the external one was not straightforward, as some vehicles were described differently across the two datasets.​

Upon investigation, DataDivers recommended the use of data science techniques to “fuzzy” match fleet information using different ML and natural language processing (NLP) techniques. To ensure easy access to the “fuzzy” matched results, we provided the Department with a Power BI user interface as part of the PoC.

Value delivered: Reduced manual effort and foundations for scalable innovation​

The PoC demonstrated the potential of data science and machine learning by:​

  • Automating the matching process. This has drastically reduced the manual effort required to reconcile datasets, freeing up the Department’s people for higher-value tasks.​
  • Improving the reliability and consistency of data alignment through “fuzzy” matching techniques. This has been critical for informed decision-making.​
  • Ensuring more accurate and timely data comparison, so the Department can focus on conducting better value assessments when evaluating manufacturer pricing. This can potentially lead to cost savings or improved negotiation leverage.​
  • Democratising access to matched data. The Power BI interface enables non-technical users to leverage the ML outputs without needing technical support.​
  • Laying the groundwork for future analytics or AI initiatives. The PoC has shown the potential for integrating smart data solutions across other areas within the Department.

DataDivers

DataDivers’s domain in Rmkble is the deep ocean of data, analytics, and AI. Their expertise spans data and AI strategy, building data and AI platforms and hubs, advanced AI and ML driven analytics and data science, and creating a data first culture.

Learn more

Real stories. Real outcomes.

Customer stories from some of the many terrains traversed by Rmkble consultants.
Get in touch

Let's create positive change for your organisation

If you’re ready to discuss your goals, reach out to us via the form and one of our team members will be in contact with you.

Alternatively, drop us a query or an expression of interest at: operations@rmkble.com.au.

Thanks for reaching out! We've got your submission and one of our team members will be in touch soon.
Oops! Something went wrong while submitting the form. Please try again or email to basecamp_support@journeyone.com.au.