|
|
Cleansing and Migrating Data
By Regina Kwon
2002-05-01
Article Views: 275
Article Rating: / 0
| Rate This Article: |
|
| Add This Article To: |
|
|
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
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.
|
|
 |
|
|
| FEATURED VIDEOS |
The Nick for NAC
eWEEK Channel Insider Technology Editor Frank Ohlhorst explains how VARs are about to get lucky. NAC is evolving, and it is evolving in such a way that hardware constraints are quickly being eliminated and NAC bundled with other security solutions is becoming a major opportunity, that should become a lot easier to sell and support.
Will Recession Hit the Channel?
Fears of a possible recession have VARs and solution providers taking steps to prepare their customers.
|
|
Sponsored by
 | |
|
| DOWNLOADABLE ROI CALCULATORS & TOOLS FROM BASELINE |
Calculate Cost and ROI of Spam, VOIP, RFID, Sarbanes-Oxley and more...
Featured Calculators:
See More Tools!
By Category| Planners |Calculators | Quizzes
|
| | |
|
|
Projects: Networks/Storage 
