Cleansing and Migrating Data

By Regina Kwon  |  Posted 2002-05-01 Email Print this article Print
 
 
 
 
 
 
 

If the data isn't clean, it's no good. Use our tools to determine the total costs of cleansing multiple databases and migrating the information to a data warehouse

PDF Download This chart and timeline show the total costs of cleansing multiple databases and migrating the information to a data warehouse. The example is based on a manufacturer that is reengineering its business processes and must upgrade almost all of its systems.

Baseline's hypothetical firm has $550 million in annual revenue, 3,000 employees and 2.25 million records. The company has divided its project into three rounds that target six databases each. Tasks include assessing data for cleanliness and completeness; mapping fields to the target warehouse; and both programmatic and manual data manipulation. Project planners may regard these tasks and costs as representative of projects of this size and scope, but should tailor assumptions to meet their own requirements.

Click here to download the Microsoft Project 98 file.

Click here to download the Microsoft Excel 2000 file.

 
 
 
 
As Statistics Editor of Baseline magazine, Regina creates interactive tools, worksheets and project guides for technology managers. Before joining Ziff Davis, she worked as a technical program manager for a database company, where her projects included data management applications in XML, Java, Visual Basic and ASP. Her other experience includes running the new media department at Christie's Inc. and writing and editing for Internet World and PC Magazine. Regina received a B.A. from Yale.
 
 
 
 
 
Manage your Newsletters: Login   Register My Newsletters