7. Support

7.1. Description

The seventh phase of the SQL Power Methodology consists of the post-production implementation activities. The main activity here is the monitoring of the production Business Intelligence system, including Data Auditing, Data Volume and Report Usage monitoring, as well as Data Load Logs (Journal) review. This phase also defines the Change Management processes that are required to incorporate any changes to the system.

7.2. Objectives

The objectives of this phase include:

• Ensure smooth running of the system
• Monitor system performance and take corrective action, as required
• Establish orderly process to enable seamless changes to the system

7.3. Inputs

The inputs for this phase include:

• Fully functional production system
• Data Load Logs
• Data Volumes reports
• Report Usage reports
• System documentation

7.4. Activities/Tasks

The activities of this phase include:

1. Monitor system operations and performance
2. Conduct data auditing
3. Support production system
4. Define and implement change management

7.5. Deliverables

The deliverables of this phase include:

• Fully functioning Production system
• Data Volumes and Report Usage reports
• System status reports
• Change Management process
• Implemented changes

The Support phase is the ongoing monitoring of the BI system. It is intended to ensure that the system is functioning as expected. The duration of this phase will be determined by the needs of the users for the system.