A contribuição do business intelligence na tomada de decisão nas micro e pequenas empresas

Abstract

The main motivation for this work was the lack of adequate data analysis to optimize the strategic management of a small industry in the municipality of Crateús, Ceará. The current data analysis model for decision-making in the organization relies on Microsoft Excel spreadsheets and non-integrated systems, which leads to inadequate data analysis, resulting in lengthy and time-consuming processes for managers, in addition to the use of paper as a tool for transmitting information. Data analysis through a dashboard built in Power BI, using the organization's data, provided insights into the contributions of Business Intelligence (BI) to decision-making in the company. Therefore, to achieve the objective of this research, it was necessary to diagnose Knowledge Management (KM) in the company, develop a dashboard in Power BI using Excel spreadsheet data employed in decision-making, and identify the benefits of using dashboards created in Power BI compared to previous data analysis methods during the decision-making process. Hence, the research conducted was applied in nature, with a qualitative approach and descriptive character, using the action-research method, presenting an overview of the contribution of BI to decision-making in Micro and Small Enterprises (MSEs). Thus, it was found that the use of Power BI as a solution to the problem presented in this research was effective, as it brought a new perspective on data analysis for the organization's managers, reducing analysis time, speeding up decision-making, and facilitating data visualization. Furthermore, through the KM diagnosis, it was identified that the organization needs a better analysis of its KM practices to restructure existing practices and enhance knowledge within the organization.