Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace

I Wayan Manik Mas Sri Dantya ; I Wayan Sudiarsa ; I Putu Kabinawa Raesa Putra ; Brian Adi Sapurta ; I Komang Hari Sastrawan
Repeater : Publikasi Teknik Informatika dan Jaring... 📅 2026 Vol 4, No 1 🔗 DOI: 10.62951/repeater.v4i1.799
Abstract
In the rapidly evolving digital economy, the ability to anticipate transaction surges is a strategic asset for marketplace platforms to maintain operational efficiency. This research aims to build an accurate daily transaction volume forecasting system thru the implementation of an Extract, Transform, and Load (ETL) pipeline and Autoregressive Integrated Moving Average (ARIMA) predictive modeling. The dataset used is sourced from dataset_olshop.csv, which includes transaction history for the entire year of 2025. The ETL stage focused on data cleaning and handling missing values, while time series analysis began with the Augmented Dickey-Fuller (ADF) stationarity test, which yielded a significant p-value of 0.000006. The parameter model was optimized using the auto_arima algorithm, which determined the ARIMA(2,0,0) configuration as the best model. The evaluation results of the model show fairly stable performance with a Root Mean Squared Error (RMSE) value of 2.002 and a Mean Absolute Error (MAE) of 1.704 on the test data. Research findings reveal a consistently higher purchasing pattern during the mid-month and end-of-month periods, with an average of 5.52 daily transactions, compared to the beginning of the month, which saw 5.48 transactions. The 30-day forecast results provide valuable insights for online store managers to proactively adjust inventory and logistics workforce allocation strategies. This research concludes that integrating data engineering techniques and statistical analysis can provide predictive solutions for the dynamics of the digital market.
Keywords
ARIMA; Data Engineering; ETL; Forecasting; Marketplace
How to Cite

I Wayan Manik Mas Sri Dantya, et al. (2026). Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace. Repeater : Publikasi Teknik Informatika dan Jaringan, 4(1). https://doi.org/10.62951/repeater.v4i1.799

I Wayan Manik Mas Sri Dantya; I Wayan Sudiarsa; I Putu Kabinawa Raesa Putra; Brian Adi Sapurta; I Komang Hari Sastrawan, "Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace," Repeater : Publikasi Teknik Informatika dan Jaringan, vol. 4, no. 1, 2026.

I Wayan Manik Mas Sri Dantya; I Wayan Sudiarsa; I Putu Kabinawa Raesa Putra; Brian Adi Sapurta; I Komang Hari Sastrawan. "Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace." Repeater : Publikasi Teknik Informatika dan Jaringan, vol. 4, no. 1, 2026.

I Wayan Manik Mas Sri Dantya; I Wayan Sudiarsa; I Putu Kabinawa Raesa Putra; Brian Adi Sapurta; I Komang Hari Sastrawan. "Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace." Repeater : Publikasi Teknik Informatika dan Jaringan 4, no. 1 (2026).

I Wayan Manik Mas Sri Dantya, et al. (2026) 'Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace', Repeater : Publikasi Teknik Informatika dan Jaringan, 4(1). doi: 10.62951/repeater.v4i1.799.

I Wayan Manik Mas Sri Dantya; I Wayan Sudiarsa; I Putu Kabinawa Raesa Putra; Brian Adi Sapurta; I Komang Hari Sastrawan. Implementasi Pipeline ETL dan Pemodelan Prediktif ARIMA dalam Memetakan Pola Pembelian Konsumen pada Dataset Marketplace. Repeater : Publikasi Teknik Informatika dan Jaringan. 2026;4(1).

Artikel Terkait

Implementation of RT/RW Net WiFi Network as a Solution to Internet Needs in Motu Village, Pasangkayu Regency, West Sulawesi

Muhqisar, Iqvhan; Sanatang Sanatang; Parenreng, Jumadi M.

Systematic Literature Review Sistem Pemilah Sampah Otomatis Berbasis Sensor Proximity dengan Notifikasi Kapasitas Penuh

Anjelina Mentari Rustandi; Fathoni Mahardika; Dani Indra Junaedi

Sistem Informasi Aplikasi Pelayanan Pengaduan Masyarakat Dikantor Pertanahan Kabupaten Sumba Barat Daya

Markus Kamuri; Stefanus D.I. Mau; Maria Wilda Malo

Analisis Konsep Logika Fuzzy sebagai Pendukung Penilaian Prestasi Akademik Mahasiswa Universitas Asahan

Muhammad Agil Zuhairi; Syahrul Syahrul; Khairul Shaleh

Optimasi Prediksi Harga Saham BBNI melalui Integrasi Proses ETL dan Algoritma Long Short-Term Memory

I Gusti Ngurah Rangga Mahesa; I Wayan Sudiarsa; I Putu Dicky Dharma Suryasa; Putu Agus Aditya Putra; Yulianus Kevin Dharmawa Sagur

Penentuan Penerima Beasiswa Menggunakan Metode Fuzzy Tsukamoto

Sri Bintan; Adhistya Aulia Dh; Khairul Shaleh
Tren Sitasi Jurnal