Diseño de dashoard bi para una empresa camaronera

Abstract

CONDITION FOR PUBLICATION OF PROJECT. purpose of this project is to develop a business intelligence dashboard that allows for the visualization of key indicators in a shrimp farming company by integrating data obtained from IoT sensors and historical production records. The proposal is based on the hypothesis that centralizing and visualizing historical data optimizes operational and strategic analysis, justified by the need to overcome limitations caused by the dispersion of information across multiple sources. For its development, data were collected from SQL Server and MongoDB databases, interviews were conducted with key users, and data models were designed under a star schema architecture. Data processing and integration were carried out using Pentaho in the ETL stage, and visualizations were built in Power BI, applying usability principles and validation techniques with feedback from end users. The results showed functional dashboards with high ratings in terms of usefulness, clarity, and relevance It is concluded that the proposed solution contributes to optimizing operational and strategic decisions that are part of the production process. . Keywords: data visualization, IoT sensors, business intelligence, aquaculture, star schema.