Business RequirementsBelow are different phases categorized by how they will be executed. Detailed activities for each phase are listed in the “Execution Approach” section of this document. Phase 1 - Business analysis and design Phase 2 - Installation of Informatica/Business Objects Phase 3 - Development and ETL (Extract, Transform, Load) testing Phase 4 - Development of the reporting universe and development of reports Phase 5 - Support for implementation and user trainingPhase 6 – Implementation and production support Project Deliverables• Loading historical data and mapping data from current systems to the new data warehouse. A standard mapping scheme that will be the 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 schema if connectivity to the source data cannot be achieved using Informatica. • Historical data mapping will only be performed for as much data as is available and may not cover all historical data. data requirements in some cases.• Report specifications document and code for reports• Design document and code for web portal• Document showing entities/relationships in data stores.• Document showing the Business universe Objects.• The Business Objects universe.• Technical design document for ETL and reporting.EXECUTION APPROACHPhase 1 – Business Analysis and DesignWork with users from different business units to clearly identify business requirements and design the solution.• Analysis and design historical data load from various sources within all business units.• Website design a portal based advertising portal to link different reporting areas to the data warehouse; this portal will also have the ability to connect to external databases ...... middle of paper ...... e with advanced parallel processing of all data warehousing operations http://www. oracle.com/services/index.htmlBusiness Objects XIThe first and only business intelligence (BI) suite to offer a comprehensive set of BI capabilities: superior reporting, querying and analytics, enterprise performance management (EPM), and information management (EIM). BusinessObjects -them.• Query and analysis: Self-service analysis for users. .• BI Platform - Manage BI tools, reports and applications.• Data Integration - Access, transform and integrate data.http://www.businessobjects.com/products/businessobjectsxi/default.asp?intcmp=hp_products2