Do you have a standard template for gathering business requirements for enterprise data requirements project?


Sid Adelman's Answer: The Business Intelligence Roadmap by Larissa T. Moss and Shaku Atre, Chapter 4, discusses gathering business requirements and The Data Warehouse Lifecycle Toolkit by Ralph Kimball, Laura Reeves, Margy Ross and Warren Thornthwaite has a great chapter by Margy Ross on the same topic.

Steve Hoberman's Answer: There are three templates I populate often when building a new system. The Family Tree documents a data elements lineage, the Grain Matrix is used exclusively for reporting and captures the levels of detail each fact should be viewed and the Data Quality Validation Template helps me analyze how the actual data compares to the meta data. These three work nicely together. I apologize for plugging my book, Web site and courses, ... but ... you can download these spreadsheets free from my Web site, http://www.stevehoberman.com/. You can also read Chapter 7 in my book, The Data Modeler's Workbench which describes these in detail or take any of my training courses which focuses on logical data analysis. Good luck!

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