SELF-SERVICE BUSINESS INTELLIGENCE AS A DECISION-MAKING SUPPORT TO MINIMIZE STOCKOUT AT RY MART MINIMARKET

Yaqub Kasuma  Rosyid; Muhammad Ridwan  Andi Purnomo

doi:10.53067/ijomral.v4i3.325

Authors

Yaqub Kasuma Rosyid Islamic University of Indonesia
Muhammad Ridwan Andi Purnomo Islamic University of Indonesia

DOI:

https://doi.org/10.53067/ijomral.v4i3.325

Keywords:

Stockout, Self-Service Business Intelligence, Dashboard

Abstract

Some of the problems found in this study include : (1) Stockout happens at RY Mart 1 and RY Mart 2 (2) Inappropriate decision-making because it is not based on data and in-depth analysis. This study aims to minimize stockout based on data and in-depth analysis using Self Service business intelligence at RY Mart.

The research method used in this study is Nine Step Kimbal with Online Analytical Processing (OLAP). The data obtained from 2023-2025 transaction record of RY Mart 1 and RY Mart 2.

The result of this study is Stockout Dashboard and order planning for RY Mart. The Dashboard shows that the amount of stockout influenced by the increase of sales because of holiday and demography around the mart. Only in RY Mart 1 stockout of Ice Cream happens and the amount of Cigarette and Beverage stockout is greater at RY Mart 2 than RY Mart 1. Safety Stock, Minimum stock, and Minimum Order Quantity are calculated to minimize the stockout.

Downloads

Download data is not yet available.

References

Badan Pusat Statistik Kota Metro. (2023). Kota Metro Dalam Angka 2023. Metro, Lampung: BPS Kota Metro.

Daradkeh, M., & Al-Dwairi, R. M. (2017). Self-Service Business Intelligence Adoption in Business Enterprise : The Effects of Information Quality, System Quality, and Analysis Quality. International Journal of Enterprise Information System, 65-85.

Elena, C. (2011). Business Intelligence. Journal of Knowledge Management, Economics and Information Technology, 1-12.

Herianti, Siradjuddin, & Efendi, A. (2023). Industri Halal Dari Perspektif Potensi Dan Perkembangannya Di Indonesia. Indonesia Journal of Halal, 56-64.

Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2011). The Data Warehouse Lifecycle Toolkit : Edition 2. John Wiley & Sons.

Kumari, N. (2013). Business Intelligence In A Nutshell. International Journal of Innovative Research in Computer and Communication Engineering, 969-975.

Laudon, & Traver. (2016). Electronic Commerce 2016: Business. Technology. Society (12th Edition). Boston: Pearson Education Inc., 26-36.

Watson, H., & Wixom, B. (2007). The Current State of Business Intelligence. Computer, 96-99.

Zdravevski, Lameski, Apanowicz, & Slezak. (2020). From Big Data to business analytics: The case study of churn prediction. Applied Soft Computing Journal, 90.