Jean Carlos Avila

Mr. Jean Carlos Avila

orcid

Research Focus & Metrics

Academic Career Length

2Years (2025-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
22 October 2025
Verified
Book
Closed access
Bertha Mazon-OlivoBertha Mazon-Olivo
Bertha Mazon-Olivo
WRWilmer Rivas
Wilmer Rivas
JCJoffre Jeorwin Cartuche Calva
Joffre Jeorwin Cartuche Calva
Ashley Aguilar SerranoAshley Aguilar Serrano
Ashley Aguilar Serrano
JAJean Carlos Avila
Jean Carlos Avila
Este libro, titulado "Big Data & Analytics, un enfoque práctico", surge como una guía para quienes desean comprender y dominar los fundamentos y herramientas esenciales del ecosistema Big Data. Está diseñado para estudiantes, docentes, investigadores y profesionales que buscan una formación sólida, tanto teórica como práctica, en tecnologías de procesamiento distribuido de datos.

2 July 2026 in Digital
Verified
Journal Article
Open access
PDF file
Ashley Aguilar SerranoAshley Aguilar Serrano
Ashley Aguilar Serrano
JAJean Carlos Avila
Jean Carlos Avila
Maritza Alexandra PintaMaritza Alexandra Pinta
Maritza Alexandra Pinta
Bertha Mazon-OlivoBertha Mazon-Olivo
Bertha Mazon-Olivo
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.
1