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