EUVIMEDEUVIMED entdecken
Open Access · CC BY-SA 4.0

Desain Dashboard Business Intelligence untuk Monitoring Kinerja Operasional Freight Forwarding Menggunakan Power Bi

Vanness Matthew Tjoeng, Darius Andana Haris, Meirista Wulandari

JURNAL PENELITIAN SISTEM INFORMASI (JPSI) · 31.05.2026 · 4 (2) · 471-489

DOI: 10.54066/jpsi.v4i2.4112 ↗

Kurz gefasst

Fachartikel in der Zeitschrift JURNAL PENELITIAN SISTEM INFORMASI (JPSI), online erschienen am 31.05.2026. Verfasst von Vanness Matthew Tjoeng und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This study aims to design a Business Intelligence dashboard to support operational performance monitoring in Freight Forwarding Project Cargo services at PT XYZ. The company currently relies on manual reporting processes by exporting operational data from SAP and Microsoft SharePoint into spreadsheet files, resulting in inefficiencies and difficulties in monitoring shipment activities. This research adopts the Data Warehouse Lifecycle methodology using The Nine Steps of Kimball approach. Operational data obtained from SAP and Microsoft SharePoint were processed through the Extract, Transform, Load (ETL) stages using Power Query and visualized using Microsoft Power BI Desktop. The resulting dashboard provides key performance indicators (KPIs), including Total Shipment, Delayed Shipment, Average Lead Time, Average Delay Time, and On-Time Shipment Percentage, along with supporting visualizations for operational analysis. The implementation results indicate that the dashboard is capable of integrating operational data into a centralized platform and presenting information interactively to support monitoring activities and operational decision-making. The developed dashboard is expected to improve reporting efficiency, enhance visibility of shipment performance, and support data-driven decision-making within the company.

Zitieren

APA

Tjoeng, V. M., Haris, D. A., & Wulandari, M. (2026). Desain Dashboard Business Intelligence untuk Monitoring Kinerja Operasional Freight Forwarding Menggunakan Power Bi. JURNAL PENELITIAN SISTEM INFORMASI (JPSI), 4(2), 471-489. https://doi.org/10.54066/jpsi.v4i2.4112

Vancouver

Tjoeng VM, Haris DA, Wulandari M. Desain Dashboard Business Intelligence untuk Monitoring Kinerja Operasional Freight Forwarding Menggunakan Power Bi. JURNAL PENELITIAN SISTEM INFORMASI (JPSI). 2026;4(2):471-489. doi:10.54066/jpsi.v4i2.4112

BibTeX
@article{Tjoeng2026,
  author = {Tjoeng, Vanness Matthew and Haris, Darius Andana and Wulandari, Meirista},
  title = {Desain Dashboard Business Intelligence untuk Monitoring Kinerja Operasional Freight Forwarding Menggunakan Power Bi},
  journal = {JURNAL PENELITIAN SISTEM INFORMASI (JPSI)},
  year = {2026},
  volume = {4},
  number = {2},
  pages = {471--489},
  doi = {10.54066/jpsi.v4i2.4112}
}
Kostenlos starten →