Dirty Data

Mitch Betts   Today’s Top Stories   or  Other ERP/Supply Chain Stories  

Windows Vista® Migration: What Really Happens? A Customer's Perspective Real-time collaboration and development with IBM® Rational® Team Concert streamlines any project Web Threats Don't Discriminate A Synergistic Relationship: Marrying E Family Hardware and Windows Vista® Dell Client Migration and Deployment Services Breaking through the Dissimilar Hardware Restore Challenge Compterworld Technology Briefing: Intelligent Users Use Business Intelligence Computerworld Report- Large Enterprises Pay More for IPAM An Apple for Your Enterprise? Sign up to receive ERP/Supply Chain Resource Alerts

December 17, 2001 (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).

"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.

"We could do a supply chain plan for Hong Kong, we could do one for Scotland, but we didn't have a standard methodology," Carlson says.

Continued...
1 | 2 | NEXT  

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

"Ordering people to use Linux, at $725 U.S. a crack, is no way to make Linux popular..." Read more... Read more Software posts or See all Blogs

Virtually every Windows PC at risk, says Secunia License server glitch exposes SonicWall users to e-mail security threats Too good to ignore: 6 alternative browsers More top stories...

Clues point to Jan. 13 release of Windows 7 beta Microsoft releases Vista SP2 beta Feds nab more members of alleged identity theft gang

Review: The new MacBook Air, now with extra SSD goodness Thin as ever, the latest Air offers up to twice the storage and snappy performance. Cool Stuff: Your 2008 Holiday Gift Guide We've got an array of economical, expensive, and just plain weird tech gifts for your friends and family. Massive botnet returns from the dead, starts spamming The spam-spewing 'Srizbi' botnet that was shut down two weeks ago has been resurrected and is again under criminal control, say security researchers. Elgan: Why you can't trust 'friends' on Facebook Facebook is popular and growing -- especially with criminals. Here's why they love it. Windows 7 Get the latest news, reviews and more about Microsoft's newest desktop operating system More Continuing Coverage Windows 7 Voting Technology Google's Chrome browser Economy in turmoil: Latest news and tips iPhone 3G Bill Gates moves on Windows Vista A to Z Mac A to Z 2008 Salary Survey Find wage data for 50 IT job titles. More Special Reports 2008 Premier 100 IT Leaders 2007 Premier 100 IT Leaders 2008 Best Places to Work in IT 2007 Best Places to Work in IT 2008 Salary Survey 2007 Salary Survey 2006 Salary Survey 2008 IT Forecast 2007 IT Forecast 40 Years of Computerworld Top 12 Green-IT Users The FAQs About Going Green IT Schools to Watch iPhone: One Year Later Global Mobile Your Next Data Center Management: Reinventing IT Stop Data Leaks Web 2.0 Security Surviving Disasters Managing Storage Virtualization The Lean Storage Machine Storage on Trial Can Web 2.0 Save BI? Bypass These BI Potholes All Zones Business Continuity Zone The File Data Management Zone Security Management Zone The SAS Zone Business Intelligence and Analytics Zone The Enterprise Search Zone Software as a Service Zone The Security Zone See your link here

Learn-Fast Guide: Software as a Service is Growing Up Download this Computerworld Executive Briefing, a $195 value, for free! Compliments of Akamai. (Source: Computerworld) SaaS is here to stay as an application delivery channel. You will be using it, but will you do so wisely? This Learn-Fast Guide will prepare you for software delivered over the Web. From security issues to contract negotiations, there's a lot to consider ... and a lot to gain. Download this executive briefing  What It Takes to Become More Agile-- Demand Driven Retailing What It Takes to Become More Agile-- Demand Driven Retailing Download this on demand webcast now! Go to the webcast  Best Practices: Safe and Secure Hardware Asset Recovery Get this white paper now! (Source: Dell) Dell can help corporations to properly dispose of old PCs in a secure and cost-effective manner that is also environmentally friendly. Download this white paper  White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. The Importance of Application Management Dell Client Migration and Deployment Services A Synergistic Relationship: Marrying E Family Hardware and Windows Vista� View more whitepapers

• Virtually every Windows PC at risk, says Secunia
• Clues point to Jan. 13 release of Windows 7 beta
• License server glitch exposes SonicWall users to e-mail security threats
• More top stories