Sometimes you have to say "What the Heck"? Paraphrased from the movie Risky Business.
Risk is inherent in everything we do. Whether you invested heavily in technology stocks right before the market crash of 2000, drive down the road in your car, fly over 100,000 miles on your favorite airline each year, or build a data warehouse, you need to have a plan of attack for things that will go wrong.
Project manager for a data warehouse project is a highly risky job description. Very early, in my building of data warehouses, I used to say that the old skills of project management didn't apply to the data warehouse. It wasn't until I ran across an excellent project manager by the name of Scott Barker that I learned I was not quite accurate in my statement. He once said to me that if there is not a plan in place, there is a disaster waiting to happen (I paraphrase, but the gist is accurate). He forced me to think about the whole process and not to allow the whole project to just run willy-nilly. Having my eyes opened for the first time has helped me become a better project manager/consultant.
From my last tip, you know that there are many reasons that your data warehouse can be less than successful. However, a good project manager can help alleviate the risks associated with the data warehouse and thereby help the success of the data warehouse to be higher than expected. Some of those risks (and this is not an exhaustive list!) are:
The excellent project manager will create a risk assessment for all of the risks that are defined for the data warehouse. The risk assessment will be a table that will have at least 4 columns (though I have seen more before)
[TABLE]The first column defines the nature of the risk of all of the possible risks that might occur within the project. The second column defines the probability that
To continue reading for free, register below or login
To read more you must become a member of SearchSQLServer.com
this risk is going to occur. The third column defines the impact on the project if the risk were to occur. And the fourth column is a textual commentary of what some of the impacts might be if this risk were to occur. This risk assessment should be looked at weekly (or at least every other week) to help predict a risk and define a solution before it can cause big problems.
Sid Adelman and Larissa Moss have published a book titled Data Warehouse Project Management, Addison Wesley, 2000, which talks about (among other things) evaluating risk. I highly recommend this book -- if you have not added this one to your library, then now is a good time to do so.
The Return on Investment (ROI) for an excellent project manager is priceless. Like the MasterCard ad says (at least in my dreams), "Good ETL tool - $100,000; strong corporate sponsor - $500,000; excellent project manager - priceless?" (OK, you caught me. I say that about having metadata too!). Having an implementation plan and a skilled project manager will alleviate many of the risks associated with data warehousing.
About the author:
Chuck Kelley is president and founder of Excellence In Data, Inc. and an internationally known expert in database technology. He has more than 20 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 35 data warehouses and data marts. He also teaches seminars, co-authored a book with W. H. Inmon on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. Please feel free to email him at chuckkelley@usa.net with comments (negative or positive) about this column or ideas for future columns.
For more information:
