The Development of Industrial Fuel Sales Dashboard with Microsoft Power Business Intelligence in Corporate Sales Function PT Pertamina Patra Niaga Jatimbalinus

Abstract

This research aims to develop daily reporting features in the sales dashboard using Microsoft Power BI,
expanding upon the previous dashboard features, which consisted of monthly and annual reports. This study employed the
action research method. Data collection was carried out by distributing questionnaires to measure the effectiveness of the daily
reporting dashboard, using User Acceptance Testing (UAT) based on the ISO 9126 dimensions. The results of this research
indicated that all UAT indicators (functionality, reliability, usability, and efficiency) were rated as very good. This suggests
that the developed daily reports are highly effective in supporting management in making daily sales business decisions. It is
expected that the daily reporting features, which consist of the daily MOPS report, daily sales volume, and daily forecasting
per plant, can be utilized to monitor the company’s real time daily industrial fuel sales data, improve the management team’s
key performance indicators, and enhance customer service excellence.