Business Intelligence for Analyzing Department Unit Performance in eProcurement System

Abstract

Reporting using query script mostly takes the long process. It makes the company is too late to provide the strategy decision. This also results inefficient way because the updating and changing SQL query to be adjusted for matching the requirements of decision makers. So, this paper describes how to implement the data warehouse technology to create the fastest way to make a report based on the requirements without customize the SQL query and just read the required data only. With Kimball methodology, data could be reported in various forms and the decision makers could take the best decision in eProcurement System.