Business Problem: The Sales and Operations business users were unable to get an integrated view of their operations due to lack of consolidated data.
Our Solution: A Datawarehouse consolidating data across departments was proposed. The work involved the design, development and implementation of ETL for the Datawarehouse implementation . An understanding of the business work flow, the overall ETL – DW architecture and development of Dimensional load and Fact load jobs were key to the success.
Technology: Cognos Data Manager, Oracle 10g