Rika Astuti
Universitas Siber Indonesia, Jakarta, Indonesia

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

Found 1 Documents
Search

Implementasi Business Intelligence Dashboard Melalui Integrasi API Loyverse POS untuk Optimalisasi Rekonsiliasi Keuangan UMKM (Studi Kasus: Traktir Kopi) Dedi Dwi Saputra; Dicky Hariyanto; Windu Gata; Rizki Hesananda; Diky Wardhani; Rika Astuti
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.958

Abstract

This study discusses the development of a real-time Business Intelligence (BI) dashboard called T-KODE (Traktir Kopi Operational Dashboard Engine) for MSMEs in the Food and Beverage sector, specifically at Traktir Kopi Jagakarsa, South Jakarta. The system was developed to address issues in manual transaction recording and cash reconciliation processes that often cause inefficiency, human error, delayed audits, and limited access to real-time business information. T-KODE integrates with the Loyverse POS API to automatically retrieve transaction data and provide features such as cash reconciliation, sales visualization, product contribution analysis, peak hour monitoring, risk transaction detection, and audit report generation. The system was developed using the Waterfall method and implemented with Python, Gradio, Plotly, and Pandas. Based on Black Box Testing results, all system features functioned properly according to requirements. The implementation of T-KODE improved the efficiency, accuracy, and transparency of financial auditing processes. This study can serve as a reference for the digital transformation of similar MSMEs in Indonesia