Analisis Faktor Kinerja Penjualan Harian UMKM Menggunakan Metode Feature Engineering dan XAI Berbasis Gradient Boosting Regressor
DOI:
https://doi.org/10.47065/bulletincsr.v6i2.1005Keywords:
UMKM F&B; Feature Engineering; Gradient Boosting Regressor; Explainable AI; SHAPAbstract
Micro, small, and medium enterprises (MSMEs) in the food and beverage sector typically possess daily transaction records, yet these data are often used only for bookkeeping. As a result, the drivers of sales fluctuations are not clearly identified and operational decisions tend to rely on intuition. This study aims to (1) analyze the key factors influencing daily sales performance of MSME MW and (2) develop an accurate and interpretable sales forecasting model. The main problem addressed is how to transform time series transaction data, which are affected by seasonality, changes in customer behavior, and shifts across digital channels, into informative predictors that can capture non-linear relationships while still providing actionable explanations. The proposed solution integrates time series feature engineering to construct 21 predictive features from POS and digital channel data spanning 19 months, applies a Gradient Boosting Regressor to model complex patterns and improve predictive accuracy, and employs Explainable AI using the SHAP method to quantify both global and local feature contributions to the model output. Preliminary results indicate strong forecasting performance, achieving an R² of 0.987265, an MAE of IDR 33,194.014, and an RMSE of IDR 42,625.808, suggesting a high level of agreement between predicted and actual daily sales. The SHAP analysis identifies “Total Items Sold” and “ATV” as the most dominant drivers of sales increases, while lag-based sales features exhibit non-linear behavior consistent with mean reversion following extreme spikes. Linguistically, these findings imply that revenue growth is driven not only by sales volume, but also by optimizing average transaction value, providing a clear direction for data-driven operational strategies.
Downloads
References
“Pemerintah Dorong UMKM Naik Kelas, Tingkatkan Kontribusi terhadap Ekspor Indonesia - Kementerian Koordinator Bidang Perekonomian Republik Indonesia.” Accessed: Nov. 07, 2025. [Online]. Available: https://www.ekon.go.id/publikasi/detail/6152/pemerintah-dorong-umkm-naik-kelas-tingkatkan-kontribusi-terhadap-ekspor-indonesia
“UMKM Indonesia - Kadin Indonesia.” Accessed: Nov. 17, 2025. [Online]. Available: https://kadin.id/data-dan-statistik/umkm-indonesia/
E. N. Yunus, E. Ernawati, E. Nuraini, and K. Yuniarti, “Post-crisis growth: Resource orchestration, innovation, and diversification in MSMEs,” Journal of Open Innovation: Technology, Market, and Complexity, vol. 11, no. 2, p. 100570, Jun. 2025, doi: 10.1016/j.joitmc.2025.100570.
D. Novianti and B. Baihaqi, “The Influence of E-Payment and E-Commerce Services on Supply Chain Performance MSMEs,” Asian Journal of Applied Business and Management, vol. 4, no. 2, pp. 405–420, May 2025, doi: 10.55927/ajabm.v4i2.141.
A. L. Kilay, B. H. Simamora, and D. P. Putra, “The Influence of E-Payment and E-Commerce Services on Supply Chain Performance: Implications of Open Innovation and Solutions for the Digitalization of Micro, Small, and Medium Enterprises (MSMEs) in Indonesia,” Journal of Open Innovation: Technology, Market, and Complexity, vol. 8, no. 3, Sep. 2022, doi: 10.3390/joitmc8030119.
H. Aini Shafira, S. Informasi, and S. Tinggi Teknologi Terpadu Nurul Fikri Jakarta Selatan, “Penerapan Modul Point of Sale Odoo untuk Efisiensi Transaksi Penjualan Umkm Toko Tiga Saudara,” Journal of Digital Business and Technology Innovation (DBESTI), vol. 2, no. 2, pp. 308–312, 2025, [Online]. Available: https://journal.nurulfikri.ac.id/index.php/DBESTI
S. A. Hendrawan, Afdhal Chatra, Nurul Iman, Soemarno Hidayatullah, and Degdo Suprayitno, “Digital Transformation in MSMEs: Challenges and Opportunities in Technology Management,” Jurnal Informasi dan Teknologi, pp. 141–149, Jun. 2024, doi: 10.60083/jidt.v6i2.551.
Y. Ceng Giap, “Penerapan Data Mining untuk Menganalisis Pola Transaksi Penjualan Dengan Metode Association Rule Algoritma Fp-Growth (Studi Kasus?: Pt. Tumbakmas Niaga Sakti),” Sains Terapan dan Teknologi, vol. 4, no. 2, pp. 1–11, Oct. 2023.
E. D. Purnamasari and A. Asharie, “Digitalisasi Umkm, Literasi Keuangan Terhadap Kinerja Keuangan Umkm di Era New Normal Pandemi Covid 19,” Jesya, vol. 7, no. 1, pp. 348–361, Jan. 2024, doi: 10.36778/jesya.v7i1.1416.
B. Rolando et al., “Digital Marketing Strategies for Sales Growth in Indonesian Home Industries,” Journal of Trends Economics and Accounting Research, vol. 5, no. 3, pp. 278–292, 2025, doi: 10.47065/jtear.v5i3.1852.
Y. A. Nugroho and H. A. Hutahaean, “Pengembangan Model Deep Learning LSTM dan CNN untuk Peramalan Penjualan Sepeda Motor di Indonesia,” Jupiter: Publikasi Ilmu Keteknikan Industri, Teknik Elektro dan Informatika, vol. 3, no. 2, pp. 94–104, Mar. 2025, doi: 10.61132/jupiter.v3i2.795.
F. A. Rangkuti, Khairunnisa, and S. Sundari, “Implementasi Gradient Boosting Machines untuk Prediksi Harga Rumah Pada Jakarta Selatan,” Jurnal Kecerdasan Buatan dan Teknologi Informasi, vol. 4, no. 2, pp. 164–172, May 2025, doi: 10.69916/jkbti.v4i2.318.
A. S. Antonini et al., “Machine Learning Model Interpretability Using SHAP Values: Application to Igneous Rock Classification Task,” Sep. 01, 2024, Elsevier B.V. doi: 10.1016/j.acags.2024.100178.
K. Coussement, M. Z. Abedin, M. Kraus, S. Maldonado, and K. Topuz, “Explainable AI for Enhanced Decision Making,” Decis. Support Syst., vol. 184, p. 114276, Sep. 2024, doi: 10.1016/J.DSS.2024.114276.
P. Rozita, E. Saiful Subhan, and S. Tinggi Ilmu Ekonomi Yapis, “Analisis Strategi Pemasaran pada UMKM di Era Digital: Studi Kasus Pada Platform Shopee,” Economics and Digital Business Review, vol. 7, no. 1, pp. 2025–365, 2025.
R. Winurputra and D. E. Ratnawati, “Peramalan Penjualan Produk Menggunakan Extreme Gradient Boosting (XGBoost) dan Kerangka Kerja CRISP-DM untuk Pengoptimalan Manajemen Persediaan (Studi Kasus: UB Mart),” Jurnal Teknologi Informasi dan Ilmu Komputer, vol. 12, no. 2, pp. 417–428, Apr. 2025, doi: 10.25126/jtiik.2025129451.
G. Sharma and S. Patil, “Extreme Gradient Boosting Model-based Forecasting of Big Data Online Sales Record,” SAMRIDDHI?: A Journal of Physical Sciences, Engineering and Technology, vol. 14, no. 01, pp. 112–119, Mar. 2022, doi: 10.18090/samriddhi.v14i01.18.
S. A. Khairi, A. R. Ardiansyah, and L. Rosyidi, “Perbandingan XGB Regressor Dengan Algoritma Lain untuk Prediksi Tarif Tol,” Journal of Digital Business and Technology Innovation (DBESTI), vol. 2, no. 1, pp. 127–132, 2025, [Online]. Available: https://journal.nurulfikri.ac.id/index.php/DBESTI
S. Mansur et al., “Sales forecasting for retail stores using hybrid neural networks and sales-affecting variables,” PeerJ Comput. Sci., vol. 11, p. e3058, Sep. 2025, doi: 10.7717/peerj-cs.3058.
A. Iqbal and R. Amin, “An Efficient Mechanism for Time Series Forecasting and Anomaly Detection Using Explainable Artificial Intelligence,” J. Supercomput., vol. 81, no. 4, p. 523, Feb. 2025, doi: 10.1007/s11227-025-07040-0.
K. Dwi Hartomo, C. Arthur, and Y. Nataliani, “A Novel Weighted Loss TabTransformer Integrating Explainable AI for Imbalanced Credit Risk Datasets,” IEEE Access, vol. 13, pp. 31045–31056, 2025, doi: 10.1109/ACCESS.2025.3541878.
P. Slater and F. Hasson, “Quantitative Research Designs, Hierarchy of Evidence and Validity,” J. Psychiatr. Ment. Health Nurs., vol. 32, no. 3, pp. 656–660, Jun. 2025, doi: 10.1111/jpm.13135.
S. Karmaker, “Feature Engineering in Time Series Forecasting: an Empirical Study Using German Electricity Load Data Feature Engineering in Time Series Forecasting,” ScienceOpen Preprints, Nov. 2025, doi: 10.25832/time_series/2020-10-06.
X. Long et al., “Scalable Probabilistic Forecasting in Retail With Gradient Boosted Trees: a Practitioner’s Approach,” Int. J. Prod. Econ., vol. 279, Jan. 2025, doi: 10.1016/j.ijpe.2024.109449.
C. Bentéjac, A. Csörg?, and G. Martínez-Muñoz, “A comparative analysis of gradient boosting algorithms,” Artif. Intell. Rev., vol. 54, no. 3, pp. 1937–1967, Mar. 2019, doi: 10.1007/s10462-020-09896-5.
S. M. Lundberg and S. I. Lee, “A Unified Approach to Interpreting Model Predictions,” Adv. Neural Inf. Process. Syst., vol. 2017-December, pp. 4766–4775, May 2017, Accessed: Dec. 12, 2025. [Online]. Available: https://arxiv.org/pdf/1705.07874
R. Rodríguez-Pérez and J. Bajorath, “Interpretation of machine learning models using shapley values: application to compound potency and multi-target activity predictions,” J. Comput. Aided. Mol. Des., vol. 34, no. 10, pp. 1013–1026, Oct. 2020, doi: 10.1007/s10822-020-00314-0.
M. Arboleda-Florez and C. Castro-Zuluaga, “Interpreting Direct Sales’ Demand Forecasts Using SHAP Values,” Production, vol. 33, 2023, doi: 10.1590/0103-6513.20220035.
S. Mansur et al., “Sales forecasting for retail stores using hybrid neural networks and sales-affecting variables,” PeerJ Comput. Sci., vol. 11, p. e3058, Sep. 2025, doi: 10.7717/peerj-cs.3058.
L. Wang and X. Zhang, “Livestream sales prediction based on an interpretable deep-learning model,” Sci. Rep., vol. 14, no. 1, p. 20594, Sep. 2024, doi: 10.1038/s41598-024-71379-2.
J. Li, Z. Zhang, S. Kang, Y. Lu, L. Gan, and Y. Xu, “Research on Future Sales Prediction Based on Feature Engineering,” in Proceedings of the 4th International Conference on Artificial Intelligence and Computer Engineering, New York, NY, USA: ACM, Nov. 2023, pp. 223–228. doi: 10.1145/3652628.3652666.
H. Ahaggach, L. Abrouk, and E. Lebon, “Systematic Mapping Study of Sales Forecasting: Methods, Trends, and Future Directions,” Forecasting, vol. 6, no. 3, pp. 502–532, Sep. 2024, doi: 10.3390/forecast6030028.
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Analisis Faktor Kinerja Penjualan Harian UMKM Menggunakan Metode Feature Engineering dan XAI Berbasis Gradient Boosting Regressor
ARTICLE HISTORY
How to Cite
Issue
Section
Copyright (c) 2026 Nur Afif Raihan, Salman Fathy Shiroth

This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).













