Segmentasi Pelanggan Berbasis Rfm dan K-Means pada Sistem Analitik Penjualan

The growth of daily transaction data volumes in the retail sector often ends up as passive digital archives due to resource limitations in manual analysis. This condition makes it difficult for management to map consumer loyalty objectively, causing marketing strategies to miss the target. This study aims to design a web-based analytical information system using Python to automate customer segmentation. The approach used is the Knowledge Discovery in Database (KDD) cycle, integrating RFM (Recency, Frequency, Monetary) model feature extraction with the K-Means Clustering Unsupervised Machine Learning algorithm. From a total of 2,590 rows of raw transaction data, the system successfully pre-processed and aggregated them into 60 unique customer entities ready for clustering. Testing using the Elbow Method validated that the optimal number of partitions for this dataset is three clusters. Based on K-Means computation using Euclidean Distance, the system reached absolute convergence at the eighth iteration. This study successfully partitioned consumers into three segments: High Priority or Loyal Cluster, Medium Priority or Regular Cluster, and Low Priority or Passive Cluster. This analytical system is proven effective in visualizing segmentation autonomously, utilized as business intelligence to design targeted promotions and minimize customer churn risk. For future research, it is recommended to integrate directly into the point-of-sale system database in real-time and add customer demographic variables to make the analysis more comprehensive.

Authors

Institutions

Publication Details

Journal
Jurnal Minfo Polgan
Published
2026-11-08
DOI
https://doi.org/10.33395/jmp.v15i3.16877
Primary Topic
Customer churn and segmentation
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

Segmentasi Pelanggan Berbasis Rfm dan K-Means pada Sistem Analitik Penjualan

Yohanni Syahra, Rayhan Arma Novriansyah
4 links
Jurnal Minfo Polgan
Customer churn and segmentation
article

Segmentasi Pelanggan Berbasis Rfm dan K-Means pada Sistem Analitik Penjualan

Yohanni Syahra, Rayhan Arma Novriansyah
article en

Abstract

The growth of daily transaction data volumes in the retail sector often ends up as passive digital archives due to resource limitations in manual analysis. This condition makes it difficult for management to map consumer loyalty objectively, causing marketing strategies to miss the target. This study aims to design a web-based analytical information system using Python to automate customer segmentation. The approach used is the Knowledge Discovery in Database (KDD) cycle, integrating RFM (Recency, Frequency, Monetary) model feature extraction with the K-Means Clustering Unsupervised Machine Learning algorithm. From a total of 2,590 rows of raw transaction data, the system successfully pre-processed and aggregated them into 60 unique customer entities ready for clustering. Testing using the Elbow Method validated that the optimal number of partitions for this dataset is three clusters. Based on K-Means computation using Euclidean Distance, the system reached absolute convergence at the eighth iteration. This study successfully partitioned consumers into three segments: High Priority or Loyal Cluster, Medium Priority or Regular Cluster, and Low Priority or Passive Cluster. This analytical system is proven effective in visualizing segmentation autonomously, utilized as business intelligence to design targeted promotions and minimize customer churn risk. For future research, it is recommended to integrate directly into the point-of-sale system database in real-time and add customer demographic variables to make the analysis more comprehensive.

Jurnal Minfo PolganVol. 15(3)
Universitas Muhammadiyah Sumatera Utara (ID)
Customer churn and segmentation
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.

Laika access coming soon
Segmentasi Pelanggan Berbasis Rfm dan K-Means pada Sistem Analitik Penjualan — Yohanni Syahra, Rayhan Arma Novriansyah · Jurnal Minfo Polgan (2026) | TGRS Research Map | TGRS