Minimarket Sales Optimization: Implementation of  FP-Growth dan MongoDB  With Python

This study applies an integrated FP-Growth algorithm with MongoDB and Python to analyze 150,000 minimarket transaction records over a one-year period. The dataset includes transaction numbers, product names, quantities sold, transaction dates, purchase prices, and selling prices. The parameters of a minimum support of 0.001, a confidence of 0.01, and a lift above 1.0 are used to ensure relevant association rules. The analysis indicates that the discovered product association patterns can increase operational efficiency by up to 15%, particularly in instant food and ready-to-drink beverage categories. These data-driven strategies also boost sales volume by 12.3% and reduce dead stock by 8.7%. Beras MCS 5KG stands out as the most profitable product, with a margin of IDR 1,066,724,400. The main strength of this study lies in the integration of FP-Growth with MongoDB, enabling large-scale real-time analysis without generating candidate itemsets. This approach enhances data processing efficiency, allowing minimarkets to optimise inventory and promotional strategies more accurately.

Authors

Publication Details

Journal
INOVTEK Polbeng - Seri Informatika
Published
2025-03-20
DOI
https://doi.org/10.35314/2qh79f26
Primary Topic
Decision Support System Applications
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Minimarket Sales Optimization: Implementation of  FP-Growth dan MongoDB  With Python

Nia Kurniati, Novi Rukhviyanti
INOVTEK Polbeng - Seri Informatika
Decision Support System Applications
article

Minimarket Sales Optimization: Implementation of  FP-Growth dan MongoDB  With Python

Nia Kurniati, Novi Rukhviyanti
article en

Abstract

This study applies an integrated FP-Growth algorithm with MongoDB and Python to analyze 150,000 minimarket transaction records over a one-year period. The dataset includes transaction numbers, product names, quantities sold, transaction dates, purchase prices, and selling prices. The parameters of a minimum support of 0.001, a confidence of 0.01, and a lift above 1.0 are used to ensure relevant association rules. The analysis indicates that the discovered product association patterns can increase operational efficiency by up to 15%, particularly in instant food and ready-to-drink beverage categories. These data-driven strategies also boost sales volume by 12.3% and reduce dead stock by 8.7%. Beras MCS 5KG stands out as the most profitable product, with a margin of IDR 1,066,724,400. The main strength of this study lies in the integration of FP-Growth with MongoDB, enabling large-scale real-time analysis without generating candidate itemsets. This approach enhances data processing efficiency, allowing minimarkets to optimise inventory and promotional strategies more accurately.

INOVTEK Polbeng - Seri InformatikaVol. 10(1)
Openalex Percentile: Top 93%
Decision Support System Applications
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.