Aplicação de business intelligence para tomada de decisão no processo de gestão no setor de facilities em um centro de distribuição

Abstract

Decision-making is an extremely important activity that affects all management processes. Currently, several studies comment on the importance of using business intelligence to support decision-making processes, as a decisive factor for companies to remain competitive in the contexts of rapid change. This work aims to apply business intelligence tools to assist in decision-making of management process in the facilities sector in the distribution center of a food manufacturer. The software tool Microsoft Power BI Desktop was used, assisted by Excel and OneDrive for data transformation and storage. Data was collected from contracts, from the SAP database, dashboards, as well as application reports and data sheets. Documents, service level agreements, and results for the year 2021 were explored for restaurant, laundry and linen, cleaning and gardening, and property security services, to define information and performance indicators that should be used. Three steps were used to create the dashboard, which comprised Extract, Transform, Load (ETL) techniques, enabling the construction of Data Marts (DM) to constitute the Data Warehouse (DW). In this way, it was possible to establish relationships in Microsoft Power BI, create graphical interfaces and visualizations, and define data segmentation restrictions. After the elaboration of the tool, a brief interview was carried out with a professional in the area to present the proposed dashboard. It was found that, even in environments where decision support tools are already in place, there are still opportunities for improvement and that the contributions given by the manager raised even more relevant points, resulting in changes to the presented dashboard. The results obtained enabled positive changes in the management of services, making the decision-making process faster and more effective. In most of the questions, the interviewee was satisfied with the proposed dashboard, as well as with the information layout presented in the interface. The interviewee affirmed that the proposed dashboard can be extended to other units of the company.