Implementasi Business Intelligence Pada Produk Insight Untuk Analisis Data Penjualan Di XYZ KOPI

Abstrak

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.