Penerapan Dashboard Business Intelligence untuk Analisis Piutang Customer pada Perusahaan Manufaktur
JURNAL PENELITIAN SISTEM INFORMASI (JPSI) · 31.05.2026 · 4 (2) · 414-430
DOI: 10.54066/jpsi.v4i2.4074 ↗Kurz gefasst
Fachartikel in der Zeitschrift JURNAL PENELITIAN SISTEM INFORMASI (JPSI), online erschienen am 31.05.2026. Verfasst von Bintang Noviansyah Syamsu und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
Manual management of customer receivables in manufacturing companies often leads to inefficiencies, including slow analysis processes, difficulty in monitoring outstanding balances, and limited ability to track payment trends comprehensively. This study designed a Business Intelligence Dashboard using Microsoft Power BI to address these issues at PT. XX Industry, employing a Software Development Life Cycle (SDLC) approach consisting of four stages: Planning, Analysis, Design, and Implementation. During the design phase, a data warehouse was built using a star schema model in SQL Server Management Studio, followed by an Extract, Transform, Load (ETL) process to ensure data accuracy and consistency prior to integration into Power BI. Five Key Performance Indicators (KPIs) were established collaboratively with company management through a series of online discussions, comprising Total Invoice, Total Payment, Total Receivables, Payment Rate, and Average Payment Time, all implemented using DAX expressions. The resulting dashboard features monthly trend visualizations, customer-based receivables distribution, and interactive filter capabilities. System testing confirmed that all components functioned correctly, while ETL validation verified consistency between processed and source data. User Acceptance Testing (UAT) conducted by management yielded an average score of 4.7 out of 5, reflecting a very high level of user acceptance. Overall, this dashboard proved effective in improving receivables monitoring efficiency and supporting faster, data-driven decision-making.
Zitieren
APA
Syamsu, B. N., Trisnawarman, D., & Budiyantara, A. (2026). Penerapan Dashboard Business Intelligence untuk Analisis Piutang Customer pada Perusahaan Manufaktur. JURNAL PENELITIAN SISTEM INFORMASI (JPSI), 4(2), 414-430. https://doi.org/10.54066/jpsi.v4i2.4074
Vancouver
Syamsu BN, Trisnawarman D, Budiyantara A. Penerapan Dashboard Business Intelligence untuk Analisis Piutang Customer pada Perusahaan Manufaktur. JURNAL PENELITIAN SISTEM INFORMASI (JPSI). 2026;4(2):414-430. doi:10.54066/jpsi.v4i2.4074
BibTeX
@article{Syamsu2026,
author = {Syamsu, Bintang Noviansyah and Trisnawarman, Dedi and Budiyantara, Agus},
title = {Penerapan Dashboard Business Intelligence untuk Analisis Piutang Customer pada Perusahaan Manufaktur},
journal = {JURNAL PENELITIAN SISTEM INFORMASI (JPSI)},
year = {2026},
volume = {4},
number = {2},
pages = {414--430},
doi = {10.54066/jpsi.v4i2.4074}
}
EUVIMED