John Schwarz
Schwarz: BI systems reduce mistakes

Interview: Business Objects' chief says data cleansing is key for business intelligence

John Schwarz explains why firms will see more value in BI tools as data quality improves

Written by James Murray

IT Week: Business Objects has recently announced a new Enterprise Information Management (EIM) portfolio designed to improve the quality and management of firms' data. Why do you feel there is a need for these products?

John Schwarz: [Data quality] is a big hurdle for firms deploying BI systems. Most large organizations have literally thousands of apps that they run their business on and these apps have been built up over the years with each having different data structures. As a result data is duplicated all over the organisation and a lot of it is inaccurate. This situation is then complicated further by mergers and acquisitions, which can add still more data complexity and inconsistency each time you acquire a company.

Why is more accurate data so important? Many firms would argue they do well with their current systems.

If you can get more accurate data it enables better decisions, helps you treat customers better and keep your customers happier. You only have to realise that if you send invoices out to the wrong person you don't get paid. There are also real cost savings in that you don't have to invest so much in manually cleaning the data and it reduces the number of mistakes you make. One company I know of does 300,000 new transactions a quarter and only 15 percent of those have accurate and complete data. The company was spending millions each quarter with [business information firm] Dun & Bradstreet to clean the data, but each quarter more wrong data was coming into the system so it became an insurmountable problem.

Given how entrenched the problem is, how can firms improve data quality?

The aim of EIM solutions is to help bridge all these differences in the data that create inconsistencies. I don't believe companies will ever get just one data format, and as long as they have apps using different formats they need a way to bridge the gaps. The only effective way to do that is through EIM solutions that give you the ability to automatically integrate and federate data. Business Objects' move into this area is critical to our development.

How does data cleansing technology work?

There are two basic techniques we use. The first is to check the customer data against canonical data; and we have a massive database in the US of corporations' details that we use to check firms' customer data against. We also partner with business data firm Identex in the UK to offer a similar service in Europe. The second technique is to set up policies that automatically filter the data as it is input so you can ensure it fits into a certain range that you know to be correct. You can then either block or flag up any data anomalies that may need investigating. We are giving companies the ability to take overlapping data sources and determine which data should be taken as the canonical version, as well as determine which data is most current and ensure that the two data sources are kept in sync.

The urgent need to improve data quality problems suggests firms have not enjoyed the benefits they expected from BI reporting systems. Were you guilty of over-hyping the effectiveness of BI systems?

I don't agree that BI has been over-hyped. If anything it is still being undervalued. However, what I do believe is happening is that IT teams had a hard time clearly explaining the value [of BI] to business managers. That is where the big opportunity lies for BI vendors such as Business Objects because we can show how you can deploy BI to solve real business problems, such as compliance or risk management or productivity issues, and that will really drive future adoption.

BI vendors frequently claim BI has penetrated just 15 percent of the potential market. Given the benefits it can offer why do you think adoption remains so low?

I'd suggest customers have focused on ERP [enterprise resource planning] and their core apps for the past 15 years and BI was seen as a side project. It is only now firms have relatively stable ERP systems and databases that the energy is there to look at how to use those technologies to optimise the business and that is where BI has value. I believe we are rapidly approaching an inflection point for BI adoption.

How so?

As more and more US firms adopt BI systems they are making it a competitive essential and we are seeing that influence filter through to Europe. We have one mobile phone operator as a customer that deployed our BI tools to help detect customer fraud. It saved millions of dollars through that deployment and all that money can now be invested elsewhere. The technology is making the company more competitive and as a result its rivals will be under pressure to emulate its approach.

About John Schwarz

John Schwarz was appointed chief executive of Business Objects last year.

Previously he was president and chief operating officer of security giant Symantec.

Schwarz has also worked as a senior executive at IBM, where he spent 25 years in development, manufacturing, sales and marketing positions.

Tags:

reader comments

related articles

Standardised BI lifts efficiency

Single suppliers offer time, and money, savings 05 Jan 2006

 

BI adoption faces skills barrier

Access to information is CIO's highly-ranked tech concern 08 Feb 2006

Firms must standardise BI strategy

Firms must make major cultural switch to take full advantage of BI capabilities 23 Mar 2006

Oracle launches BI suite for heterogenous environments

Oracle BI Suite Enterprise Edition promises better reporting and analysis tools 23 Mar 2006

Cognos training closes BI skills gap

Firm hopes to head off potential skills shortages 06 Feb 2006

SAP customers to face BI disruption

NetWeaver business intelligence apps to be phased out 01 Oct 2008

Analysts discuss BI trends for 2008

Analyst firm Gartner's predictions for outsourcing in 2008 20 Dec 2007

Business Objects XI 3.0 brings BI to the masses

Business Objects has updated its BI tools, promising to simplify the user experience 13 Feb 2008

related whitepapers

today's top stories

CIOs must embrace collaboration tools

Author Don Tapscott gives Angelica Mari his reasons for promoting social networking tools and says transparency is the key to security 04 Dec 2008

On a quest to build a connected society

BT Design’s JP Rangaswami talks to Gareth Morgan about his pivotal role in the telecoms giant’s efforts to deliver universal broadband and his plans to tap into the creativity of the open source community 04 Dec 2008

IT leaders must stand by India

A sense of perspective is the most important response from IT leaders to the attacks in Mumbai 04 Dec 2008

Case study: Clifford Chance

Law firm implements Sun platform and reduces datacentres to gain efficiency and cost synergies 03 Dec 2008

Should CRM be more sociable?

As vendors rush to add more social networking bells and whistles to their CRM products, some experts warn that users must tread carefully when venturing into online communities 03 Dec 2008

Advertisement

Newsletter signup

Sign up for our range of FREE newsletters:

Existing User

Newsletter user login:

Advertisement

Jobs

Related jobs

Job of the week

Job alerts

Sign up here

Find your next job

IT Salary Checker

Check salary here

Advertisement

White papers

Search white papers

Top categories

VPN, Extranet and Intranet Solutions

WAN/ LAN Solutions

Network Security

Interoperability-Connectivity

Grid/ Utility Computing

Latest poll

Will the terrorist attacks in Mumbai affect your offshoring plans?

Will the terrorist attacks in Mumbai affect your offshoring plans?

Is India becoming a risky destination?

Previous poll results

Latest audio and video articles

Padlocked CDVideo

Technology and privacy

Watch the final video in a two-part Computing roundtable debate on the importance of putting data privacy issues at the heart of your IT plans 02 Dec 2008

Podcast imageAudio

Computing podcast - Standard Life's offshoring plans; and the prospects for government IT

The insurance giant outlines its new outsourcing strategy; and we ask if the government's economic bailout will affect its IT plans 28 Nov 2008

Latest in-depth articles

Doctors looking at a computerAnalysis

Watchdog wants IT to cure privacy woes

Information Commissioner Richard Thomas is urging organisations to put privacy protection at the top of their procurement and development criteria 04 Dec 2008

Colin McDonaldComment

Web 2.0 has potential to transform staff training

Employees can sharpen their IT skills through using the latest interactive training tools, writes Colin McDonald 04 Dec 2008

Advertisement

Primary Navigation