Implementasi Dashboard Business Intelligence Penjualan dan Optimasi Stok pada Japri Coffee
Keywords:
Business Intelligence, Dashboard, Forecasting, Food Waste, Stock OptimizationAbstract
Japri Coffee Kertamukti is a culinary business with high daily transaction volumes, yet it continues to encounter challenges in integrating operational data from point-of-sale applications, CSV files, and manual stock records. These integration issues result in stock inconsistencies and elevated levels of food waste in raw materials. This study focuses on developing a Business Intelligence dashboard to unify operational data and deliver real-time analysis of sales performance and stock management. The research employs the Data Analytics Lifecycle combined with a prototype development model, encompassing requirements analysis, data flow design, dashboard visualization, and the implementation of forecasting and reporting features.
References
R. Wikamulia and M. Isa, “Predictive BI Dashboard for Food and Beverage Business,” Journal of Business Intelligence, vol. 5, no. 2, pp. 45–53, 2023.
J. Nilivaara, “Business Analytics and Power BI in Managing a Café Chain,” International Journal of Data Analytics, vol. 8, no. 1, pp. 12–20, 2024.
F. Az-Zahra et al., “Sales Data Visualization Using Power BI to Support Business Insight,” Journal of Information Systems, vol. 10, no. 1, pp. 30–39, 2025.
A. Nurdin et al., “Utilization of Business Intelligence in Sales Information Systems,” Journal of Informatics and Technology, vol. 7, no. 3, pp. 55–64, 2023.
G. Antunes et al., “Incorporation of Ontologies in DW/BI Systems,” International Journal of Data Warehouse and Business Intelligence, vol. 9, no. 2, pp. 22–31, 2022.
R. Das et al., “The Role of Data Visualization in Business Intelligence Adoption & Outcomes Analysis,” Journal of Data Science and Analytics, vol. 6, no. 1, pp. 15–24, 2022.
M. Sharif et al., “Improving Drilled-Down Information Extraction Online Data Visualization,” International Journal of Information Visualization, vol. 11, no. 2, pp. 40–49, 2023.
N. Aini et al., “The Effects of Sales Reports BI on Employee Performance,” Journal of Business Information Systems, vol. 4, no. 2, pp. 50–58, 2020.
S. Anisah and B. Wasesa, “Machine Learning Analytics for Predicting Customer Engagement,” Journal of Artificial Intelligence and Business Analytics, vol. 3, no. 1, pp. 60–69, 2025.
H. Sorour and P. Atkins, “Monitoring Quality Using Business Intelligence Dashboards,” International Journal of Dashboard Analytics, vol. 8, no. 3, pp. 70–79, 2024.
A. R. Sipayung, “Penerapan Teknologi Business Intelligence pada Dashboard Penjualan Coffee Shop Menggunakan OLAP,” Jurnal Teknologi Informasi dan Komputer, vol. 7, no. 2, pp. 101–110, 2024.
D. Deni and A. Voutama, “Perancangan Visualisasi Data Penjualan Coffee Shop Berbasis Power BI,” JITET: Jurnal Informatika dan Teknik Elektro Terapan, vol. 13, no. 3, pp. 1628–1638, 2025.
P. Azarya, “Perancangan Dashboard Penjualan Produk Biji Kopi Menggunakan Metode Waterfall,” Computatio: Journal of Computer Science and Information Systems, vol. 8, no. 2, pp. 254-260, 2024.
M. Amanda, “Visualisasi Data pada Coffee Shop Marble Menggunakan Dashboard Business Intelligence,” Jurnal Teknofile, vol. 5, no. 1, pp. 33–42, 2024.
M. A. Ruansyah et al., “Designing an Analytics Dashboard for Knowledge Management and Predictive Insights,” Journal of Information System Studies, vol. 9, no. 2, pp. 245–251, 2024.
