The bulleted items below summarize the five major steps in creating a data warehouse. Although every project possesses some distinctive characteristics, and we reflect those considerations in the project plan, our basic methodology remains consistent.
- Meet with client personnel to identify immediate and long–term data requirements.
- Produce a Requirements Specification for the client’s approval.
- Assemble a Design Specification, beginning with recommendations for the necessary hardware and Business Intelligence software. The Design Specification also includes a data model and mock–ups of the key user interface screens. Work with the client’s project team to refine the design for client approval.
- Develop, test, and document the software described in the Design Specification. Throughout this process, transfer knowledge about system support and long–term maintenance to the client’s IT staff.
- Prior to the production roll–out of the data warehouse, provide “train the trainer” instruction for end users of the system.
There is a range of other data warehouse concepts and methodologies including:<?p>
- Logical data model
- Conceptual data model
- Physical data model
- Star Schema
- Data mining
- Staging area
- Multi-dimensional analysis
- Snowflake schema
- OLAP tools