Rozšíření Self-Service Business Intelligence nástroje o nová data

This thesis examines the benefits of Self-Service Business Intelligence for companies. The main goal of the thesis is to create a temporary solution (prototype) at the Proof of Concept level, which demonstrates the possibility of transferring data from databases of customer-used applications to an internal Self-Service Business Intelligence tool. The company for which the solution is created operates in the logistics market worldwide. This company offers several applications/integrations that customers use to order shipping and parcel collection. These applications have their own databases and IT support teams that take care of the administration and handle incoming tickets. The applications exist separately and operate independently of each other. Business staff and management felt the need to augment the internal Self-Service Business Intelligence tool with customer registration data, which previously had to be extracted from databases with the help of IT support teams, which was not time efficient and was adding a lot of work and tickets. The project documented in this thesis solved the missing data problem for 5 applications/integrations. The main part of the solution was the creation of ETLs in Python that transform and load the data using SQL into one common database, from where it is transferred to the SSBI tool. The work starts with an introduction to the topic of the project (the benefits of BI and SSBI), an introduction to the company and an outline of the problem to be solved, followed by the design and creation of the solution. The last chapter is devoted to the validation of the solution.