Case study with our client in State Government

Automated data reconciliation for fleet management in State Government

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

Chalenge

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.

Data Science, Advanced Analytics and Artificial Intelligence Solutions
Want to be data-driven, but not sure where to start with AI and data science?
Transform raw data into powerful insights that drive smarter decisions, fuel innovation, and accelerate growth. Our Data Scientists are here to help you dive deep into your data and make sense of it. We'll organise, analyse, and visualise it to help you leverage its power.

Read more client stories

Discover how DataDivers has helped leading organisations shape their data-driven future.

Get in touch

Let's create positive change for your organisation

Data is the lifeblood of every transformation, so let's dive into organising, analysing, and visualising yours.

Reach out today to speak to one of the DataDivers team via the form or by emailing us at contact_us@datadivers.io.

Thanks for reaching out! We've got your me 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 contact_us@datadivers.io.

DataDivers is part of Rmkble

Rmkble Family Logos