Transformace katalogu integračních služeb do Power BI aplikace

This thesis focuses on replacing the web-based catalogue solution in the integration department of an unnamed bank. The primary goal is to design and implement a demo version of a comprehensive solution for automating and visualizing integration data. The aim of this solution is to simplify data management and increase its timeliness and accuracy, which will lead to improved decision-making processes within the organization. Initially, an analysis of the current state is conducted, and issues with the existing catalogue solution are identified. Subsequently, the thesis focuses on designing a new solution that includes data architecture, data model, and visualization, along with the requirements for the final application. The main technical component of the solution is a Python script that facilitates data extraction from GIT using REST API. This data is then transformed and stored in an SQLite database. Power BI subsequently uses the data along with existing database information to create a clear catalogue visualization. An advantage of this solution is the ability to replace some components with others, ensuring flexibility and adaptability for future changes. The solution was validated through expert interviews, which provided valuable insights into its practical application. Since it is a demo version, the thesis also discusses potential future developments. The thesis concludes by evaluating the achievement of objectives and the benefits of the proposed solution.