Analisis Kinerja Penjualan Menggunakan Business Intelligence Berbasis KPI (Studi Kasus: Yarage Coffee House)
Abstract
Yarage Coffee House has implemented a Point of Sale (POS) system to record sales transactions; however, the generated data has not been optimally utilized as an information source to support analysis and business decision-making. Sales data is still presented in the form of simple reports, making it difficult to monitor overall sales performance. This study aims to analyze sales performance using a Business Intelligence approach based on Key Performance Indicators (KPI) with supporting Pareto ABC analysis. The research was conducted through the stages of data collection, KPI Modeling, Extract, Transform, Load (ETL) process, data analysis, and result interpretation. KPI determination was based on information needs obtained through interviews and validated using the SMART method. The results show that the implementation of KPI-based Business Intelligence was able to transform transaction data into more structured and informative information presented through an interactive dashboard using Tableau. The analysis results indicate total revenue of IDR 38,770,000 with a total of 1,238 transactions. Pareto ABC analysis shows that Category A contributed a cumulative 77% of total revenue, thereby supporting more effective and data-driven business decision-making.
Downloads
References
S. Angreini and E. Supratman, “Visualisasi Data Lokasi Rawan Bencana Di Provinsi Sumatera Selatan Menggunakan Tableau,” J. Nas. Ilmu Komput., vol. 2, no. 2, pp. 135–147, 2021, doi: 10.47747/jurnalnik.v2i2.528.
M. Rohid, N. Fajrian, G. Ahmad, N. Vroticca, and A. Rifki, “Penerapan Dashboard Business Intelligence untuk Meningkatkan Penjualan Mobil : Studi Kasus pada Perusahaan XYZ,” 2025.
L. Aditya and J. Arifin, “Pengendalian Persediaan Bahan Baku Berdasarkan Klasifikasi ABC dan Model Q,” STRING (Satuan Tulisan Ris. dan Inov. Teknol., vol. 8, no. 1, p. 10, 2023, doi: 10.30998/string.v8i1.16077.
K. Senduk, R. Waluyo, and K. N. Isnaini, “Analisis Data dengan Business Intelligence dan Tableau untuk Visualisasi Garis Kemiskinan Indonesia Data Analysis using Business Intelligence and Tableau for Visualizing Indonesia ’ s Poverty Line,” vol. 14, pp. 1122–1141, 2025.
M. R. A. Hafzhian Abrar, “MPLEMENTASI BUSINESS INTELLIGENCE UNTUK OPTIMALISASI KINERJA BISNIS MELALUI VISUALISASI DATA PENJUALAN TOKO SEPATU MENGGUNAKAN MICROSOFT POWER BI,” vol. 3, no. 11, pp. 831–836, 2025.
E. I. Rizki, A. A. Safitri, Y. Servanda, and T. Sudinugraha, “Analisis dan Visualisasi Data Penjualan Menggunakan Tableau untuk Mendukung Keputusan Strategis ( Studi Kasus : PT Aspirasi Hidup Indonesia Tbk ),” vol. 3, no. 2, pp. 61–71, 2025.
F. A. Valensyah and O. Irnawati, “Sistem Informasi Berbasis Website Menggunakan Framework Laravel,” vol. 5, no. 1, pp. 7–14, 2024.
R. Wijanarko, A. S. Pangestuti, U. W. Hasyim, and S. P. Pendidikan, “Sistem Informasi Pembayaran SPP Berbasis WEB pada SMK Muhammadiyah 11 Jakarta Pusat,” vol. 3, no. 2, pp. 110–117, 2021.
M. D. Haq, Y. Dian, and P. L. P. I. K. Padang, “Perancangan Aplikasi Pencatatan Penjualan Berbasis Web Dengan Fitur Analisis Penjualan Pada Toko Fadhil Elektronik,” vol. 4, no. 3, 2024.
S. N. Mukhlis Ramadhan, Masyuni Hutasuhut, Rini Kustini, Zulkifli Lubis, “Implementasi Data Mining Menganalisa Pola Penjualan Barang,” vol. 22, pp. 328–337, 2023.
P. Ra and R. Imanda, “Optimasi Pengambilan Keputusan Perusahaan Freight Forwarder Pendahuluan Tahap Persiapan Data Metode Penelitian,” vol. 23, no. September, pp. 301–310, 2024.
N. J. P. Dany Setiawan, Dedi Trisnawarman, “Dashboard BI untuk Visualisasi Harga Bahan Pokok Provinsi Jawa Barat,” vol. 5, no. 3, pp. 564–569, 2025.
Sudaryanto, “Peran KPI Dalam Mendorong Kinerja Karyawan Dan Produktivitas Organisasi,” vol. 1, no. 2, pp. 61–72, 2024.
A. Putri, A. A. Adhisti, and I. R. Putri, “Pengembangan Dashboard Interaktif Saham LQ45 Menggunakan Pendekatan Business Intelligence Berbasis Tableau,” vol. 12, no. 02, 2025.
D. Lady and Y. Handoyo, “EFFECTIVENESS OF PARETO ( ABC ) ANALYSIS IN PHARMACEUTICAL INVENTORY PLANNING AT COMMUNITY PHARMACIES : A NARRATIVE REVIEW,” vol. 4, no. 2, pp. 107–118, 2025.
H. N. Azalia, A. A. Ridha, U. S. Karawang, and T. Timur, “ANALISIS TREN DAN FORECASTING KUNJUNGAN OPTIMALISASI MANAJEMEN LAYANAN KESEHATAN,” vol. 14, no. 2, 2026.
M. Rizqy and E. P. Silmina, “Perancangan dan Implementasi Dashboard Berbasis Web untuk Meningkatkan Transparansi dan Pengawasan Kinerja Menggunakan Metode Waterfall,” vol. 5, no. 1, pp. 54–61, 2025.
P. Afikah, A. Avorizano, I. R. Afandi, and F. N. Hasan, “Implementasi Business Intelligence untuk Menganalisis Data Kasus Virus Corona Menggunakan .9.,” vol. 9, 2022.
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
