Perancangan datawarehouse dan teknologi business intelligence untuk analisa penjualan pada perusahaan retail PT. ABC

  • I Putu Susila Handika STIMIK STIKOM Indonesia
  • Putu Praba Santika STIMIK STIKOM Indonesia

Abstract

PT. ABC is one of the retail industries. PT. ABC already has 378 stores spread across Bali, Lombok, and Makassar. Curently PT. ABC has a POS cashier system and warehouse management system to help run its business processes. The problem that often occurs is when the data is more and more, the process of data analysis becomes less optimal because the data is processed very much and to many users who use the system. Thus datawarehouse and business intelligence technology are needed to process data and visualize data into information that can be easily analyzed by stakeholders. Datawarehouse modeling method used in this study is the nine steps kimball method, for ETL process tools are used from Pentaho data integration, and the data visualization process is used power business intelligence tools to be able to display data in graphical form so that stakeholders can analyze data quickly and easily. The application of data warehouses and business intelligence technology can be used and produce information that matches the needs obtained in the analysis of functional requirements. This is evidenced by the results of black box testing that has been received by all stakeholders of PT. ABC.

References

W. N. Setyo and S. Wardhana, “Implementasi Data Mining Pada Penjualan Produk Di CV Cahaya Setya Menggunakan Algoritma FP-Growth,” PETIR, vol. 12, no. 1, pp. 54–63, Apr. 2019.

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.

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

L. Setiyani and A. Gintings, “Analisis Kebutuhan Fungsional Sistem Informasi Pengelolaan Skripsi,” Simp. Nas. Ilm. Call Pap. Unindra, vol. 0, no. 0, 2019.

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.

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.

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.

R. T. Yunandar, A. Amir, and K. Rizal, “Perancangan Data Warehouse Untuk Informasi Strategi Studi Kasus Penerimaan Siswa Baru STIE Binaniaga Bogor,” J. Tek. Komput., vol. 6, no. 1, pp. 111–120, Jan. 2020.

V. Novreza, Y. Munarko, and L. Husniah, “Data Warehouse Menggunakan Snowflake Schema Pada Virtual Shop,” J. Repos., vol. 2, no. 1, pp. 67–78, Jan. 2020.

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

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.

Published
2020-07-20
How to Cite
Handika, I. P., & Santika, P. (2020). Perancangan datawarehouse dan teknologi business intelligence untuk analisa penjualan pada perusahaan retail PT. ABC. Rabit : Jurnal Teknologi Dan Sistem Informasi Univrab, 5(2), 76-85. https://doi.org/10.36341/rabit.v5i2.1309
Section
Articles
PDF (Bahasa Indonesia)
Abstract views: 209
downloads: 128