IJIS - Indonesian Journal On Information System
Vol 11, No 1 (2026): APRIL

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

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



Article Info

Publish Date
01 Apr 2026

Abstract

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

Copyrights © 2026






Journal Info

Abbrev

home

Publisher

Subject

Computer Science & IT

Description

IJIS - Indonesian Journal On Sistem Information adalah sebuah publikasi yang peruntukan bagi akademik baik dosen, guru, peneliti, praktisi dan sejenisnya untuk mempublikasikan karya ilmiah agar biasa bermanfaat untuk ...