Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi
Angela, Octarifa
Universitas Tarumanagara, Jakarta
Computer Science & IT

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Designing a Data Mart at the Indonesian Psychological Healthcare Center Using Pentaho Angela, Octarifa; Beng, Jap Tji; Trisnawarman, Dedi; Tiatri, Sri; Sam, Toong Hai; Guanco, Rhalf Jayson F.; Nurkholiza, Rahmiyana; Dinatha, Vienchenzia Oeyta Dwitama
Jutisi : Jurnal Ilmiah Teknik Informatika dan Sistem Informasi Vol 14, No 3: Desember 2025
Publisher : STMIK Banjarbaru

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35889/jutisi.v14i3.3153

Abstract

Critical data is essential for organisational success, providing essential information for decision-making. This study focuses on the Indonesian Mental Health Centre (IndoPsyCare), which utilises data to improve service performance. The research aims to design a data mart to support analytical needs by transforming the Online Transaction Processing (OLTP) database into Online Analytical Processing (OLAP). This design follows Kimball's Nine-Step Approach and integrates the Extract, Transform, Load (ETL) process. Data was collected from August 2023 to August 2024 through interviews and electronic documentation. The system was implemented using Microsoft SQL Server Management Studio 18 and Pentaho Data Integration. The resulting data mart uses a star schema with fact and dimension tables tailored to stakeholder needs, particularly in appointment analysis. Findings indicate that the data mart facilitates efficient access, targeted analysis, and improved query performance, thereby supporting IndoPsyCare's decision-making and overall service optimisation. 
Co-Authors Beng, Jap Tji Dinatha, Vienchenzia Oeyta Dwitama Guanco, Rhalf Jayson F. Nurkholiza, Rahmiyana Sam, Toong Hai Tiatri, Sri Trisnawarman, Dedi