Analysis and design of a business intelligence solution for Dallmayr Vending & Office, k.s

In this bachelor's thesis, I will analyze and design a Business Intelligence solution for the company Dallmayr Vending & Office, k.s. The main goal of the work is to optimize routes for cost reduction and more efficient transportation. In the long term, this will lead to automation and modernization of the entire company. In the thesis, I will focus on the current state of use of Business Intelligence in Dallmayr Vending & Office, k.s., which is in the initial phase and still requires many manual or outsourced processes. Based on the analysis of available information, personal experience in practice and interviews with the company's management and employees, I have designed a solution that will enable more effective route planning, reduced operating costs and better utilization of the workforce. As part of the methodology, I used qualitative analytical approaches, specifically observation, semi-structured interviews with employees and management, process analysis and comparison with standard route optimization procedures in the field of logistics. I also used Business Intelligence principles, such as data warehouse design, ETL processes and dashboard visualization. Thanks to these tools, I identified the main problem areas and proposed recommendations for further steps. The output of the work is a general concept of a BI solution with some specific steps for its implementation. The benefit is a reduction in company costs and the time that carriers must spend on the road.