Business Intelligence for Product Defect Analysis

Annual Conference on Industrial and System Engineering 2019

工业技术（总论）

Girsang, A.S.^1 ; Isa, S.M.^1 ; Haris, A.L.^1 ; Arwan^1 ; Mandagie, K.^1 ; Ariana, L.R.^1 ; Ardinda, V.^1

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;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/598/1/012117/pdf
DOI  :  10.1088/1757-899X/598/1/012117

学科分类：工业工程学

来源: IOP

【 摘 要 】

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.