Business Requirements

Business Requirements - Business Requirements Listed below...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Business Requirements Listed below are different phases ordered by how they will be executed. Detail activities within each phase are listed in "Execution Approach" section of this document. Phase 1 - Business Analysis and Design Phase 2 – Informatica/Business Objects Installation Phase 3 – ETL (Extract, Transform, Load) Development and testing Phase 4 – Development of reporting universe and reports development Phase 5 – Implementation support and user training Phase 6 – Production Implementation and Support Project Deliverables • Historical data load and data mapping from current systems to new data warehouse. A standard mapping scheme that will be same for all business units will be created. Once approved, each department is required to provide all data from all business units in this standard scheme if connectivity to the source data cannot be achieved using Informatica. • Historical data mapping will only be done for as much data as available and may not all historical data requirement in some cases. • Report specifications document and code for reports • Design document and code for web based portal • Document showing Entity/ Relationships in data marts. • Document showing Business Objects Universe. • Business Objects Universe.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
• Technical Design Document for ETL and Reporting. EXECUTION APPROACH Phase 1 – Business Analysis and Design Work with users from the various business units to clearly identify business requirements and design the solution. • Analysis and design of the historical data load from various sources within all business units. • Design of web based Advertising Portal to link different reporting areas to the data warehouse; this portal will also have ability to connect to external data sources using FTP to download data (CMR). • Design for the data warehouse target data marts. • Creation of detailed design document covering above for signoff. Phase 2 – Software Installation During this phase installation of Oracle, Business Objects and Informatica on test and production servers will be done. This activity will also include configuring reporting environment and creating user groups. We will also install client software on development workstations and validate connectivity. Phase 3 – ETL Development and testing Develop code and perform testing for • Historical data load • Incremental ETL
Background image of page 2
The development of the ETL will be done based on the Data Warehouse target marts designed during Phase I. The Data Warehouse target data mart will be same for departments. The target
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2011 for the course BUS 362 taught by Professor Smith during the Spring '11 term at ASU.

Page1 / 9

Business Requirements - Business Requirements Listed below...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online