Dirty Data

By Mitch Betts

December 17, 2001 12:00 PM ET

Computerworld - There are many ways that a supplier named IBM could be entered into a supply chain database: IBM Corp., I.B.M. Corporation, International Business Machines Corp. or a host of other variations.

Any one of those monikers might work well enough for a specific transaction. But if a company wants to see how much business it's doing with IBM overall, the name variations become a problem. The company might be doing $100 million worth of business with IBM, yet a database query might show only $20 million, depending on which name is used in the query.

The result is that the company wouldn't have a complete, accurate view of its suppliers so it could negotiate better deals and volume discounts.

"We see 20% duplicate supplier records," says Craig Verran, assistant vice president for supply chain solutions at The Dun & Bradstreet Corp. in Murray Hill, N.J., which helps companies clean up their supplier files.

That's just one small example of how uncleansed data gives a company the wrong picture of its supply chain.

"Companies are making bad operational decisions every day of the week [and losing money] because of bad data quality," says Ted Friedman, an analyst at Gartner Inc. in Stamford, Conn.

Housecleaning

Rules of thumb for a data quality initiative:

First, establish the processes to prevent errors. Then clean up the existing errors.

Start with critical data suppliers: Insist they provide accurate and current data.

Focus on the most important data.

Meet the most important data needs of the most important customers.

Don’t be seduced by cleanup tools. They’re no substitute for preventing errors.

Pick specific software tools to solve specific problems rather than general tools for general problems.
Source: Data Quality: The Field Guide, by Thomas C. Redman (Digital Press, 2001).

Poor data management is costing global businesses more than $1.4 billion per year in billing, accounting and inventory snafus, according to a survey of 599 companies by PricewaterhouseCoopers in New York. One-third of the companies say that "dirty data" forced them to delay or scrap a new system.

"We have had major [supply chain] software projects fail for lack of good data," says Donald Carlson, director of data and configuration management at Motorola Inc.'s semiconductor products group in Austin, Texas. In a presentation at a recent data quality conference, he recalled how a new supply chain planning system had to be scrapped because bills of material were hit by a triple whammy: incomplete data, inaccurate data and different data formats in different countries.

Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Additional Resources

Xerox

Win a color printer!

By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!

Microsoft

Upgrade to Internet Explorer 8 today.

Save time and mitigate security risk. Deploy it now.

Sybase

NEXT-GENERATION MOBILITY PLATFORMS

In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

Supply Chain Agenda 2009
Crisis dominates the supply chain agenda in 2009. Which projects will hold out in these difficult times? The study reflects the most important...

Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....

Accelerate SSL Encrypted Applications
The amount of SSL traffic is growing in the enterprise. Because it is encrypted, it cannot be properly controlled and accelerated. Blue Coat...

The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....

ESG Lab Field Audit
Many companies have successfully implemented Riverbed WAN optimization solutions within their Cisco networks. This ESG Lab Field Audit document explores the success that...

SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....

Shape Your Apps Strategy to Reflect New SaaS Licensing and Pricing Trends
Why are smart companies choosing software-as-a-service? Find out in the complimentary Forrester Research report...

Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...

Natural User Interface for Enterprise Applications
Learn how a revolutionary user interface can make a complex enterprise application so intuitive even casual users can jump right in....

Agile Enterprise Content Management (ECM) for Rapid ROI
Find out how combining ECM and BPM will help adress issues about content rich business processes....

All White Papers | All Webcasts