ANALYSIS AND DESIGN OF DATA WAREHOUSE AND DATA MART BUDGET

Hendra Maryanto, Bambang Purnomosidi Dwi Putranto, Rikie Kartadie, Muhammad Guntara, Robertus Saptoto

Abstract


University as higher education institutions must be able to manage budgets properly. The budget is a future financial plan which includes the expectations of university management. This research will design a data warehouse, which is a place where data can be stored on a large scale. In this research, a data warehouse will be designed as a place to store budget data. The method applied in this study is the Kimball method with a nine-step methodology. The result of this research is a data warehouse design and budget data mart

Full Text:

PDF

References


S. S. . Sumendap, R. A. M. Koleangan, and T. O. Rotinsulu, “Strategi Pengelolaan Keuangan Universtias Sam Ratulangi Manado di Era Badan Layanan Umum,” J. Pembang. Ekon. Dan Keuang. Drh., vol. 20, no. 2, pp. 1–14, 2019, doi: 10.35794/jpekd.23844.20.2.2019.

R. Khoirul Anwar and T. Listyorini, “Rancang Bangun Aplikasi E - Budgeting Untuk Mengontrol Anggaran Pendapatan dan Belanja Universitas Muria Kudus Berbasis Web (Studi Kasus Fakultas Teknik Unviersitas Muria Kudus),” Simetris J. Tek. Mesin, Elektro dan Ilmu Komput., vol. 9, no. 2, pp. 967–976, 2018, doi: 10.24176/simet.v9i2.2490.

Y. Astarina, “Perancangan Sistem Informasi Anggaran Pada Stie Lembah Dempo Pagar Alam,” J. Sist. Inf. Komput. dan Teknol. Inf., vol. 1, no. 1, pp. 40–54, 2019, [Online]. Available: https://www.ejournal.lembahdempo.ac.id/index.php/STMIK-SISKOMTI/article/download/10/4.

A. Rosita, “Perancangan Sistem Informasi Perencanaan dan Kontrol Anggaran di Perguruan Tinggi ( Studi Kasus pada Universitas Widyatama Bandung ),” Konf. Nas. Sist. Inf. 2018 STMIK Atma Luhur Pangkalpinang, no. 8-9 Maret, pp. 1311–1316, 2018, [Online]. Available: http://jurnal.atmaluhur.ac.id/index.php/knsi2018/article/viewFile/530/455.

A. Rahmatulloh and Husen, “Sistem Informasi Manajemen Anggaran (Simangga) Perguruan Tinggi Berbasis Web (Studi Kasus : Universitas Siliwangi),” J. Edukasi dan Penelit. Inform., vol. 3, no. 2, pp. 89–95, 2017, doi: 10.26418/jp.v3i2.22512.

M. Sukur, P. Purwaningtyas, and I. H. Al Amin, “Rancang Bangun Aplikasi Sistem Perencanaan dan Pencatatan Anggaran Biaya Keluarga Menggunakan Metode Budgeting,” J. Din. Vol. 22, No. 1, Januari 2017 30-38, vol. 22, no. 1, pp. 30–38, 2017, doi: 10.35315/dinamik.v22i1.7103.

F. Nuraini, “Sistem Informasi Perencanaan Anggaran dan Biaya Universitas Respati Yogyakarta,” J. Teknol. Inf., vol. X, no. 28, pp. 1–10, 2015, [Online]. Available: http://jti.respati.ac.id/index.php/jurnaljti/article/download/144/135.

U. M. Arief, D. Prastiyanto, A. Suryanto, A. W. Pradana, and G. K. Putri, “Pengembangan Sistem Informasi Manajemen Proposal Anggaran Fakultas Teknik UNNES,” sainteknol, vol. 16, no. 2, pp. 211–220, 2019, doi: 10.15294/sainteknol.v16i2.16315.

E. M. S. Rochman and A. Rachmad, “Sistem Informasi Anggaran Belanja,” J. Ilm. NERO, vol. 2, no. 2, pp. 83–89, 2016, [Online]. Available: https://nero.trunojoyo.ac.id/index.php/nero/article/download/52/49.

Q. Umam, S. A. Wicaksono, and W. Purnomo, “Analisis Dan Perancangan Data Warehouse Menggunakan Pendekatan Mixed-Driven ( Studi Pada Dinas Komunikasi dan Informatika Kabupaten Sidoarjo ),” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 3, no. 2, pp. 1824–1833, 2019, [Online]. Available: https://j-ptiik.ub.ac.id/index.php/j-ptiik/article/view/4581/2106.

K. Khotimah and Sriyanto, “Perancangan Dan Implementasi Data Warehouse Untuk Mendukung Sistem Akademik (Studi Kasus Pada STKIP Muhammadiyah Kotabumi),” J. Teknol. Inf. Magister Darmajaya, vol. 2, no. 01, pp. 94–107, 2016, [Online]. Available: https://media.neliti.com/media/publications/141617-ID-perancangan-dan-implementasi-data-wareho.pdf.

Zarnelly, “Sistem Informasi E - Budgeting Menggunakan ( Studi Kasus : UIN Suska Riau ),” J. Ilm. Rekayasa dan Manaj. Sist. Inf., vol. 3, no. 1, pp. 70–77, 2017, [Online]. Available: http://ejournal.uin-suska.ac.id/index.php/RMSI/article/download/3449/2056.

D. Sugiarto, H. Leslie Hendric Spits Warnars, and Winarno, “Perancangan Data Warehouse Penjualan (Studi Kasus PT. Subafood Pangan Jaya),” Semin. Nas. Ris. dan Teknol. (SEMNAS RISTEK), pp. 271–276, Jan. 2020, [Online]. Available: http://www.proceeding.unindra.ac.id/index.php/semnasristek/article/download/2573/257.

M. Muhaemin, “Desain Arsitektur Teknologi Data Warehouse Untuk Mendukung Manajemen Pengawasan dan Pengendalian PNS Studi Kasus : Badan Kepegawaian Negara,” JUST IT J. Sist. Informasi, Teknol. Inf. dan Komput., vol. 9, no. 2, pp. 163–168, 2019, [Online]. Available: https://jurnal.umj.ac.id/index.php/just-it/article/download/4187/3062.

H. Ganesha, “Perancangan Data Warehouse untuk Kebutuhan Sistem Penunjang Keputusan Divisi Revenue Assurance Studi Kasus: PT. XXX,” J. InfoTekJar (Jurnal Nas. Inform. dan Teknol. Jaringan), vol. 3, no. 1, pp. 74–80, 2018, doi: 10.30743/infotekjar.v3i1.491.

J. Christian, “Model Data Warehouse Dengan Service Oriented Architecture Untuk Menunjang Sistem Informasi Eksekutif,” J. Telemat. MKOM, vol. 2, no. 2, pp. 103–115, 2010, [Online]. Available: https://journal.budiluhur.ac.id/index.php/telematika/article/view/167/161.

R. Kimball and M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence, 2nd ed. Indianapolis: John Wiley & Sons, Inc, 2010.

Andri and B. Tujni, “Analisis dan Perancangan Data Warehouse Perpustakaan (Studi Kasus: Perpustakaan Universitas Binadarma Palembang),” Semin. Nas. Inform. 2015 UPN ”Veteran” Yogyakarta, pp. 43–48, 2015, [Online]. Available: http://jurnal.upnyk.ac.id/index.php/semnasif/article/view/1364/1236.

Vijay, R. Desyatnikov, and Swati, “Data Warehouse Testing Tutorial With Examples | ETL Testing Guide,” SoftwareTestingHelp.com, 2023. https://www.softwaretestinghelp.com/data-warehouse-testing-tutorial/ (accessed Feb. 01, 2023).

F. Ghita and R. Trisminingsih, “Pengujian Data Warehouse SOLAP untuk Komoditas Pertanian Indonesia Data Warehouse Testing in SOLAP for Indonesia Agricultural Commodities,” Jurnal Ilmu Komputer Agri-Informatika, 2021. https://doi.org/10.29244/jika.8.1.42-56.

M. Golfarelli and S. Rizzi, “Data warehouse testing,” Int. J. Data Warehous. Min., vol. 7, no. 2, pp. 26–43, 2011, doi: 10.4018/jdwm.2011040102.

D. Prastyo and A. Supriyanto, “Analisa Dan Perancangan Data Warehouse Dengan Metode Nine Step Kimball di PT Surganya Motor Indonesia,” Proceeding SENDIU, no. July, pp. 978–979, 2021, [Online]. Available: https://www.researchgate.net/publication/353680630_ANALISA_DAN_PERANCANGAN_DATA_WAREHOUSE_DENGAN_METODE_NINE_STEP_KIMBALL_DI_PT_SURGANYA_MOTOR_INDONESIA.




DOI: http://dx.doi.org/10.26798/jiss.v2i1.927

Article Metrics

Abstract view : 773 times
PDF - 304 times

Refbacks

  • There are currently no refbacks.


Copyright (c) 2023 Hendra Maryanto, Bambang Purnomosidi Dwi Putranto, Rikie Kartadie, Muhammad Guntara, Robertus Saptoto

JOURNAL OF INTELLIGENT SOFTWARE SYSTEMS

Published by

Magister Teknologi Informasi
Lembaga Penelitian dan Pengabdian Masyarakat
Universitas Teknologi Digital Indonesia (d.h STMIK AKAKOM)
Jl. Raya Janti Jl. Majapahit No.143, Jaranan, Banguntapan,
Kec. Banguntapan, Kabupaten Bantul,
Daerah Istimewa Yogyakarta 55918

Website : https://www.utdi.ac.id/

 

Creative Commons License

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