Business Intelligence for Product Defect Analysis

[摘要] 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.

[发布机构] Computer Science Department, BINUS Graduate Program-Master of Computer Science, Bina Nusantara University, Jakarta; 11480, Indonesia^1

[学科分类] 工业工程学

[关键词] Data warehouse development;Product defect analysis;Reporting service