Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

Resource Portals
Analytic Applications
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
EDM
EII
ETL
More Portals...

Advertisement

Information Center
DM Review Home
Conference & Expo
Web Seminars & Archives
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Bookstore
Industry Events Calendar
Vendor Listings
White Paper Library
Glossary
Software Demo Lab
Monthly Product Guides
Buyer's Guide

General Resources
About Us
Press Releases
Awards
Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Ask the Experts Question and Answer

Ask the Expert

Meet the Experts
Ask a Question (Names of individuals and companies will not be used.)
Question Archive
Ask the Experts Home

Q:

Could you please give me an idea of the typical range on a per record basis for a deduplication (data cleansing) project?

A:

Sid Adelman?s Answer: There is no meaningful range. It will depend on:

  1. How many source files you are consolidating for the deduping.
  2. If data entry was careful and motivated to minimize duplicate names. It?s often easier for them to just enter a duplicate name than to identify and use a customer number that already exists.
  3. The editing in the entry system to spot and alert duplications

Chuck Kelley?s Answer: A typical range of what? Cost? Records Combined? Each project will be different. I have seen as much as 50:1 and as little as 1.1:1 in terms of combining records. There will need to be some analysis done on how bad the data is and how much is it worth to have a "perfectly" cleansed environment. You can do a 75 percent cleansing of name and address rather inexpensively. To do a "perfect" cleans can cost another 50 times as much. How much is it worth to your business?

(Posted )


ARCHIVE OF QUESTIONS & ANSWERS FOR DATA QUALITY
BACK TO THE LIST OF CATEGORIES



Advertisement
advertisement
Site Map Terms of Use Privacy Policy

Thomson Media

2005 The Thomson Corporation and DMReview.com. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.