Data Warehouse For The State Of Rondônia Milk Production Chain: Construction Of Algorithms For Data Extraction, Transformation And Loading

The dairy production chain plays a strategic role in global agribusiness. In Brazil, it plays a prominent role, being one of the most important for the national economy. Brazil has been standing out as one of the world's largest milk producers, being the largest milk producer in South America and the fifth largest producer in the world, according to 2023 production. This study presents the creation of a Data Warehouse to analyze the milk production chain in the State of Rondônia, located in the Brazilian Amazon region. The methodology used was Design Science Research, which focuses on building a technological artifact to solve the problem of falling production. The data was extracted from several official sources from Brazilian agencies. The Extraction, Transformation and Loading process was carried out using the Python programming language, the database used was MySQL and the data visualization was implemented with the Metabase tool. The Data Warehouse allowed the integration and analysis of data on production, value, herd, pasture area and vaccination, provided through dashboards created with Metabase, enabling the dynamic and interactive visualization of regional scenarios. The results contribute to the understanding of the factors that influence milk production in Rondônia and can help in the formulation of public policies and strategies for the sustainable development of the production chain