Data clean-up pays off for Business Link

Case study: How to tackle a business intelligence project successfully

By Andy McCue, 9 May 2006 13:10

Not-for-profit start-up advisory group Business Link for London (BLL) has saved £100,000 after embarking on a business intelligence project to clean up duplicate and incorrect information in the organisation's databases.

BLL was created from an amalgamation of several different Business Link groups around the city and it was this that created the initial problem with the accuracy of the customer contact data used for marketing and sales.

BLL is a public sector body funded by the London Development Agency, which provides diagnostic and brokerage services for entrepreneurs and small businesses with fewer than 250 employees as well as advice on finance and marketing.

Mike Pratt, data integrity manager at BLL, told silicon.com: "They just brought it all together and planted it into a database. At least 50 per cent was incorrect or duplicated."

Using business intelligence tools from First Logic, which has now been acquired by Business Objects, BLL has spent the last three years cleaning up the databases.

Pratt said: "We have reduced our duplication down to something like 2.5 per cent. It's fantastic progress in a short space of time."

Accurate customer data is vital for BLL's marketing campaigns and Pratt said the clean-up project has already paid for itself.

He said: "It saved us something like £100,000 in terms of avoiding irrelevant marketing campaigns to people that didn't exist and sending people out to businesses that didn't exist - not to mention the huge amounts of time in IT resources investigating these problems."

But despite this success Pratt warned that many organisations still approach business intelligence projects the wrong way.

He said: "Business intelligence is seen to be the solution to all their ills. But before they do that many companies don't do the groundwork. They need to ask what is it they are trying to measure, do they capture that data and do they have the quality of data to make it meaningful?"

As if to demonstrate that not all business intelligence projects are successful, Pratt said a recent Cognos business intelligence project centred around the BLL's PeopleSoft CRM system has been scrapped after failing to work properly.

Comments

There are 2 comments. Join the discussion

  1. 1. martyn

    Forgive my hollow laughter but I have lost count of the times this lot have promised me I have been taken off their database.

    Guess what has landed on my desk today?

    Correct.

  2. 2. anonymous

    Spending 3 years to save £100000 on dodgy data. It would have been far cheaper to obtain target data from the private sector as that would have saved them the £300000 they are admitting they wasted in the past years.

    I have long viewed this organisation as less than useful at anything other than acting as a red-tape advisor, run by rather second rate management consultants.

Post your comment

In order to post a comment you need to be registered and logged in.

Log in or create your silicon.com account below

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy.

Questions about membership? Find the answers in the Membership FAQ