Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Penelitian Sistem Informasi
Vanness Matthew Tjoeng
Unknown Affiliation
Computer Science & IT Decision Sciences, Operations Research & Management

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

Found 1 Documents
Search

 1 
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) Vol. 4 No. 2 (2026): Mei: JURNAL PENELITIAN SISTEM INFORMASI
Publisher : Institut Teknologi dan Bisnis (ITB) Semarang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54066/jpsi.v4i2.4112

Abstract

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.
Co-Authors Darius Andana Haris Meirista Wulandari