Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal JSAI (Journal Scientific and Applied Informatics)
Raihan Cikal Herlambang
Unknown Affiliation
Computer Science & IT

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

Found 1 Documents
Search

 1 
Implementasi Data Warehouse dan Bussiness Intelligence Kasus AIDS di Jawa Barat Budy Santoso, Cahyono; Muhammad Mujiburochman; Reyner Shaquille Rachim; Raihan Cikal Herlambang
JSAI (Journal Scientific and Applied Informatics) Vol 8 No 1 (2025): Januari
Publisher : Fakultas Teknik Universitas Muhammadiyah Bengkulu

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36085/jsai.v8i1.7567

Abstract

This study discusses the design of a data warehouse for analyzing AIDS cases in West Java using the Nine Step Methodology. The background of this research is the high prevalence of AIDS cases in West Java during 2018–2019 and the need for an integrated data management system to support data-driven health policies. The objective of this study is to design and implement a data warehouse capable of integrating data from various dimensions, such as region, age group, gender, and year, to support epidemiological analysis of AIDS. The methodology employed includes stages such as data extraction from various sources, data transformation to enhance quality, and data loading into a PostgreSQL-based data warehouse system. The study also utilizes the ETL (Extract, Transform, Load) process to ensure the integrity of the processed data. The results indicate that the designed data warehouse successfully maps the distribution of AIDS cases based on relevant dimensions. Key findings reveal that the productive age group (25–49 years) and males have the highest number of cases, with Bandung City being the region with the most cases. The contribution of this study is the provision of a data platform that supports evidence-based decision-making while identifying high-risk regions and groups for more effective health interventions. Limitations include the scope of data limited to two years and the absence of predictive analytics features. Future research is recommended to expand the time coverage and integrate predictive analysis to enhance the effectiveness of health policy
Co-Authors Budy Santoso, Cahyono Muhammad Mujiburochman Reyner Shaquille Rachim