Herramienta de business intelligence para la mejora de la gestión en la empresa bananera Indagropec C.A.

Abstract

One of the most important assets of the company is the management of information, this has led to the proliferation and use of software and data warehouses. In Ecuador, the management of banana producing companies is carried out through empirical methods that have generated important results; however, when important changes in the market are identified, the application of tools that allow processing the data to convert it into information that allows decision-making, for which purpose it is proposed to apply Business Intelligence as a management tool for decision-making at the hierarchical levels of the banana company INDAGROPEC CA, after which surveys were applied in order to establish productivity indicators in the departments of production, cost accounting and human talent, in order to develop a dashboard or dashboard that allows a visual understanding of the behavior of data in the company. The prototype generated four tabs that summarize the indicators of each department, allowing managers to observe through graphics (tachometers) the behavior of production, thus applying business intelligence to the processes of the company. In order to collect the data, interviews were carried out with departmental heads and observations on the decision-making process. We analyzed the results obtained after applying the business intelligence solution of the production, cost accounting and human talent departments, having reduced the response times in the analysis of the information by more than 70% and the reports prepared are of the satisfaction of the user's needs, allowing a fluid and simple management.The results obtained from each department for the year 2018 were the following: Production The productive performance of the company is 1593 cajas.ha-1.años-1 that allows us to know the productivity of the company, where we obtained through the relationship cluster- box a conversion of 0.90 ie, for each cluster that gives a banana plant 0.90 boxes are produced, another indicator is the recovery of the fruit in the harvest of 93%, another department is the Accountant, where the following are denoted results, the point of equilibrium of the company was 614 boxes of banana this means, that you must produce that amount of boxes to cover production costs, plus a benefit / cost ratio of 1.73 was obtained. , for each dollar invested, a profit of 0.73 cents will be obtained, and finally as part of the Human Talent department, it has been pointed out that the retention indicator for human talent amounts to 99.69%, also mentioning that the 90% of the personnel was trained, this way, they have been fulfilled based on the programmed. It has been demonstrated that the technique that uses the QlikView 10.0 program is viable, it would be possible to improve the decision-making process in the company INDAGROPEC C.A. The model has a high capacity to generate graphs and generate information, however, it is necessary to continue working to evaluate the reliability of the system.