Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre

Wulan Stau Fana(1*), rini sovia(2), Randi Permana(3), Md Ataul Islam(4),


(1) Department Informatics Engineering , Faculty of Computer Science, University Putra Indonesia "YPTK" Padang, Indonesia
(2) Department Informatics Engineering , Faculty of Computer Science, University Putra Indonesia "YPTK" Padang, Indonesia
(3) Department Informatics Engineering , Faculty of Computer Science, University Putra Indonesia "YPTK" Padang, Indonesia
(4) Newton International Fellow, University of Manchester,
(*) Corresponding Author

Abstract


Data Warehouse is a technology use to analyze, extract and evaluate data into information which produce knownledge in the form of analysis to provide an advice in decision making process. Designing a Data Warehouse using ETL (Extract, Transformation and Load) process serves as the collection of data from different data sources into a multitude of integrated data sets. By using snowflake scheme for the design of the data warehouse make data prepare well and ready for analyze on Data Warehouse. The result of  this reseach is to applied Data Warehouse that use to support company decision making progress make easier and has a good decision since its come from Data Warehouse

Keywords


Data Warehouse ETL Snowflake scheme, Consultant, OLAP

Article Metrics

Abstract view : 149 times

References


References

A. Filiana, A. G. Prabawati, M. N. A. Rini, G. Virginia, and B. Susanto, “Perancangan Data Warehouse Perguruan Tinggi untuk Kinerja Penelitian dan Pengabdian kepada Masyarakat,” J. Tek. Inform. dan Sist. Inf., vol. 6, no. 2, pp. 174–183, 2020, doi: 10.28932/jutisi.v6i2.2557.

I. G. W. Darma, K. S. Utami, and N. W. S. Aryani, “Data Warehouse Analysis to Support UMKM Decisions using the Nine-step Kimball Method,” Int. J. Eng. Emerg. Technol., vol. 1, no. 1, pp. 65–68, 2019, [Online]. Available: https://ocs.unud.ac.id/index.php/ijeet/article/view/53633.

D. Subuh, D. Harsono, and R. Sulistiyowati, “Implementasi Business Intelligence Pada Aplikasi E-Tilang Dengan Menggunakan Tableau Server,” Semin. Nas. Geotik 2019, pp. 127–135, 2019.

A. Yulianto, S. D. Putra, and R. Haroen, “JISICOM ( Journal of Information System , Informatics and Computing ) Vol . 3 No . 2 Desember 2019 p-ISSN : 2579-5201 ( Printed ) JISICOM ( Journal of Information System , Informatics and Computing ),” vol. 3, no. 2, pp. 103–109, 2019.

A. Supriyatna, “Sistem Analisis Data Mahasiswa Menggunakan Aplikasi Online Analytical Processing (Olap) Data Warehouse,” Pilar Nusa Mandiri, vol. 12, no. 1, pp. 62–71, 2016.

G. Satyanarayana Reddy, R. Srinivasu, M. Poorna, C. Rao, and S. R. Rikkula, “Data Warehousing, Data Mining, Olap and Oltp Technologies Are Essential Elements To Support Decision-Making Process in Industries,” Int. J. Comput. Sci. Eng., vol. 02, no. 09, pp. 2865–2873, 2010.

I. N. A. Prabawa, D. Agung, K. Arimbawa, and I. G. N. Janardana, “Analysis and Design Data Warehouse For E-Travel Business Optimization,” Int. J. Eng. Emerg. Technol., vol. 4, no. 1, 2019.

Y. P. Sudarmojo, “Design of Library Data Warehouse Using OLTP Result of Services Analysis,” vol. 3, no. 1, pp. 62–65, 2018.

P. Widiadnyana, M. A. Maricar, I. N. Arnawan, and S. Ariyani, “Analysis of Data Warehouse for Transactional Analysis Methods Online Analytical Processing (OLAP) at Company XYZ Silver,” Int. J. Eng. Emerg. Technol., vol. 2, no. 1, p. 72, 2017, doi: 10.24843/ijeet.2017.v02.i01.p15.

D. Subuh and W. Yasman, “Implementasi Data Warehouse Dan Penerapannya Pada Toko Magnifique Clothes Dengan Menggunakan Tools Pentaho,” Pros. SENIATI, pp. 29–36, 2019.

L. M. da L. Brum, V. do N. Lampert, and S. da S. Camargo, “Business Intelligence and Data Warehouse in Agrarian Sector: A Bibliometric Study,” J. Agric. Sci., vol. 11, no. 2, p. 353, 2019, doi: 10.5539/jas.v11n2p353.

M. Hilman and D. Djamaludin, “Analisis Faktor Optimalisasi Proses Etl Pada Data Warehouse Sebagai Pendukung Pengambilan Keputusan Management Dengan Business Intelligence,” Fakt. Exacta, vol. 11, no. 1, p. 24, 2018, doi: 10.30998/faktorexacta.v11i1.2325.

S. M. N. Huda And J. Sutrisno, “Analisa Perancangan Data Warehouse Dan Aplikasi Online Analytical Processing Pengajuan Kredit Pada Pt Bfi Finance Indonesia Tbk,” Idealis Indones. J. Inf. Syst., Vol. 1, No. 3, Pp. 354–359, 2018.

T. Connolly And C. Begg, Database System : A Practical Approach To Design, Implementation, And Management. Fourth Edition, Fourth Edi. England, 2005.

K. Khotimah And Sriyanto, “Perancangan Dan Implementasi Data Warehouse Untuk Mendukung Sistem Akademik (Studi Kasus Pada Stkip Muhammadiyah Kotabumi),” J. Teknol. Inf. Magister, Vol. 2, No. 01, Pp. 94–107, 2017.

A. Supriyatna, “Sistem Analisis Data Mahasiswa Menggunakan Aplikasi Online Analytical Processing (Olap) Data Warehouse,” Pilar Nusa Mandiri, Vol. 12, No. 1, Pp. 62–71, 2016.

M. K. A. Ghani, M. M. Jaber, And N. Suryana, “Telemedicine Supported By Data Warehouse Architecture,” Arpn J. Eng. Appl. Sci, Vol. 10, No. 2, Pp. 415–417, 2015.

R. Permana, “Perancangan Data Mart Bagian Penjualan Motor Bekas ( Used Motor Cycle ) Pada Cv . Atlas Motor,” Vol. 3, No. 1, 2013.

Z. Nur And I. Mukhlash, “Implementasi Business Intelligence Pada Manajemen Report Bank Xyz,” J. Sains Dan Senni Pomits, Vol. 3, No. Bisnis Intelijen, Pp. 16–21, 2014.

D. Marlius, “Loyalitas Nasabah Bank Nagari Syariah Cabang Bukittinggi Dilihat Dari Kualitas Pelayanan,” J. Pundi, Vol. 1, No. 3, Pp. 237–250, 2018, Doi: 10.31575/Jp.V1i3.60.

A. R. Simon And T. C. Hammergren, Data Warehousing For Dummies. John Wiley & Sons, 2009.

I. P. A. E. Pratama, Handbook Data Warehouse : Teori Dan Praktik Berbasiskan Open Source, Informatik. Bandung, 2018.

Santoso, L. W., & Yulia. (2017). Data Warehouse with Big Data Technology for Higher Education. Procedia Computer Science, 124, 93–99. https://doi.org/10.1016/j.procs.2017.12.134

D. Nurmalasari, M. Sari, and P. Hanifah, “Analisis kinerja pemodelan data star schema pada data perpustakaan,” J. Komput. Terap., vol. 5, no. 2, pp. 44–53, 2019.

Q. Aini, U. Rahardja, A. Moeins, and A. M. Wardani, “Penerapan Data Market Query (DMQ) pada Sistem Penilaian Berbasis Yii Framework,” InfoTekJar (Jurnal Nas. Inform. dan Teknol. Jaringan), vol. 3, no. 1, pp. 26–31, 2018, doi: 10.30743/infotekjar.v3i1.565.

A. Utami, B. R. Pratama, and S. R. Widianto, “Data Mart Design in Bkpp Bandung Using From Enterprise Models To Dimensional Models Method,” JITK (Jurnal Ilmu Pengetah. dan Teknol. Komputer), vol. 5, no. 2, pp. 279–284, 2020, doi: 10.33480/jitk.v5i2.1219.

B. Sudradjat, “Analysis and Design of Data Mart Decision Support Systems at PT Marlindo Tirta Nusantara,” SinkrOn, vol. 3, no. 2, p. 133, 2019, doi: 10.33395/sinkron.v3i2.10062.

I. WARMAN and R. RAMDANIANSYAH, “ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1,” J. Teknoif, vol. 6, no. 1, pp. 32–41, 2018, doi: 10.21063/jtif.2018.v6.1.32-41.

A. Heryanto and A. Albert, “Implementasi Sistem Database Terdistribusi Dengan Metode Multi-Master Database Replication,” J. Media Inform. Budidarma, vol. 3, no. 1, p. 30, 2019, doi: 10.30865/mib.v3i1.1098.

A. Heryanto and A. Albert, “Implementasi Sistem Database Terdistribusi Dengan Metode Multi-Master Database Replication,” J. Media Inform. Budidarma, vol. 3, no. 1, p. 30, 2019, doi: 10.30865/mib.v3i1.1098.




DOI: https://doi.org/10.29099/ijair.v5i2.215

Copyright (c) 2021 International Journal of Artificial Intelligence Research

________________________________________________________

International Journal Of Artificial Intelligence Research

Organized by: Departemen Teknik Informatika STMIK Dharma Wacana
Published by: STMIK Dharma Wacana
Jl. Kenanga No.03 Mulyojati 16C Metro Barat Kota Metro Lampung
phone. +62725-7850671
Fax. +62725-7850671
Email: jurnal.ijair@gmail.com | herinurdiyanto@ieee.org 

View IJAIR Statcounter

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.