Optimalization of Grouping Models on Sales Transaction Data in the Josi.Id Store Using the K-Means Algorithm

Resda Dayanti; Rudi Kurniawan; Tati Suprapti

doi:10.33365/jatika.v6i1.21

Resda Dayanti STMIK IKMI CIREBON
Rudi Kurniawan STMIK IKMI CIREBON
Tati Suprapti STMIK IKMI CIREBON

DOI: https://doi.org/10.33365/jatika.v6i1.21

Keywords: K-Means, Davies-Bouldin Index, Data Clustering, Sales Transaction Data, Seasonal Products

Abstract

This study aims to optimize the K-Means algorithm to improve the clustering model of fashion goods sales transaction data at the josi.id store over a period of seven months. One of the main challenges is the lack of understanding of the characteristics of sales transaction data at the josi.id store, as well as the difficulty in identifying products that cause spikes on big days. With the K-Means clustering method used to group data, the optimal K value, attributes that affect the Davies Bouldin index (DBI) value. The analysis of the results shows that the key attribute that affects the k value is the TYPE OF ITEM with K = 3 as the optimal value, has the lowest DBI value of 0.258 compared to other cluster configurations. With the characteristics of cluster 0 (429 items) showing dominant sales during the Eid season. Cluster 1 (343 items) shows high sales during the holiday period. Cluster 2 (309 items) has stable sales during weekdays. These results show good separation and uniformity of clusters in each cluster. The attribute of ITEM TYPE, based on the characteristics of each cluster is Bracket clothes products show the highest total sales of up to 7 million, supported by traffic (love feature) that is often viewed. Blouses have total sales of under 2 million, while dresses show great variation with total sales between 1 and more than 3 million. Skirts have a more diverse sales distribution, with transactions reaching 3 million. which includes categories such as Dresses, bracket clothes, Tops, and Skirts, plays an important role in grouping sales transaction data, especially for seasonal products such as during Eid.

Downloads

Download data is not yet available.

References

B. KANDEMİR, ‘A Methodology for Clustering Items with Seasonal and Non-seasonal Demand Patterns for Inventory Management’, J. Adv. Res. Nat. Appl. Sci., vol. 8, no. 4, pp. 753–761, 2022,

L. Xue, ‘Cluster analysis-based big data mining method of e-commerce consumer behaviour’, Int. J. Web Based Communities, vol. 19, no. 1, pp. 53–63, 2023, doi: 10.1504/IJWBC.2023.10048319.

Y. Hartati, S. Defit, and G. W. Nurcahyo, ‘Best Seed Clustering Using K-Means Algorithm in Increasing Sales’, J. Inform. Ekon. Bisnis, vol. 3, pp. 4–10, 2021.

W. Rosida and Y. A. Wijaya, ‘Clustering of HIV/AIDS Disease in West Java Using K-Means Clustering Algorithm’, Blend Sains J. Tek., vol. 1, no. 4, pp. 306–315, 2023.

M. I. Hutagalung and Sriani, ‘Grouping of ENT Disease Data Using K-Means Clustering Algorithm’, vol. 4, no. October, pp. 1568–1577, 2024.

G. Triyandana, L. A. Putri, and Y. Umaidah, Data Mining Application of Food and Beverage Menu Grouping Based on Sales Level Using the K-Means Method’, J. Appl. Informatics Comput., 2022, doi: 10.30871/jaic.v6i1.3824.

M. Dahria, R. Gunawan, and Z. Lubis, ‘Implementation of K-Means for the Best Product Grouping of PT. Koko Pelli’, Semin. Nas. Science and …, pp. 495–498, 2019, [Online].

A. R. Khorunisa and M. Fadilah, The Influence of Shopee Marketing Strategy on Consumer Shopping Behavior in Indonesia’, Civ. Off. Empir. Stud. Soc. Sci., vol. 3, no. 1, pp. 1–8, 2024, doi: 10.53754/civilofficium.v3i1.519.

W. Purba, W. Siawin, and . H., ‘Implementation of Data Mining for Grouping and Predicting Potentially Layoff Employees Using the K-Means Clustering Algorithm’, J. Sist. Inf. dan Ilmu Komput. Prima(JUSIKOM PRIMA), vol. 2, no. 2, pp. 85–90, 2019.

Idham, H. Rosika, and Yuliadi, CLOTHING USING THE K-MEANS METHOD In the digital era, technological developments are increasingly developing, especially sales data management is becoming increasingly crucial for businesses to understand consumer behavior, identify several groups or clusters that have', vol. 5, pp. 221–231, 2024.

A. S. Permana and R. Sanjaya, Application of Data Mining in Grouping Popular Grocery Items Using K-Means Clustering (Case Study: Gunung Bumi Store)’, J. Educator. Tambusai, vol. 7, no. 1, pp. 2419–2424, 2023.

S. Lestari, Muhatri, A. R. Fachrezi, M.Agung.Sutrisno, and M. Geovany, ‘Implementation of the K-Means Clustering Algorithm on Sales of Specs' Brand Futsal Shoes, vol. 2, no. 3, pp. 50–61, 2024.

I. F. Fauzi, M. Gito Resmi, and T. I. Hermanto, ‘Determining the Optimal Number of Clusters Using the Davies Bouldin Index in the K-Means Algorithm to Determine Disease Groups’, vol. 7, no. 2, pp. 2598–8069, 2023.

H. Syukron, M. Fauzi Fayyad, F. Junita Fauzan, Y. Ikhsani, and U. Rizkya Gurning, ‘Comparison of K-Means K-Medoids and Fuzzy C-Means for Customer Data Clustering with LRFM Model’, MALCOM Indones. J. Mach. Learn. Comput. Sci., vol. 2, no. 2, pp. 76–83, 2022.

D. Ananda, S. Rohimah, B. Susilo, D. Wulan, and A. Mustofa, ‘ Implementation of K-Means in Grouping Birth Certificate Data in Indonesia’, SENTIMAS Semin. Nas. Penelit. dan Pengabdi. Masy., pp. 66–71, 2022, [Online].

M. I. Sukirman, T. H. Pudjiantoro, I. Santikarama, J. Informatika, and F. Sains, ‘Sales Clustering of Clothing Line Products Using the K-Means Clustering Method for Implementing the Up-Selling Concept', pp. 56–62, 2021.