Analýza a návrh SSBI aplikace pro podporu plánování výroby a prodeje polyolefinů

The goal of this thesis is to create a Self Service Business Intelligence application to improve the efficiency of prediction for demand planning and calculation of the planned polyolefins selling prices using Power BI. The first part describes the business context, including the production and trading model used by ORLEN Unipetrol, with special emphasis on the polyolefins planning process and the characteristics of the main sales efficiency indicators. Next, in the practical part, the autor focuses on the analysis itself and on preparing the design of the SSBI application, on the basis of the described requirements from the Sales Department. The result of the work is a prototype of the SSBI, enabling monitoring of the correctness, precision and relevance of the requirements entered by the sales representatives and comparing them to the actual offtake by individual clients, which enables ongoing monitoring of the planning precision. The thesis also includes the evaluation of the current algorithm for planning of the polyolefins selling prices.