Build a data warehouse that meets your business user needs

Warehouse design is the first and most important step in the process of building a warehouse. Extensive care is needed in designing a warehouse. This template document is expected to be used as a check-list for future warehouse design activities in BI (business intelligence) team.

The document aims to capture the key business requirement and their forensic analysis in light of source data that is to be fed to the warehouse. It includes:

• Background & context
• Key business benefits
• Business process
• Identified relational reports
• Identified analytical reporting
• Key business rules
• Technical requirements
  • Technology requirement summary
• Operational requirements
  • Data Clean-up requirements
  • Archiving requirements
  • Installation and mapping requirements