Model business intelligence system design of quality products by using data mining in R Bakery Company

Abstract

R Bakery company is a company that produces bread every day. Products that produced in that company have many different types of bread. Products are made in the form of sweet bread and wheat bread which have different tastes for every types of bread. During the making process, there were defects in the products which the defective product turns into reject product. Types of defects that are produced include burnt, sodden bread and shapeless bread. To find out the information about the defects that have been produced then by applying a designed model business intelligence system to create database and data warehouse. By using model business Intelligence system, it will generate useful information such as how many defect that produced by each of the bakery products. To make it easier to obtain such information, it can be done by using data mining method which data that we get is deep explored. The method of data mining is using k-means clustering method. The results of this intelligence business model system are cluster 1 with little amount of defect, cluster 2 with medium amount of defect and cluster 3 with high amount of defect. From OLAP Cube method can be seen that the defect generated during the 7 months period of 96,744 pieces.