Návrh a vizualizace klíčových ukazatelů výkonnosti pro obchodní oddělení

This diploma thesis deals with the design and the implementation of a solution for the analysis for the sales department in a smaller IT company. The main goal is to analyze the company and identify the key indicators to monitor. A reporting strategy was designed for the entire department. Based on the mapping of the main goals and strategy of the company, the most important key indicators for the sales department will be determined (more precisely for the Sales CRM and for Utilization). Selection of reports to implement follows according to data availability. A partial goal of this thesis is to design and visualize the company's key indicators for the sales department through Power BI tools. The whole project is taken as Proof of Concept or the initial proposal of what the final reporting could look like. The data was exported via the API and the Postman application, in which several tables in the form of JSON files were generated via a combination of tokens. These files were modified using the Power Query editor in Power BI and then used directly to create data model. The output of the diploma thesis will be the representation of identified indicators in the form of visualization in Power BI reporting tools such as Proof of Concept, and subsequent evaluation of data status and possibilities for automation.