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

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.