PENERAPAN TEKNOLOGI DATAWAREHOUSE NOSQL DAN BUSINESS INTELLIGENCE UNTUK ANALISA TRANSAKSI PENJUALAN

Authors

  • I Putu Susila Handika STMIK STIKOM Indonesia
  • Gede Bagus Arya Tama STMIK STIKOM Indonesia
  • Ni Putu Mega Krisnayanti STMIK STIKOM Indonesia

DOI:

https://doi.org/10.31598/jurnalresistor.v3i2.626

Keywords:

datawahouse, ETL, NoSql, mongoDB, business intelligence

Abstract

Business process are increasingly developing, causing data generated will be even greater. The application of datawarehouse technology and MongoDB as one of the NoSQL technologies can solve large historical data processing problems. In addition, business intelligence technology that is able to visualize data in into graphics and tables will make it easier for stakeholders to analyze sales transactions. The process for transforming transaction data into a datawarehouse is the Extract Transform Load (ETL) process. The data generated from the ETL process is quality data and is really needed for analysis. Black box testing results and data validity indicate the system can be accepted and can produce the right information for decision support.

Downloads

Download data is not yet available.

References

E. Triandini, M. S. Rijal, and M. P. Ambara, “Implementasi Star Schema Dalam Pembangunanan Data Warehouse Penjualan Produk Tour,” vol. 12, no. 1, pp. 23–33, Apr. 2020.

I. Putra, I. Mahendra, and I. M. Suwija Putra, “Implementasi ETL Data Warehouse Dengan Konsep Fitur Metadata Dan Cleansing Data Pada Toko Kue,” SISTEMASI, vol. 9, p. 274, 2020.

I. P. A. Eka Pratama and P. Agus, “Desain dan Implementasi Data warehouse Untuk Prediksi Penjualan Produk pada Toko Mekarsari,” J. Teknol. Inf. dan Terap., vol. 5, pp. 65–72, 2019.

F. A. Bhaswara, R. Sarno, and D. Sunaryono, “Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail,” J. Tek. ITS, vol. 6, pp. 10–14, 2017.

A. Dwiputra Wijaya and T. Gantini, “Analisis Forecasting dengan Implementasi Dashboard Business Intelligence Untuk Data Penjualan Pada PT. ‘X,’” Nov. 2019.

R. I. Borman and F. Helmi, “Penerapan Metode Perbandingan Eksponensial (MPE) Dalam Sistem Pendukung Keputusan Penerima Beasiswa Siswa Berprestasi Pada SMK XYZ,” Comput. Eng. Sci. Syst. J., vol. 3, no. 1, p. 17, Jan. 2018.

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. 4, no. 1, pp. 65–68, Oct. 2019.

E. K. Suni, “Analisis Dan Perancangan Data Warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine-Step Kimball,” J. Tek. Inform., vol. 11, no. 2, pp. 197–206, Nov. 2018.

M. Farozi, “Desain Basis Data Non Relasional Nosql Mongodb Pada Website Sistem Informasi Akademik,” J. Sist. Inf. Komput. dan Teknol. Inf., vol. 1, pp. 24–39, 2019.

A. Sabtu et al., “The challenges of Extract, Transform and Loading (ETL) system implementation for near real-time environment,” in International Conference on Research and Innovation in Information Systems, ICRIIS, 2017.

D. Sugiarto, H. L. H. S. Warnars, and W. Winarno, “Perancangan Data Warehouse Penjualan (Studi Kasus Pt. Subafood Pangan Jaya),” Semnas Ristek (Seminar Nas. Ris. dan Inov. Teknol. 2020, vol. 4, no. 1, Jan. 2020.

Y. Oslan and D. H. Kristanto, “Proses ETL (Extract Transformation Loading) Data Warehouse Untuk Peningkatan Kinerja Biodata Dalam Menyajikan Profil Mahasiwa Dari Dimensi Asal Sekolah Studi Kasus: Biodata Mahasiswa UKDW,” Res. FAIR UNISRI, vol. 3, no. 1, Jan. 2019.

R. Akbar, D. Rasyiddah, M. Anrisya, N. F. Julyazti, and S. Syaputri, “Penerapan Aplikasi Power Business Intelligence Dalam Menganalisis Prioritas Pekerjaan di Indonesia,” J. Edukasi dan Penelit. Inform., vol. 4, no. 1, p. 54, Jun. 2018.

T. S. Jaya, “Pengujian Aplikasi dengan Metode Blackbox Testing Boundary Value Analysis (Studi Kasus: Kantor Digital Politeknik Negeri Lampung),” J. Inform. Pengemb. IT, vol. 3, no. 2, pp. 45–46, Jan. 2018.

Rianto and C. Hadis, “Perancangan Data Warehouse Pada Rumah Sakit (Studi Kasus: BLUD RSU Kota Banjar),” J. Siliwangi, vol. 3, no. 2, pp. 214–221, 2017.

K. Mohammed, “Data Warehouse Design and Implementation Based on Star Schema vs. Snowflake Schema,” Int. J. Acad. Res. Bus. Soc. Sci., vol. 9, 2019.

G. Wijaya, “Perancangan Data Warehouse Nilai Mahasiswa Dengan Kimball Nine-Step Methodology,” J. Inform., vol. 4, pp. 1–11, 2017.

Downloads

Published

2020-10-28

How to Cite

Handika, I. P. S., Tama, G. B. A., & Krisnayanti, N. P. M. (2020). PENERAPAN TEKNOLOGI DATAWAREHOUSE NOSQL DAN BUSINESS INTELLIGENCE UNTUK ANALISA TRANSAKSI PENJUALAN. Jurnal RESISTOR (Rekayasa Sistem Komputer), 3(2), 120-127. https://doi.org/10.31598/jurnalresistor.v3i2.626

Issue

Vol. 3 No. 2 (2020): Jurnal RESISTOR Edisi Oktober 2020

Section

Articles

License

Copyright (c) 2020 I Putu Susila Handika, Gede Bagus Arya Tama, Ni Putu Mega Krisnayanti

Creative Commons License

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

Copyright in each article belongs to the author.

  1. The authors admit that RESISTOR Journal as a publisher who published the first time under   Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0) License.
  2. Authors can include writing separately, regulate distribution of non-ekskulif of manuscripts that have been published in this journal into another version (eg sent to respository institution author, publication into a book, etc.), by recognizing that the manuscripts have been published for the first time in RESISTOR Journal