Data Warehouse Modeling Using Online Analytical Processing Approach

Galih Budianto

doi:10.58602/jima-ilkom.v1i1.2

Galih Budianto STMIK Tasikmalaya

DOI: https://doi.org/10.58602/jima-ilkom.v1i1.2

Keywords: Analysis, Information, Online, OLAP, Technology

Abstract

Increasing business needs affect business competition in many companies that utilize information technology. The competition aims to gain advantages that utilize information technology in facilitating business processes. One of the conveniences offered is the use of information technology to support decision making in carrying out existing business processes in middle-to-upper scale companies that have large amounts of data. Online Analysis Processing (OLAP) is an approach method to present answers to the demand for a dimensional analysis process quickly, namely the design of applications and technologies that can collect, store, manipulate multidimensional data for analyst purposes. Information delivery generated from Online Analysis Processing (OLAP) can help executive information systems in generating sales reports because it has a response time of 0.0038769999519 seconds.

Downloads

Download data is not yet available.

References

R. Putra Setiawan, “Sistem Informasi Manajemen Presensi Siswa Berbasis Mobile Study Kasus Sma N 1 Sungkai Utara Lampung Utara,” J. Teknol. dan Sist. Inf., vol. 2, no. 3, pp. 119–124, 2021.
H. Sulistiani, M. Miswanto, D. Alita, and P. Dellia, “Pemanfaatan Analisis Biaya Dan Manfaat Dalam Perhitungan Kelayakan Investasi Teknologi Informasi,” Edutic-Scientific J. Informatics Educ., vol. 6, no. 2, 2020.
D. Subuh and W. Yasman, “Implementasi Data Warehouse Dan Penerapannya Pada Toko Magnifique Clothes Dengan Menggunakan Tools Pentaho,” Pros. SENIATI, pp. 29–36, 2019.
B. Santoso, “Perancangan aplikasi olap (online analitycal processing) penjualan buku pada toko buku gramedia lubuklinggau dengan metode clustering,” J. Teknol. Inf. MURA, vol. 9, no. 2, pp. 98–107, 2017.
A. Syam and A. R. Manga, “Sistem Tracer Study Alumni Fakultas Ilmu Komputer Universitas Muslim Indonesia Menggunakan Metode On-Line Analitycal Processing (OLAP),” Ilk. J. Ilm., vol. 9, no. 1, pp. 86–90, 2017.
M. A. A. Maulana, M. S.Kom, M.Kom., and W. Soeharso, “Analisis dan perancangan data warehouse evaluasi mahasiswa studi kasus pada jurusan Teknik Informatika UMM,” J. Repos., vol. 1, no. 1, p. 59, 2020, doi: 10.22219/repositor.v1i1.376.
M. Akbar and Y. Rahmanto, “Desain data warehouse penjualan menggunakan Nine Step Methodology untuk business intelegency pada PT Bangun Mitra Makmur,” J. Inform. dan Rekayasa Perangkat Lunak, vol. 1, no. 2, pp. 137–146, 2020.
S. Setiawansyah, H. Sulistiani, and V. H. Saputra, “Penerapan Codeigniter Dalam Pengembangan Sistem Pembelajaran Dalam Jaringan Di SMK 7 Bandar Lampung,” J. CoreIT J. Has. Penelit. Ilmu Komput. dan Teknol. Inf., vol. 6, no. 2, pp. 89–95, 2020.
F. Irvansyah, S. Setiawansyah, and M. Muhaqiqin, “Aplikasi Pemesanan Jasa Cukur Rambut Berbasis Android,” J. Ilm. Infrastruktur Teknol. Inf., vol. 1, no. 1, pp. 26–32, 2020.
S. Setiawansyah, Q. J. Adrian, and R. N. Devija, “Penerapan Sistem Informasi Administrasi Perpustakaan Menggunakan Model Desain User Experience,” J. Manaj. Inform., vol. 11, no. 1, pp. 24–36, 2021.