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
- Marsani Asfi (ORCID: https://orcid.org/0000-0002-6399-5362)
- Lena Magdalena (ORCID: https://orcid.org/0000-0002-3542-1572)
- Belfania Priandini
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