IMPLEMENTASI K-MEANS RFM DAN HOLT-WINTERS EXPONENTIAL SMOOTHING ADDITIVE DALAM SISTEM BUSINESS INTELLIGENCE UNTUK STRATEGI PENGELOLAAN PELANGGAN PADA PERUSAHAAN TRANSPORTASI. Pembuatan Dashboard BI Segmentasi pelanggan dan peramalan Jumlah pelanggan

The growth of customer data in the transportation industry drives the need for analytical systems capable of segmenting customers objectively and strategically. This study aims to apply the K-Means Clustering method based on the Recency, Frequency, and Monetary (RFM) model for customer segmentation and utilize the Holt-Winters Exponential Smoothing Additive method to forecast passenger numbers. The dataset comprises 10,440 customer transactions from PT XYZ during the 2022–2024 period. RFM values were calculated, normalized, and processed using the K-Means algorithm to produce three customer clusters: Loyal, Regular, and Passive. Subsequently, the Holt-Winters method was employed to forecast passenger numbers, achieving the smallest Mean Absolute Percentage Error (MAPE) of 6.88%, indicating a high level of accuracy. The results were visualized through an interactive dashboard using Tableau, enabling management to make data-driven decisions. This research demonstrates that integrating segmentation and forecasting methods into a Business Intelligence system can enhance the effectiveness of marketing strategies and the operational efficiency of the company.

Authors

Publication Details

Journal
METHODIKA Jurnal Teknik Informatika dan Sistem Informasi
Published
2025-09-16
DOI
https://doi.org/10.46880/mtk.v11i2.4511
Primary Topic
Data Mining and Machine Learning Applications
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

IMPLEMENTASI K-MEANS RFM DAN HOLT-WINTERS EXPONENTIAL SMOOTHING ADDITIVE DALAM SISTEM BUSINESS INTELLIGENCE UNTUK STRATEGI PENGELOLAAN PELANGGAN PADA PERUSAHAAN TRANSPORTASI. Pembuatan Dashboard BI Segmentasi pelanggan dan peramalan Jumlah pelanggan

Marsani Asfi, Lena Magdalena, Belfania Priandini
METHODIKA Jurnal Teknik Informatika dan Sistem Informasi
Data Mining and Machine Learning Applications
article

IMPLEMENTASI K-MEANS RFM DAN HOLT-WINTERS EXPONENTIAL SMOOTHING ADDITIVE DALAM SISTEM BUSINESS INTELLIGENCE UNTUK STRATEGI PENGELOLAAN PELANGGAN PADA PERUSAHAAN TRANSPORTASI. Pembuatan Dashboard BI Segmentasi pelanggan dan peramalan Jumlah pelanggan

Marsani Asfi, Lena Magdalena, Belfania Priandini
article en

Abstract

The growth of customer data in the transportation industry drives the need for analytical systems capable of segmenting customers objectively and strategically. This study aims to apply the K-Means Clustering method based on the Recency, Frequency, and Monetary (RFM) model for customer segmentation and utilize the Holt-Winters Exponential Smoothing Additive method to forecast passenger numbers. The dataset comprises 10,440 customer transactions from PT XYZ during the 2022–2024 period. RFM values were calculated, normalized, and processed using the K-Means algorithm to produce three customer clusters: Loyal, Regular, and Passive. Subsequently, the Holt-Winters method was employed to forecast passenger numbers, achieving the smallest Mean Absolute Percentage Error (MAPE) of 6.88%, indicating a high level of accuracy. The results were visualized through an interactive dashboard using Tableau, enabling management to make data-driven decisions. This research demonstrates that integrating segmentation and forecasting methods into a Business Intelligence system can enhance the effectiveness of marketing strategies and the operational efficiency of the company.

METHODIKA Jurnal Teknik Informatika dan Sistem InformasiVol. 11(2)
Openalex Percentile: Top 63%
Data Mining and Machine Learning Applications
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

IMPLEMENTASI K-MEANS RFM DAN HOLT-WINTERS EXPONENTIAL SMOOTHING ADDITIVE DALAM SISTEM BUSINESS INTELLIGENCE UNTUK STRATEGI PENGELOLAAN PELANGGAN PADA PERUSAHAAN TRANSPORTASI. Pembuatan Dashboard BI Segmentasi pelanggan dan peramalan Jumlah pelanggan — Marsani Asfi, Lena Magdalena, et al. · METHODIKA Jurnal Teknik Informatika dan Sistem Informasi (2025) | TGRS Research Map | TGRS