RANCANGAN DATA WAREHOUSE UNTUK ANALISIS KINERJA PRODUKSI DI PT. URECEL INDONESIA
Keywords:
data warehouse, analysis of the performance
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 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.
References
[1] A. Silbershatz, H.F. Korth, S. Sudarshan, Database System Concepts, 6th ed., New York: McGrow Hill, 2011.
[2] Henderi, “Strategi Membangun Sistem Komputerisasi,” Jurnal Cyber Raharja, vol. 3 no. 2, pp.13-34, 2005.
[3] Husni, Hari Setiabudi,. “Evaluasi Sistem Informasi Penggajian pada PT. XYZ,” CommIT, vol.1, no. 1. Pp. 129-137, 2010.
[4] Rubhasy Albaar, A. Hasibuan Zainal, “Pemanfaatan Business Intelligence Dalam Perencanaan Pembangunan Nasional : Studi Kasus Badan Perencanaan Pembangunan Nasional,” Prosiding. KNSI STIKOM Bali, pp. 20, 2012
[5] Connolly, Thomas, C. B. 2010, DatabaseSystem : A Practical Approach to Design, Implementation, and Management, Fifth Edition : Pearson Education Inc.
[6] Gunawan, Ridowati. Implementasi Tabel Agregat Untuk Meningkatkan Unjuk Kerja Model Basis
[2] Henderi, “Strategi Membangun Sistem Komputerisasi,” Jurnal Cyber Raharja, vol. 3 no. 2, pp.13-34, 2005.
[3] Husni, Hari Setiabudi,. “Evaluasi Sistem Informasi Penggajian pada PT. XYZ,” CommIT, vol.1, no. 1. Pp. 129-137, 2010.
[4] Rubhasy Albaar, A. Hasibuan Zainal, “Pemanfaatan Business Intelligence Dalam Perencanaan Pembangunan Nasional : Studi Kasus Badan Perencanaan Pembangunan Nasional,” Prosiding. KNSI STIKOM Bali, pp. 20, 2012
[5] Connolly, Thomas, C. B. 2010, DatabaseSystem : A Practical Approach to Design, Implementation, and Management, Fifth Edition : Pearson Education Inc.
[6] Gunawan, Ridowati. Implementasi Tabel Agregat Untuk Meningkatkan Unjuk Kerja Model Basis
