Uso e potencialidades de ferramentas de business intelligence na gestão de micro e pequenas empresas do setor de pescados

Abstract

The opening of small businesses has been growing in recent years and to be successful in the current market, companies need to increase the use of external information and also internal information, technology and process optimization to remain competitive. Managing a company in the fish sector involves handling a variety of complex and dynamic information. Given this scenario, technology-driven management tools, known as Business Intelligence (BI), were developed with the aim of providing a systemic view of the business, assisting in the collection, analysis and distribution of data, transforming large volumes of information into valuable insights. and quality for strategic decision-making. The use of BI allows companies in the fish sector to optimize their operations, improve efficiency and quickly adapt to market changes, ensuring more effective and competitive management. The present work proposes a model for data management of micro and small companies in the fish sector and analyzes the data collected from micro companies in the fish sector applying Business Intelligence techniques, in order to extract knowledge capable of assisting in the management of organizations. This work began with the collection of data relating to the sale and stock of two fish trading companies in Ceará. The method used to carry out the Extract, Transform, and Load (ETL) process was developed in Python language, using the pandas and numpy libraries, the data was stored in the BigQuery database and based on the Key Performance Indicator (KPIs) developed, the dashboards were built using the Looker Studio data visualization tool, making it possible to explore and present the data. The results obtained demonstrate that the methodology adopted was effective in supporting the extraction of useful information, in the form of panels and graphs, as well as in the discovery of knowledge capable of supporting the decision-making process, contributing to the management of organizations.