Web-Based Sales Performance Information System Using K-Means

Inayah Ainina Mawardi; Rita Wahyuni Arifin

doi:10.59976/jurit.v4i2.390

Authors

Inayah Ainina Mawardi Universitas Bina Insani, Sistem Informasi
Rita Wahyuni Arifin Universitas Bina Insani

DOI:

https://doi.org/10.59976/jurit.v4i2.390

Keywords:

Data Analysis, K-Means Clustering, Sales Performance, Web-Based Information System, User-Centered Design

Abstract

PT FAN Integrasi Teknologi is a company in the field of information technology that has sales activities as the basis for recording and evaluating sales performance. The sales performance appraisal process is still carried out manually using spreadsheets and separate documents, causing the recapitulation process to take time and make it difficult for management to evaluate performance. This research aims to develop and build a web-based sales performance information system that can integrate data management and help the sales performance evaluation process. The system development method used to classify sales performance is based on the variables of total score, number of projects, and win rate, applied to a dataset of seven historical sales records at the company. The results of the research are in the form of a sales performance information system that provides data management, dashboards, performance analysis, and reports. The clustering process grouped sales into three exploratory categories, namely High Performer, Medium Performer, and Low Performer, based on similarity in the selected variables rather than an independently validated performance standard. A beta test involving eight respondents obtained an initial satisfaction score of 84.5%. These preliminary results indicate that, as a company-specific prototype, the system has potential as a tool for monitoring and supporting the evaluation of sales performance at PT FAN Integrasi Teknologi, pending further validation with a larger dataset.

References

M. S. E. Kasem, M. Hamada, and I. Taj-Eddin, “Customer Profiling, Segmentation, and Sales Prediction Using Artificial Intelligence,” Neural Comput. Appl., 2024, doi: 10.1007/s00521-023-09339-6.

H. Syahputra, “Clustering Tingkat Penjualan Menu Food and Beverage Menggunakan Algoritma K-Means,” J. KomtekInfo, vol. 9, no. 1, pp. 29–33, 2022, doi: 10.35134/komtekinfo.v9i1.274.

X. Yan, “Bank Customer Segmentation and Marketing Strategies Based on Machine Learning,” Appl. Sci., vol. 15, no. 6, p. 3138, 2025, doi: 10.3390/app15063138.

F. J. Seagull, M. S. Lanham, M. Pomorski, M. Callahan, E. K. Jones, and G. D. Barnes, “Implementing Evidence-Based Anticoagulant Prescribing: User-Centered Design Findings and Recommendations,” Res. Pract. Thromb. Haemost., vol. 6, no. 6, p. e12803, 2022, doi: 10.1002/rth2.12803.

H. J. Wilbert, “Recency, Frequency, Monetary Value, Clustering, and Customer Behavior Analysis,” Algorithms, vol. 16, no. 9, p. 396, 2023, doi: 10.3390/a16090396.

Y. Sonatha, A. Erianda, and R. Fitri, “Sales Segmentation Analysis of Tobacco Products Using the K-Means Clustering Method,” INVOTEK J. Inov. Vokasional dan Teknol., vol. 24, no. 2, 2024, doi: 10.24036/invotek.v24i2.1221.

D. A. Titania, L. Kurniawati, and T. Haryanti, “Designing the UI/UX of a Document Archiving Information System Using the User-Centered Design Method,” METIK J., vol. 8, no. 1, 2024, doi: 10.47002/metik.v8i1.686.

K. Tabianan, S. Velu, and V. Ravi, “K-Means Clustering Approach for Intelligent Customer Segmentation Using Customer Purchase Behavior Data,” Sustainability, vol. 14, no. 12, p. 7243, 2022, doi: 10.3390/su14127243.

A. Ghosh and A. Roy, “Comparative Study of K-Means, Bisecting K-Means, and DBSCAN for Customer Segmentation,” J. Intell. Fuzzy Syst., vol. 45, no. 4, pp. 5321–5332, 2023, doi: 10.3233/JIFS-212245.

L. L. Jauculan and U. B. Patayon, “Enhancing UX/UI: A Mixed-Approach Evaluation of a Web-Based Student Clearance System at a State University in the Philippines,” Procedia Comput. Sci., vol. 234, pp. 1061–1068, 2024, doi: 10.1016/j.procs.2024.03.100.

K. Chowdhary et al., “User-Centered Design to Enhance mHealth Systems for Individuals With Dexterity Impairments: Accessibility and Usability Study,” JMIR Hum. Factors, vol. 9, no. 1, p. e23794, 2022, doi: 10.2196/23794.

L. Xiao, “GMS-AFKMC2: A New Customer Segmentation Framework Based on Feature Selection and K-Means Clustering,” Electronics, vol. 13, no. 17, p. 3523, 2024, doi: 10.3390/electronics13173523.

M. Rochmawati, “Implementation of the K-Means Algorithm in Sales Clustering at a Company Using the KDD Methodology,” SISTEMASI, vol. 13, no. 1, 2024, doi: 10.32520/stmsi.v13i1.3074.

S. N. Lathifah and Z. F. Azzahra, “AI-Driven Customers Segmentation Using K-Means Clustering,” G-Tech J. Teknol. Terap., vol. 9, no. 1, 2025, doi: 10.70609/gtech.v9i1.6202.

C. P. Ufeli, “Customer Segmentation Based Approach Using Factor Analysis, K-Means, and Hierarchical Clustering,” Information, vol. 16, no. 6, p. 441, 2025, doi: 10.3390/info16060441.

M. Puspita Hannah and R. Nur Kholiza, “Perancangan UI/UX Penerimaan Peserta Didik Baru Berbasis Website Menggunakan Metode User Centered Design,” KLIK Kaji. Ilm. Inform. dan Komput., vol. 4, no. 4, pp. 2342–2356, 2024, doi: 10.30865/klik.v4i4.1722.

B. Mostefai, “Enhancing User Experience in E-Learning Systems: A New Evaluation and User-Centered Design Approach,” Comput. Hum. Behav. Reports, p. 100643, 2025, doi: 10.1016/j.chbr.2025.100643.

M. Miranda, “Implementation of K-Means Clustering in Grouping Sales Data at Zura Mart,” J. Appl. Informatics Comput., 2025, [Online]. Available: https://jurnal.polibatam.ac.id/index.php/JAIC/article/view/9160

Y. Zhao, H. Lin, and W. Zhang, “RFM-Based Clustering and Product Recommendation Using Association Rules,” Expert Syst. Appl., vol. 198, p. 116899, 2022, doi: 10.1016/j.eswa.2022.116899.

J. M. John, O. Shobayo, and B. Ogunleye, “An Exploration of Clustering Algorithms for Customer Segmentation in the UK Retail Market,” Analytics, vol. 2, no. 4, pp. 809–823, 2023, doi: 10.3390/analytics2040042.

A. Twomlow, S. Grainger, K. Cieslik, J. D. Paul, and W. Buytaert, “A User-Centred Design Framework for Disaster Risk Visualisation,” Int. J. Disaster Risk Reduct., vol. 77, p. 103067, 2022, doi: 10.1016/j.ijdrr.2022.103067.

S. S. Groos, A. J. Linn, J. I. Kuiper, N. M. van Schoor, N. van der Velde, and J. C. M. van Weert, “Combining User-Centered Design and Behavioral Theory to Enhance Health Technologies: A Personas-Based Approach for a Primary-Care-Based Multifactorial Falls Risk Assessment Tool,” Int. J. Med. Inform., vol. 186, p. 105420, 2024, doi: 10.1016/j.ijmedinf.2024.105420.

M. Deldadehasl, “A Hybrid Data Mining and Decision-Making Approach for Customer Segmentation,” Businesses, vol. 6, no. 2, p. 80, 2025, doi: 10.3390/businesses6020080.

H. Alamsyah, “Customer Segmentation Using RFM and K-Means Clustering,” J. Theor. Appl. Inf. Technol., vol. 100, no. 5, pp. 1301–1310, 2022.

A. Ullah, “Customer Analysis Using Machine-Learning-Based Methods for Effective Segmentation,” Sensors, vol. 23, no. 6, p. 3180, 2023, doi: 10.3390/s23063180.

C. Wongoutong, “The Impact of Neglecting Feature Scaling in K-Means Clustering,” PLoS One, vol. 19, no. 12, 2024, [Online]. Available: https://pmc.ncbi.nlm.nih.gov/articles/PMC11623793/

G. D. G. E. Sidabutar, J. A. Seah, and Y. A. Singgalen, “Analysis and Design of Web-Based Information System for Coffeeshop Management Using Design Thinking Methodology,” J. Inf. Syst. Informatics, vol. 5, no. 1, pp. 217–231, 2023, doi: 10.51519/journalisi.v5i1.455.

H. Saputra, M. Algipani, A. N. Mulya, and H. F. Zafira, “UI/UX Design Using User-Centered Design Method on Staycation Website,” in 2024 International Conference on Information Technology Research and Innovation, 2024. doi: 10.1109/INCITEST64888.2024.11121477.

S. N. A. Zahra and S. Suryatiningsih, “Evaluation and Improvement of User Interface Design of Bandung City APBD Website Using Human Centered Design Method,” Procedia Comput. Sci., vol. 234, pp. 1791–1798, 2024, doi: 10.1016/j.procs.2024.03.187.

P. Anitha and M. M. Patil, “RFM Model for Customer Purchase Behavior Using K-Means Algorithm,” J. King Saud Univ. - Comput. Inf. Sci., vol. 34, no. 5, pp. 1785–1792, 2022, [Online]. Available: https://www.sciencedirect.com/science/article/pii/S1319157819309802

C. G. Wong, T. Nguyen, and K. Lee, “Application of Hierarchical and K-Means Clustering in E-Commerce Customer Segmentation,” Int. J. Inf. Manag. Data Insights, vol. 2, no. 1, p. 100055, 2022, doi: 10.1016/j.jjimei.2021.100055.

N. Kumar, “Intelligent Customer Segmentation: Unveiling Consumer Patterns with Machine Learning,” J. Umm Al-Qura Univ. Eng. Archit., 2025, doi: 10.1007/s43995-025-00180-7.

T. Ozcan, “Customer Segmentation Using an Extended RFM Model and Machine-Learning Methods,” J. Theor. Appl. Electron. Commer. Res., vol. 21, no. 5, p. 142, 2026, doi: 10.3390/jtaer21050142.

J. Salminen, M. Mustak, M. Sufyan, and B. J. Jansen, “How Can Algorithms Help in Segmenting Users and Customers? A Systematic Review and Research Agenda for Algorithmic Customer Segmentation,” J. Mark. Anal., vol. 11, no. 4, pp. 677–692, 2023, doi: 10.1057/s41270-023-00235-5.

R. I. Manarung, E. Widodo, and A. M. Rifai, “Sales Data Clustering Using the K-Means Algorithm to Determine Retail Product Needs,” Int. J. Softw. Eng. Comput. Sci., vol. 5, no. 1, pp. 226–234, 2025, doi: 10.35870/ijsecs.v5i1.4090.

A. A. Yunanto, “Design and Implementation of the Prayer Reminder Application Using KISS Principle Based on User Centered Design,” Procedia Comput. Sci., vol. 234, pp. 1484–1491, 2024, doi: 10.1016/j.procs.2024.03.149.

A. Mulyawan, A. Bahtiar, and I. Ali, “Transformasi Strategi Penjualan Batik Cirebon dengan Pendekatan Analisis Pengelompokan K-Means,” KOPERTIP J. Ilm. Manaj. Inform. dan Komput., vol. 7, no. 1, pp. 1–7, 2023, doi: 10.32485/kopertip.v7i1.309.

Y. Yovian and N. R. Pratama, “Examining The Impact of E-Service Quality and E-Recovery Service Quality in Digital Public Services in Indonesia,” J. World Sci., vol. 4, no. 6, pp. 754–768, 2025, doi: 10.58344/jws.v4i6.1426.

I. Sarifah et al., “Development of Android Based Educational Games to Enhance Elementary School Student Interests in Learning Mathematics,” Int. J. Interact. Mob. Technol., vol. 16, no. 18, pp. 149–161, 2022, doi: 10.3991/ijim.v16i18.32949.

A. M. Ikotun, A. E. Ezugwu, L. Abualigah, B. Abuhaija, and J. Heming, “K-means clustering algorithms: A comprehensive review, variants analysis, and advances in the era of big data,” Inf. Sci. (Ny)., vol. 622, pp. 178–210, 2023, doi: 10.1016/j.ins.2022.11.139.