Návrh a implementace BI řešení nad informačním systémem Helios Orange

This bachelor thesis deals with the analysis of the ERP system Helios Orange and the subsequent proposal of a Business Intelligence solution over the selected ERP system. The main goal of this work is to implement a BI solution using the Microsoft Power BI tool in a selected travel agency. We will get to the main goal through four sub-goals. The first partial goal is to analyze the ERP system Helios Orange and its use in the selected company. The second partial goal is to design a dimensional model for creating BI solutions. The third sub-goal is to transform the data from the ERP system in order to fulfill the newly created model. The last sub-goal is to visualize the outputs using the Power BI Desktop application. The set goals were achieved using several methods: guided interviews with stakeholders, searches of professional books and articles on the chosen topic, analysis of documentation of used software and own observations. The output of this work is a BI solution focused on sales of tours, products and services of a travel agency. Another output is recommendations for a selected company regarding the proper use of the Helios system and improving data quality for the subsequent development of Business Intelligence in other areas.