The integration of MS Excel and BusinessObjects

The main goal of this work is to analyze the change in reporting mortgage processes in the GE Money Bank from the solution based on the application Microsoft Excel into a state, where the mortgage reporting is integrated into the solution based on BusinessObjects platform. And at the same time to carry out the comparison of new and previous solution. To partial purposes belongs the quantification of time savings and benefits resulting from the integration and adumbration of the next integration step "Generation 2". These aims were achieved by obtaining theoretic knowledge of Business Intelligence, by my participation in the real project practically and by consultations of knowledge with specialists in practice. Main contribution of this work is in suggestion and analysis of the reporting solution in the firm. It enables speed up and automatizes processes of data measure, which were ineffective and time-consuming capacities of workers. The work is divided into the four main chapters. The teoretic forepart introduces the role of Business Intelligence in a firm and acquaints readers with contemporary trends in BI. The second part has practical background. The Business Intelligence architecture in GE Money Bank is analyzed in this part. Awareness of BI architecture and data sources is important due to understanding connection of the BusinessObjects with the database. In the third part the project "Integration of mortgage measure from MS Excel to the BusinessObjects" is introduced and it is also suggested, how the integration would be proceed. At last part my personal findings are summarized, benefits of integration are formulated and future view is described. Last but not least an advice resulting from the project is showed or what would be possible to do better next time.