5. Test

5.1. Description

The fifth phase of the SQL Power Methodology tests the developed Business Intelligence solution. During this phase the ETL code is tested for performance. The whole system is tested for integration and data flow. Users test the system for acceptance based on the User Acceptance Test Plan developed in the previous phase. System administrators may be required to maintain the system. Users are trained in the use of the new system.

5.2. Objectives

The objectives of this phase include:

• Verify that the BI solution functions as expected
• Conduct Integration (System) Testing
• Conduct Performance Testing
• Conduct Regression Testing
• Perform User Acceptance Testing
• Obtain user approval
• Train administrators
• Train users

5.3. Inputs

The inputs for this phase include:

• Project Charter
• Business Requirements
• Design Document
• Developed system
• System Integration Test Plan
• User Acceptance Test Plan
• Required resources

5.4. Activities/Tasks

The activities of this phase include:

1. Review results of unit testing
2. Conduct System Integration Testing
3. Conduct Performance Tests
4. Train Users
5. Train Administrators
6. Conduct User Acceptance Testing

5.5. Deliverables

The deliverables of this phase include:

• Test Results of:
  • Integration Testing
  • Performance Testing
  • Regression Testing
• Tested ETL programs & ETL application
• Test results & recommendations
• User Acceptance Approval
• Trained Administrators
• Trained Users

The Test phase will confirm that the developed BI solution conforms to the specified business requirements and will prepare the system for migration to production environment.