Luton Borough Council, is a local government entity in the ceremonial county of Bedfordshire, England.
It is a unitary authority and provides all local government services in the area having the powers of a non-metropolitan county and district council combined. It is a member of the East of England Local Government Association.
The Challenge
Legacy data with rampant data quality challenges
Due to the implementation of a new housing management system, Luton Borough Council required a powerful, easy-to-use and affordable data matching and data cleansing tool. Their old system spans various applications and the data can be many years old. The data entry systems for many of these older applications are, unfortunately, “free-text” based which causes huge issues with data quality. As such, whilst moving to a new system, as the data has to be ported to the new application, they wanted to cleanse and de-duplicate their properties and people data within the system.
Moreover, with data quality becoming an increasingly important challenge, the council needed to get all data stored about properties, people, and any other assets essentially in one place, or at least to have one definitive source. To do so, they needed a solution that could easily extract data from different sources so it could be treated for duplicates before it is imported into the new system.
The Solution
Alan Kirk and his team chose WinPure™ Clean & Match Enterprise, mainly due to its superior functionality over its peers, but also its competitively priced solution and easy to use interface. According to Alan Kirk, who works within the Information Management Department, WinPure’s Clean & Match was instrumental in enabling a smooth and efficient data import process. Moreover, with the no-code data matching technology, the team was able to match a dataset of 21,000 properties against a database of 100,000 records in under 30 seconds!
With just a few clicks they were able to merge all the duplicated records into single rows without losing any of the important data which had been gathered over many years.
Benefits
- With WinPure’s robust data matching software, the team was able to deduplicate large datasets within minutes, significantly improving efficiency.
- The tool’s data integration capabilities allowed for the easy consolidation of data from multiple sources.
- A user-friendly platform allowed Alan and his team to easily and quickly transform, deduplicate, and consolidate data.
💬 Talk to us about how your business could benefit from cleaner data!
Due to the success of using WinPure Clean & Match in these systems, I have since been asked to analyse data from other systems for both detecting possible fraudulent entries as well as simple data cleansing in order to create more efficient systems and reduce the amount of redundant data stored. WinPure Clean & Match is a software tool we simply cannot recommend enough.
Alan Kirk
Information Management Department
Industry Clients
