Elements and Performance Criteria
- Confirm the database design
- Identify the required data and sources
- Identify the required data, with reference to the enterprise’s knowledge management strategy
- Identify subject areas, with reference to the business processes and the required data
- Explore operational data, define the warehouse sources and record the outcomes
- Develop the warehouse source specifications, with reference to the existing data tables and files
- Determine warehouse operational steps and processes
- Design and develop the warehouse features
- Design and develop the warehouse user interface, with reference to the principles of user interface design
- Develop and implement the warehouse security strategy, according to the enterprise’s security plan
- Identify dimension tables and fact tables, with reference to the required data
- Cost the technology requirements for the implementation of the warehouse security strategy, and include them in e-business budgeting
- Develop a warehouse information catalogue, with reference to the enterprise’s knowledge management strategy
- Test and implement the data warehouse
- Test the data warehouse against the business requirements, to ensure that iterations meet the business objectives
- Recommend changes to business processes, to ensure compatibility with the data warehouse and the knowledge management strategy
- Implement the data warehouse
- Establish an ongoing maintenance schedule in order to keep the system efficient
- Benchmark and document, the performance level of the data warehouse
- Finalise work processes