Test and Revise
Testing is a critical part of data warehouse and business intelligence development. While unit testing occurs continuously during the Design and Build stages, allowing for a continuous feedback loop., it is in this distinct Testing and revision phase that all aspects of the data and BI solutions receive final close scrutiny and inspection. Testers work with the core project team to review business requirements and test cases defined throughout the development process and validate that they are met in the final product.
User acceptance testing is when clients and stakeholders take a final walkthrough before providing sign-off. The main objectives of UAT are to find anything not working as expected and demonstrate how to use the solutions for their data and information needs. At the end of this phase, the solutions are production ready.
As issues are discovered, the core project team works to revise the solutions as needed. In some cases, remediation may not be possible before deployment; in this case, the remaining issues are prioritized for future releases.
Project activities
- Test plan execution (functional, security, performance, accessibility, mobile)
- Final user acceptance testing
- Revision and retesting for prioritized issues
- Prioritization and planning for deferred issues
Deliverables and outcomes
- Client sign-off
- Solutions approved for deployment
- Test reports
- Logged issues/future enhancements list