Work

Business Intelligence System Design Based on Performance Monitoring Dashboard Using Online Analytical Processing (OLAP) Method

Year: 2024

Type: article

Abstract: A key performance indicator (KPI) is one of the factors for measuring performance improvement at PT. XYZ is an FMCG company in achieving its main business goals. Performance report data management system at PT. XYZ is still not optimal, because it is not integrated, experiences repeated data input, and requires visualization media for monitoring KPI daily meeting level 2 management assembly area. Therefore, a business intelligence system based on performance monitoring dashboard was created for integration, visualization and analysis of KPI data. This research uses a business intelligence roadmap approach without the deployment stage and data analysis using the OLAP method which is assisted by spreadsheet, power query, and power pivot tools. The dashboard functionality was then tested using the black box method. Based on the results of the evaluation and black box test, it can be concluded that the operations of the OLAP method on the performance monitoring dashboard, namely pivot, slice, dice, drill down, and roll up are in accordance with their function, run well, and are suitable for use. The resulting visualization helps the monitoring process performance and makes it easier to analyze KPI so that necessary follow-up actions can be executed quickly.

Source: Jurnal Ilmiah Teknik Industri

DOI: 10.23917/jiti.v23i02.6016

Authors: Neng Rizqi Ni'mah, Aisyah Larasati, Chandra Nurul Laksana, Effendi Mohamad

Institutions: State University of Malang, Universiti Teknikal Malaysia Melaka

Language: English

Topic: Big Data and Business Intelligence

Subfield: Management Information Systems

Field: Business, Management and Accounting

Domain: Social Sciences

Open Access status: gold

Estimated APC paid: $65

Funder: Universitas Negeri Malang