A Big Data Analytics Framework with Interactive Dashboards for Decision-Support in Ecuador’s Agricultural Sector
Digital · 02.07.2026 · 6 (3) · 55
DOI: 10.3390/digital6030055 ↗Kurz gefasst
Fachartikel in der Zeitschrift Digital, online erschienen am 02.07.2026. Verfasst von Ashley Aguilar-Serrano und 3 weiteren Autor:innen. Die Arbeit nennt 37 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Ecuador’s agricultural sector plays a strategic role in the national economy; however, agricultural data remains fragmented across heterogeneous and isolated sources, limiting integrated analysis and evidence-based decision-making. This study proposes and implements a Big Data analytics framework based on the Medallion architecture and interactive dashboards to integrate, process, and visualize agricultural indicators from INEC, ESPAC, Ecuador Open Data, and FAOSTAT for the 2010–2024 period. The proposed framework adopts the Team Data Science Process (TDSP) methodology and structures workflows into Bronze, Silver, and Gold layers using Databricks for scalable data ingestion, transformation, and dimensional modeling. Interactive dashboards were developed in Tableau Public to support dynamic analysis of agricultural production, trade, producer prices, losses, and producer profiles. A comparative performance evaluation between Databricks Free Edition and Azure Databricks was conducted using SQL analytical workloads and dashboard interaction tests. Results showed that Azure Databricks reduced query execution times by up to 57%, especially in aggregation and join operations. Usability validation with 31 agricultural stakeholders reported high acceptance levels, including a 100% recommendation rate and a data trust score of 4.45/5. The findings demonstrate that scalable and low-cost Big Data technologies can effectively support agricultural digital transformation.
Zitieren
APA
Aguilar-Serrano, A., Ávila-Villaprado, J., Pinta, M., & Mazon-Olivo, B. (2026). A Big Data Analytics Framework with Interactive Dashboards for Decision-Support in Ecuador’s Agricultural Sector. Digital, 6(3), 55. https://doi.org/10.3390/digital6030055
Vancouver
Aguilar-Serrano A, Ávila-Villaprado J, Pinta M, Mazon-Olivo B. A Big Data Analytics Framework with Interactive Dashboards for Decision-Support in Ecuador’s Agricultural Sector. Digital. 2026;6(3):55. doi:10.3390/digital6030055
BibTeX
@article{AguilarSerrano2026,
author = {Aguilar-Serrano, Ashley and Ávila-Villaprado, Jean and Pinta, Maritza and Mazon-Olivo, Bertha},
title = {A Big Data Analytics Framework with Interactive Dashboards for Decision-Support in Ecuador’s Agricultural Sector},
journal = {Digital},
year = {2026},
volume = {6},
number = {3},
pages = {55},
doi = {10.3390/digital6030055}
}
EUVIMED