Vytvoření BI procesu dávky pro sdružení SOLUS v retailové bance

The thesis focuses on the batch processing of bank (retail bank) client data for SOLUS. The main goal of the thesis is to create a batch process that will generate files (monthly report) about clients of one of the bank companies operating in the Czech market (retail banks), according to requirements pre-defined by SOLUS. This will be achieved by analyzing the requirements, designing the pilot solution, and by creating and implementing the batch process for SOLUS. The main contribution of this thesis is a working BI process which will store the data in the required format to the data warehouse. By implementing this process the retail bank can use the data from the register that have been saved to this place by other member organizations which participate in creating SOLUS. The data analysis from the registry can help the retail banks to get detailed information about clients applying for products of the respective bank and will facilitate the decision making during the approval process. The solution of batch report generation for SOLUS has been created by using the tools MS SQL Server 2008 R2 Management Studio, MS SQL Server 2008 R2 Business Intelligence Development Studio, and MS Excel 2010. In this project the data from internal databases of retail bank are analyzed. In order to comply with the rules for information security and data sensitivity, it is not possible to use a large amount of information from internal databases for the purposes of this thesis, but it is possible to clearly demonstrate the functioning of the whole process.