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

<div align="center"><img width="150" height="230" style="margin:0px" src="https://lh3.googleusercontent.com/-lVRVCLJkBuw/WR0O6uMwPhI/AAAAAAAAD6A/fTOZ1f_Ry5U2gta_cZKhUDBhhqwcoSc6wCL0B/w530-d-h755-p-rw/semnasaptikom.png"/></div>

Henderi 1), Bayu Pramono 2), Khanna Tiara 3), Ahmad Roihan 4)

1) Program Studi Teknik Informatika STMIK Raharja
2,3,4)Program Studi Magister Teknik Informatika STMIK Raharja
Jl. Jenderal Sudirman No. 40 Modern Cikokol Tangerang Telp. (021) 5529692

henderi@raharja.info 1), bayupramono@raharja.info 2), khana.tiara@raharja.info 3), ahmad.roihan@raharja.info 4)

Abstract

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 it self 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. Implementation 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.

Key word: data warehouse, analysis of the performance

.....[https://drive.google.com/file/d/0B6ZrtkXmyPWYTXJVTWtSODZ0TVE/preview Selengkapnya link pdf]