Dynamic Retail Performance Dashboard (DRPD): Enterprise-Grade Business Intelligence Platform for Data-Driven Decision Support
State University of Northern Negros, Sagay City, Negros Occidental, Philippines.
Research Article
Open Access Research Journal of Engineering and Technology, 2026, 10(02), 099-108.
Article DOI: 10.53022/oarjet.2026.10.2.0043
Publication history:
Received on 11 April 2026; revised on 18 May 2026; accepted on 20 May 2026
Abstract:
This study presents the design, development, and evaluation of the Dynamic Retail Performance Dashboard (DRPD), a modular, open-source Business Intelligence (BI) platform developed using Python-based open-source tools. DRPD addresses the pressing need for accessible, scalable, and interpretable retail analytics tools, particularly for small and medium-sized enterprises (SMEs) and academic institutions, by integrating descriptive, predictive, and prescriptive analytical modules into a single Streamlit-based interface. The system implements a three-tier analytical hierarchy: Foundational Analytics (Tier 1), Prescriptive Insights (Tier 2), and Advanced Intelligence (Tier 3), supporting decision-making at the operational, tactical, and strategic levels. Principal new features include dynamic geospatial visualization, automated anomaly detection using statistical thresholding, machine learning-driven feature importance analysis with Random Forest regression, and algorithmic period-over-period comparative analytics. Evaluation of the platform with real-world retail transaction data demonstrates that the system transforms raw data into actionable strategic insights while maintaining computational efficiency through intelligent caching and modular design. As an open-source platform, DRPD supports potential adoption, replication, and extension in both business and academic contexts.
Keywords:
Business Intelligence; Data Analytics; Streamlit; Machine Learning; Retail Analytics; Decision Support Systems; Python; Visualization
Full text article in PDF:
Copyright information:
Copyright © 2026 Author(s) retain the copyright of this article. This article is published under the terms of the Creative Commons Attribution Liscense 4.0