Q: Is there a more defined practical methodology (e.g., a step by step checklist) that is helpful in implementing a corporate data warehouse?

Sid Adelman's Answer:

Take a look at BI Roadmap by Larissa Moss and Shaku Atre.

Joe Oates' Answer:

There are several books that attempt to cover a methodology for building data warehouses and data marts for those who have never had experience implementing either a data warehouse or a data mart. I can recommend two. The first one is The Data Warehouse Lifecycle Toolkit by Ralph Kimball et al. It provides a basic course in the various aspects of building a data warehouse or data mart. It provides examples of multidimensional design and touches on ETL. It does have a reasonable project plan on the CD that accompanies the book. In addition to this book, I would recommend The Data Warehouse ETL Toolkit also by Kimball and Data Warehouse Project Management by Sid Adelman and Larissa T. Moss.

While these publications do a very good job of covering basic concepts, they are no substitute for successful experience in implementing the various aspects of a corporate data warehouse.

Anne Marie Smith's Answer:

There are five main stages to a data warehouse development: strategy, design, build, deploy and sustain.Within each stage there are activities and each activity has one or more steps. It would require several articles to give details on the contents of a complete data warehouse methodology, but there are several good books on data warehouse development available.I recommend Data Warehouse Project Management by Sid Adelman (the moderator of this panel) and Building the Data Warehouse by William Inmon, the "father of data warehousing."Each organization that builds successful data warehouses should have a methodology that is comprehensive, tailored for their needs but conforming to the best practices that have emerged over the 20+ years of data warehouse development.For example, EWSolutions has a methodology called I3 that includes over 150 separate items covering all the stages of a data warehouse lifecycle.For more info on EWSolutions' I3 methodology, please visit: http://www.ewsolutions.com/solutions/methodologies2/I3-data-warehousing

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