RANCANGAN DATA WAREHOUSE UNTUK ANALISIS KINERJA PRODUKSI DI PT. URECEL INDONESIA

PT. Urecel Indonesia engaged in the manufacturing and production of polyurethane foam. The business process of production is closely linked to the function of three divisions: marketing, purchasing, and production. The amount of data stored in each division and resulted in the accumulation of data. The data in the division has not integrated each other mutually. The leaders often have not get the information that he/she was needed to evaluate the performance of production. This is because the information is presented based on every division itsefl and using a different data source. This study discusses the design of the data warehouse to solve these problems. Research carried out by the System Development Life Cycle (SDLC). In other parts, the design of the data warehouse is done using a snowflake schema, while the extract, transform, and loading (ETL) performed on the data relating to production performance needs. The results of the ETL process is then stored in the data warehouse for analysis. Implemengtasi results and analysis carried out showed that the design of data warehouse generated in this study proved it can be used to measure the performance of the production of PT. Urecel Indonesia