You are here: silicon.com > Public Sector

Data clean-up pays off for Business Link

Case study: How to tackle a business intelligence project successfully

Tags: business objects, business link, business intelligence

By Andy McCue

Published: 9 May 2006 13:10 GMT

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.

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.

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.

  1. Zones
  2. Management
  3. Networks
  4. Software
  5. IT Services
  6. Hardware
  1. Verticals
  2. Public Sector
  3. Financial Services
  4. Retail & Leisure

silicon.com Public Sector
Get the latest public sector news straight to your inbox. Sign up for the PS newsletter today!


  • Jobs
Graduate Email Marketing Systems Analyst Online Marketing London - Flexible

They are looking for a Graduate Email Marketing Systems Analyst to analyse large amounts of response data to help marketing campaigns achieve their ...

AUTOMOTIVE DATA ANALYST

accuracy. Data Integrity Role Purpose To assist the company in achieving its business objectives and revenue targets through the provision of ...

Account Manager CRM E. Sussex to 30k

Ability to support client queries regarding campaign selections, use of tools or data integrity *Ability to discuss data issues with clarity and ...

Nick Heath
Let's shine a light into the public sector IT money pit
With £16bn being spent, why is productivity still falling?

Tim Ferguson
BBC is taking tech seriously, so give it a break!
Auntie is the envy of the world but doesn't get the credit it deserves at home...

Peter Cochrane
Peter Cochrane's Blog: Open info for all?
Government stonewalling citizens

Nick Heath
Home Office CIO on taming tech and why ID cards are good news
Interview: Annette Vernon, Home Office CIO

Nick Heath
NHS records, Google and Microsoft: Where do you want your data?
Politicians: Heal thyself

Alan Hunt
NHS network: Time to get secure
Patient data in need of a check up

Agenda Setters 2009
Welcome to the ninth annual Agenda Setters poll – silicon.com's list of the top 50 most influential individuals in the technology and IT industries, from techies and CIOs to entrepreneurs and business leaders. Find out more in our latest special report.




Quick Sitemap Links: