A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD

Aurora Grace Valensia Pohan Simanjuntak; Benny Pinontoan; Christian A. J. Soewoeh

doi:10.36549/ijis.v11i1.471

A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD

Aurora Grace Valensia Pohan Simanjuntak, Benny Pinontoan, Christian A. J. Soewoeh

Sari

Local economic data in Jayawijaya Regency, such as Gross Regional Domestic Product (GRDP), poverty rates, Human Development Index (HDI), and unemployment statistics, is often scattered across different spreadsheets and standard documents. This scattering considerably hinders deep, multi-aspect assessment for regional leaders. This study aims to build and deploy a dynamic analytical dashboard that aggregates economic figures for the period 2020-2024. The design of this system employs a Data Warehouse with a multidimensional Galaxy Schema to merge indicators with distinct measurement types into a single central place. The Extract, Transform, Load (ETL) process was automated using Pentaho Data Integration, achieving 100% data matching accuracy with no data loss. Using Tableau Public as the visual display section, the dashboard functions through three subject-based views: Executive Summary, Economic Growth, and Social Welfare.

Keywords: Analytical Dashboard, Data Warehouse, Galaxy Schema, Macroeconomic, Visualization

Teks Lengkap:

PDF (English)

Referensi

Afikah, P., Avorizano, A., Afandi, I. R., & Hasan, F. N. 2022. Implementasi Business Intelligence untuk Menganalisis Data Kasus Virus Corona di Indonesia Menggunakan Platform Tableau. Jurnal Pseudocode, Vol. 9.

Andriyati, M., Ardiansyah, S., & Putra, M. G. L. 2021. Penerapan Business Intelligence pada Data Cuaca Badan Meteorologi, Klimatologi, dan Geofisika (BMKG). SPECTA Journal of Technology, Vol. 5 No. 2, doi: 10.35718/specta.v5i2.260.

BPS-Statistics of Jayawijaya Regency. 2024. Jayawijaya Regency in Figures 2024. Jayawijaya: BPS-Statistics.

Chen, J. 2024. Construction and Application of an Economic Intelligent Decision-Making Platform Based on Artificial Intelligence Technology. Informatica, Vol. 48 No. 9, 89-106, doi: 10.31449/inf.v48i9.5705.

Fauziah, M. N., Hartono, R., & Supriatman, A. 2024. Pengembangan Data Warehouse Pada Apotek X Untuk Kebutuhan Business Intelligence. JATI (Jurnal Mahasiswa Teknik Informatika), Vol. 8 No. 4, doi: 10.36040/jati.v8i4.10646.

Frempong, D., et al. 2022. Real-Time Analytics Dashboards for Decision-Making Using Tableau in Public Sector and Business Intelligence Applications. Journal of Frontiers in Multidisciplinary Research, Vol. 3 No. 2, doi: 10.54660/.ijfmr.2022.3.2.65-80.

Hasan, F. N., & Sudaryana, I. K. 2022. Penerapan Business Intelligence & Online Analytical Processing untuk Data-Data Penelitian dan Luarannya pada Perguruan Tinggi Menggunakan Pentaho. Infotech: Journal of Technology Information, Vol. 8 No. 2, doi: 10.37365/jti.v8i2.143.

Lokaadinugroho, I., Girsang, A. S., & Burhanudin. 2021. Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education. JURNAL EMACS (Engineering, Mathematics and Computer Science), Vol. 3 No. 1, doi:10.21512/emacsjournal.v3i1.6816

Machireddy, J. R., Rachakatla, S. K., & Ravichandran, P. 2021. AI-Driven Business Analytics for Financial Forecasting: Integrating Data Warehousing with Predictive Models. Journal of Machine Learning in Pharmaceutical Research, Vol. 1 No. 2, 1-15.

Murtiwiyati, M., Agathon, H., & Safitri, L. 2024. Implementasi Data Warehouse dan Business Intelligence Menggunakan Pentaho dan Metabase untuk Membuat Dahboard Visualisasi Kinerja Penjualan E-Commerce Wish. Jurnal Penelitian Teknologi Informasi dan Sains, Vol. 2 No. 4, doi: 10.54066/jptis.v2i4.2783.

Özcan, M., & Peker, S. 2021. Designing a Data Warehouse for Earthquake Risk Assessment of Buildings: A Case Study for Healthcare Facilities. Sakarya University Journal of Computer and Information Sciences, Vol. 4 No. 1, doi: 10.35377/saucis.04.01.872729.

Pandensolang, F., Manoppo, F., & Sumendap, A. 2022. Implementasi Business Intelligence Untuk Analisa dan Visualisasi Perbandingan Perencanaan dan Realisasi Anggaran pada BNNP Sulawesi Utara. Jurnal Teknik Informatika, Vol. 17 No. 3.

Purwanto, J., & Renny. 2021. Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP). Jurnal Teknologi Informasi dan Ilmu Komputer (JTIIK), doi: 10.25126/jtiik.202184842.

Putri, F. I., Suryamen, H., & Wahyuni, U. M. 2024. Penerapan Business Intelligence Dashboard dan Forecasting pada Jumlah Pasien Puskesmas XYZ. Innovation and Technology Jurnal Ilmu Komputer, Sistem Informasi dan Teknologi Informasi (Innotech), Vol. 1 No. 2.

Rivanza, A., Yudhanto, D. P., Rifky, M., & Ashari, M. I. 2026. Implementasi Business Intelligence dalam Menganalisis Disparitas Pendidikan: Studi Kasus Harapan dan Realisasi Lama Sekolah. Jurnal Akuntansi dan Sistem Informasi, Vol. 1 No. 2.

Rusydi, A., & Hasan, F. N. 2023. Implementasi business intelligence untuk visualisasi kekuatan sinyal internet di Indonesia menggunakan platform tableau. TEKNOSAINS: Jurnal Sains, Teknologi dan Informatika, Vol. 10 No. 1, doi: 10.37373/tekno.v10i1.378.

Senduk, F. K., Waluyo, R., & Isnaini, K. N. 2025. Analisis Data dengan Business Intelligence dan Tableau untuk Visualisasi Garis Kemiskinan Indonesia. Sistemasi: Jurnal Sistem Informasi, Vol. 14 No. 3.

Turcan, G., & Peker, S. 2022. A multidimensional data warehouse design to combat the health pandemics. Journal of Data, Information and Management, Vol. 4 No. 4, 371-386.

Wahyudi, T., Nopianto, M., Rani, J., Kurniawan, D. R., & Nugraha, D. 2023. Implementasi Dashboard Monitoring Laju Pertumbuhan Penduduk di Rukun Warga 011 Pondok Kelapa Menggunakan Tableau Public. Jurnal Pengabdian Nasional (JPN) Indonesia, Vol. 4 No. 2, doi: 10.35870/jpni.v4i2.203.

Zafary, F. 2020. Implementation of business intelligence considering the role of information systems integration and enterprise resource planning. Journal of Intelligence Studies in Business, Vol. 10 No. 1, doi: 10.37380/JISIB.V1I1.563.

DOI: https://doi.org/10.36549/ijis.v11i1.471