Implantação de uma ferramenta de business intelligence em um software de gestão de propriedades rurais

Abstract

Brazilian agribusiness has a strong influence on the Brazilian economy. From this, it is possible to evidence growth and specialization in agricultural production in the country, both in the productive part itself, as well as in the management of properties by rural producers. The use and application of new technologies, such as business intelligence (BI), has contributed to the decision-making process, aiming at reducing costs and the search for efficient management, similar to that applied in companies from other sectors. The BI process is based on transforming data into information, then into decisions and finally into actions, which give organizations differentiated competitive advantages. Given the above scenario, the objective of this work was to carry out the development and implementation of a business intelligence tool, integrated with a rural property management software, in order to subsidize the visualization and interpretation of data for decision making of the farmers. This work was carried out within the scope of a company that offers information management services for rural properties, called Agrogerencial Assessoria e Consultoria Econômica Ltda. The company is headquartered in the city of Santa Maria - RS and has been on the market for approximately two years. Microsoft's Power BI tool was implemented, connected to the management system database used by the company. Based on this connection, thirteen indicators were developed, divided into three categories (i) financial indicators, (ii) stock indicators and (iii) fiscal/tax indicators, inserted in a results panel. Each indicator sought to demonstrate relevant information, with the aim of supporting decision-making by rural producers. At the end of the work, it was possible to verify the efficiency of the tool and the ease of decision making by rural producers using the developed solution. In addition, this work demonstrated to the company the possibility of offering an extra technological resource to its customers, as a differential in the face of the competitive market.