I am looking for typical data warehouse project phases and the percentage of duration for each phase. Are there any resources or Web sites that collect this type of data?


Chuck Kelley’s Answer: I do not know of any good Web sites for this, but there is an excellent book on this topic by Richard Kachur. The title is the Data Warehouse Management Handbook published by Prentice-Hall. Richard also writes a monthly column for DMReview.com titled The Data Warehouse Diary which also discusses the different phases of building a data warehouse.

Sid Adelman’s Answer: The percentage of effort for each phase will depend on the characteristics of the system, the architecture, the design, the strategy, the infrastructure, the skills of your people and what has to be accomplished in each phase. For example, if the source data is well understood (it rarely is), and the transformation rules are simple, (they usually are not), and your data is pristine (it never is), the ETL phase may not be the majority of the effort (that’s usually the case). After you develop a project plan with times and durations, you will have your answer. Don’t let any "average duration" dictate how much time you allocate to spend in each phase. Each project and each situation is different.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access