Cleansing and Migrating Data

By Regina Kwon  |  Posted 2002-05-01 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.

Submit a Comment

Loading Comments...
eWeek eWeek

Have the latest technology news and resources emailed to you everyday.

By submitting your information, you agree that baselinemag.com may send you Baselinemag offers via email, phone and text message, as well as email offers about other products and services that Baselinemag believes may be of interest to you. Baselinemag will process your information in accordance with the Quinstreet Privacy Policy.

Click for a full list of Newsletterssubmit