4. Build

4.1. Description

The fourth phase of the SQL Power Methodology develops the intended Business Intelligence solution. During this phase the physical database and the ETL code are developed and unit tested. Data migration and conversion plans are developed. User Acceptance testing is planned in this phase. In cases where a reporting prototype was created, it can be reviewed and refined based on user feedback.

4.2. Objectives

The objectives of this phase include:

• Develop physical database
• Develop ETL applications
• Unit test ETL processes
• Develop and review BI prototype
• Plan data migration and conversion to production

4.3. Inputs

The inputs for this phase include:

• Project Charter
• Logical and physical data models for:
  • Data Audit Repository
  • Metadata Repository
• Design Document of the ETL/Interface Application design, including:
  • Source-To-Target mappings
  • ETL Modules/Procedures design
  • ETL Process Dependencies and Schedule design
• Test Plan
• Required resources

4.4. Activities/Tasks

The activities of this phase include:

1. Review Design Documents
2. Create Physical Database
3. Develop ETL module
4. Conduct code reviews
5. Develop Production Migration Plan
6. Develop User Acceptance Plan

4.5. Deliverables

The deliverables of this phase include:

• DDL Scripts for Physical Database Implementation
• Constructed and unit tested ETL modules
• Constructed and unit tested BI Reports
• Constructed and unit tested ETL load scheduling procedures
• User Acceptance Test pan

The Build phase will build the BI solution and will prepare it for the User Acceptance testing.