Elements and Performance Criteria
- Identify required data and sources
- Identify required organisational data according to enterprise knowledge management strategy
- Identify subject areas according to business processes and required enterprise data
- Explore the operational data and define warehouse sources and record outcomes
- Develop warehouse source specifications according to existing data tables and files
- Determine warehouse operational steps and processes
- Design and develop warehouse features
- Design and develop warehouse user interface according to principles of user interface design
- Develop and implement warehouse security strategy according to enterprise security plan
- Identify dimension tables and fact tables according to required enterprise data
- 3.4 Develop warehouse information catalogue according to the enterprise's 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 an ongoing maintenance schedule to keep the system efficient
- Benchmark and document the performance level of the data warehouse
- Arrange for users to have ongoing training in the data warehouse
- Validate results
- Obtain sign-off of the data warehouse