Reporting pro klientské centrum banky

This diploma thesis deals with reporting and its creation focused on the bank's client center department using the Microsoft SQL Server Reporting Services and Microsoft Power BI. The aim of the work is to create comprehensive reporting for the bank's client center, which will provide managers with the necessary information to make key decisions and quality department management. In the introductory part, the work focuses on defining the concept of Business Intelligence and the inclusion of reporting, its purpose and benefits within the company. Furthermore, the tools that are used in companies to create reporting and individual data layers that occur in obtaining quality and comprehensive data in companies. In the following part, the diploma thesis focuses on acquainting the reader with the activities and scope of work of the bank's client center and the current state of reporting. The second half of the work then focuses more practically, when the current situation is analyzed and shortcomings are identified. On the basis of which a proposal for the structure and model of the datamart will be created, which will be created for the new reporting of the client center and then implemented. Basic reports will then be created on top of this datamart, enabling monitoring of key indicators and which will help the clients of the client center to manage its quality. The main benefit of the work is the work with business requirements and their conversion to functional and helpful reporting in the department, which is focused mainly on working with external clients.