Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal OKTAL : Jurnal Ilmu Komputer dan Sains
Abdu Muflihun
Universitas Pamulang
Astronomy Chemistry Computer Science & IT Electrical & Electronics Engineering Social Sciences

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Rancang Bangun Sistem CRM Berbasis Web Dengan Algoritma Apriori untuk Analisis Pembelian dan Pengingat Pelanggan Abdu Muflihun; Eka Yuni Titik Artaningsih
OKTAL : Jurnal Ilmu Komputer dan Sains Vol 5 No 09 (2026): OKTAL : Jurnal Ilmu Komputer Dan Sains
Publisher : CV. Multi Kreasi Media

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

PT Inscienpro Instrumen Indonesia faces challenges in managing customer data manually using spreadsheets, leading to data errors and missed repeat order opportunities. This study aims to design and develop a web-based CRM system integrated with the Apriori algorithm to analyze purchase history and provide automated follow-up reminders. The system was developed using the Waterfall model with Laravel and MySQL. The system consists of 7 main tables and 10 functional modules. The Apriori algorithm was tested on 100 transactions, generating 3 frequent 2-itemsets with support values of 24%-27% and association rules with confidence reaching 100%, such as Borax Test Kit - Formaldehyde Test Kit. Black Box testing on 8 modules showed 100% success across 42 scenarios, while White Box testing validated 5 critical modules covering login, customer, product, transaction, and follow-up features. The follow-up reminder system successfully generates schedules based on 12-month calibration and expiry periods with 5 filtering statuses. This integrated system provides valuable insights for data-driven decision-making and improves operational efficiency in customer relationship management at the company.
Co-Authors Eka Yuni Titik Artaningsih