Muhammad Rizky Kurniawan
Institut Widya Pratama, Indonesia

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

Found 1 Documents
Search

Implementasi Business Intelligence Pada Produk Insight Untuk Analisis Data Penjualan Di XYZ KOPI Muhammad Rizky Kurniawan; Tri Agus Setiawan; Ichwan Kurniawan
Jurasik (Jurnal Riset Sistem Informasi dan Teknik Informatika) Vol 11, No 2 (2026): Edisi Agustus
Publisher : STIKOM Tunas Bangsa Pematangsiantar

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30645/jurasik.v11i2.963

Abstract

The intense competition in the coffee shop industry requires MSMEs like XYZ Kopi in Batang to optimally utilize transaction data. The sales data from October to December 2025 currently remains as static summaries in Microsoft Excel. Managerial decisions relying on intuition pose a risk of inefficiencies in marketing and stock management. This study aims to implement Business Intelligence (BI) using the CRISP-DM framework and Google Looker Studio to design an interactive, real-time dashboard. The novelty of this research is the integration of the Menu Engineering method to classify products into four quadrants (Stars, Plowhorses, Puzzles, Dogs) based on popularity and profitability. The integration of BI and Menu Engineering serves as a strategic solution that provides an objective foundation for management. This data-driven decision-making process is proven to optimize menu placement, pricing, and promotions while reducing raw material waste to maximize MSME profitability in the digital era.