Inteligência comercial no agronegócio: desenvolvimento e automação de base de dados para prospecção de clientes

Abstract

The objective of this technical report was to present the process of creating a database of potential clients for the agribusiness industry, detailing how the CNPJ database was built and maintained, and how this data is used to support strategic decision-making in the agricultural sector. The identified problem was the lack of an organized data structure on sales channels, which limited the consultancy’s analytical capacity and required the use of manual spreadsheets and outdated information. As a solution, the construction of a segmented and updatable database was implemented, using programming languages, API integration, automations via Power Query, and visualizations in Power BI. Among the main results achieved are data standardization, the creation of strategic dashboards, the geographic mapping of 11,500 branches belonging to 5,931 companies, the improvement of internal decision-making capacity, and the development of a marketable product for the consultancy’s clients. With the automation of the process, the database update time — which previously could take weeks due to manual processing and segmentation — was reduced to just two hours, demonstrating a significant gain in operational efficiency.