A Quantitative Assessment of Automated Dashboard Ecosystems Using ETL Pipelines and Real-Time Data Streaming for Business Performance Monitoring in SMEs

Abstract

This study addresses the critical problem faced by small and medium-sized enterprises (SMEs) in transforming fragmented, delayed, and inconsistent operational data into timely and reliable performance insights. The purpose of this research is to quantitatively evaluate how automated dashboard ecosystems supported by ETL pipelines and real-time data streaming enhance business performance monitoring. The study adopts a quantitative, cross-sectional, case-study–based design, using a structured five-point Likert scale survey distributed across cloud-enabled and enterprise SME cases in sectors such as retail, finance, logistics, and e-commerce, with 210 valid responses (84.0% response rate). Key variables include ETL pipeline efficiency, real-time data streaming capability, dashboard automation, dashboard usability, data accuracy, and business performance monitoring. The analysis plan incorporates descriptive statistics, Cronbach’s alpha reliability testing, Pearson correlation, and multiple regression modeling. The findings reveal strong statistical significance across all variables, with the regression model explaining 61% of the variance in business performance monitoring (R² = 0.61, F = 63.82, p < 0.001). Data accuracy emerged as the strongest predictor (β = 0.31, p < 0.001), followed by dashboard automation (β = 0.26), real-time streaming (β = 0.22), ETL efficiency (β = 0.19), and dashboard usability (β = 0.15). Correlation results further confirm strong relationships, particularly between data accuracy and performance monitoring (r = 0.72) and dashboard automation and monitoring (r = 0.70). Additionally, SMEs with advanced dashboard maturity achieved significantly higher performance monitoring scores (mean = 4.61) compared to low-maturity firms (mean = 3.12). These findings indicate that integrated dashboard ecosystems significantly improve KPI visibility, decision response speed, and operational awareness. The study implies that SMEs should prioritize data accuracy, automation, and real-time integration to achieve effective data-driven decision-making and competitive advantage.