Case studies

Luton Borough Council

Download/Print Case Study

Company

Luton Borough Council

Industry

Luton Borough Council, based in the United Kingdom, is the local government entity, made up of councillors from the 19 wards that split up the town.

Challenge

Due to the implementation of a new housing management system, Luton Borough Council required a powerful,  easy-to-use and an 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.

Alan Kirk works within the Information Management Department and explains, " As with many systems, data quality is becoming ever more important and there is a push to get all data stored about properties, people and any other assets essentially in one place, or at least to have one definitive source. In the case of our property data, we consider our Corporate Gazetteer (LLPG) to be our definitive source for property data as it the most comprehensive, well organised and managed set of property data that we have. I have therefore been extracting all our property data from the various older housing applications and attempting to firstly de-duplicate them, then match them against the LLPG. One of the great qualities about WinPure Clean & Match has been it's speed and simplicity for data importing and matching. Our LLPG currently has in the region of 98,000 records, and I can match a large dataset of 21,000 properties against this in under 30 seconds. This gives me the opportunity to easily clean up data which didn't match and keep re-matching to see what remaining changes need to be made.

Solution

Alan Kirk continues, "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 recommened enough"