Establishing banking data mart for evaluation of credit exposure

Main objective of thesis is the presentation of the evolution of the data mart in banking data warehouse of credit exposure. In the first part we focus on the basics of data warehouse, describe different approaches to building it and some differences between the warehouse and operational data base. We define architecture and highlight some trends of data warehousing. In the second section we focuse on the specifics of the banking data warehouse and exposure some disadvantages in the construction it. We describe and illustrate the case of implementation of credit exposure into data warehouse. We described a dimensional data model, ETL processes for loading data and producing reports to assist in decision-making and reporting. In thesis we present a tool for implementation of ETL processes IBM DataStage and tool for creating reports BusinessObject SAP BI. We conclude the work with the effects and results of the data mart construction in a banking data warehouse for credit exposure