Customizing Business Intelligence (BI) System For Product Performance Analysis

Abstract

Business Intelligence (BI) is used to obtain the knowledge needed in decisions making process, so that appropriate decisions can be taken and able to transform business performance to be better. BI is growing rapidly up to the stage of development of pentaho. Pentaho is one of open source BI system which is widely used in real world business. Benefit Cost ratio (BCR) is the comparison value from profit value with cost value. Common problem of this research is to integrate the Benefit cost ratio value into data warehouse and customizing BI system to support decision making. The aim of this research is combining Benefit cost ratio each product into data warehouse and analyzing business condition by using pentaho in order to approaching efficiency, effective, accuracy in data information to embed business intelligence module in the investigated company. The result from Smart Dashboard at Saturday, 15 October 2011 have big Benefit Cost Ratio (BCR) value is 2,47 Milling N 50 Black with quantity 37 and Smart Report at Saturday, 15 October 2011 shown that total selling price product is Rp 36, 611,500 with total quantity 919 by 12 type of product. Keywords: BI, Pentaho, BCR (Benefit Cost Ratio), Dashboard, and Report