Business Intelligence for Product Defect Analysis

Abstract

The problem of reporting service in PT.XYZ is the complexity of the query to take the data from the table in oracle. There are many table to be processed for the data, because of that it's hard to show the report quickly. PT XYZ needs fast and reliable report to be shown, especially for control or audit. The suggested solution is to use data warehouse, because it has more structured storage and the data can be analysed by OLAP analysis that has the capability to show the data quickly. Data warehouse development was done through nine step that has been designed by Kimball and Ross. With this solution, PT XYZ has the capability to maintain quality of the product by monitoring the process and the data.