Open AccessBusiness Intelligence for Product Defect Analysis
Author(s) -
Abba Suganda Girsang,
Sani Muhamad Isa,
Abd. Haris,
Arwan,
K. Mandagie,
Lutfah Ariana,
V. Ardinda
Publication year - 2019
Publication title -
iop conference series. materials science and engineering
Language(s) - English
Resource type - Journals
eISSN - 1757-899X
pISSN - 1757-8981
DOI - 10.1088/1757-899x/598/1/012117
Subject(s) - data warehouse , online analytical processing , oracle , computer science , database , business intelligence , audit , oracle database , table (database) , product (mathematics) , service (business) , quality (philosophy) , data mining , software engineering , business , philosophy , geometry , mathematics , accounting , epistemology , marketing
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.