A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD
IJIS - Indonesian Journal On Information System · 01.04.2026 · 11 (1) · 52
DOI: 10.36549/ijis.v11i1.471 ↗Kurz gefasst
Fachartikel in der Zeitschrift IJIS - Indonesian Journal On Information System, online erschienen am 01.04.2026. Verfasst von Aurora Grace Valensia Pohan Simanjuntak und 2 weiteren Autor:innen.
Abstract (Originalsprache)
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.
Zitieren
APA
Simanjuntak, A. G. V. P., Pinontoan, B., & Soewoeh, C. A. J. (2026). A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD. IJIS - Indonesian Journal On Information System, 11(1), 52. https://doi.org/10.36549/ijis.v11i1.471
Vancouver
Simanjuntak AGVP, Pinontoan B, Soewoeh CAJ. A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD. IJIS - Indonesian Journal On Information System. 2026;11(1):52. doi:10.36549/ijis.v11i1.471
BibTeX
@article{Simanjuntak2026,
author = {Simanjuntak, Aurora Grace Valensia Pohan and Pinontoan, Benny and Soewoeh, Christian A. J.},
title = {A GALAXY SCHEMA APPROACH FOR INTEGRATING HETEROGENEOUS MACROECONOMIC DATA INTO AN ANALYTICAL DASHBOARD},
journal = {IJIS - Indonesian Journal On Information System},
year = {2026},
volume = {11},
number = {1},
pages = {52},
doi = {10.36549/ijis.v11i1.471}
}
EUVIMED