Ask the Experts Question and Answer
Meet the Experts
Ask a Question
(Names of individuals and companies will not be used.)
Ask the Experts Home
(Posted January 1, 2000)
We have our first data warehouse committee (seven people). Our task is to submit a recommendation to set a data warehouse/mart infrastructure in place and present it to our budget committee. We're having a tough time trying to justify the startup cost (for migration, transformation, administration tools, reporting technologies and OLAP tools). We have a list of the "benefits" in terms of soft dollars, but our recommendation will only be to set the infrastructure in place, not to build one as part of our assignment. Can someone help? We're not willing to let some of the tools go - our data is really dirty.
Sid Adelman's Answer: The problem with just implementing the infrastructure and not actually delivering anything to the users is that there are no tangible benefits you can point to, none at least that contribute to the bottom line. Your project is exposed. You need to identify a real application, ask for more money, more resources and more time and then build something that's useful.
Regarding dirty data - you should not give the users a data warehouse with dirty data. It has to be cleaned. Would it be possible to select an application that has reasonably clean source data and make that your first project?
ARCHIVE OF QUESTIONS & ANSWERS FOR DATA QUALITY
BACK TO THE LIST OF CATEGORIES