Article Per Year (5 Year)
p-Index From 2020 - 2025
0.444
P-Index
This Author published in this journals
All Journal INTECOMS: Journal of Information Technology and Computer Science
Hutagaol, Alice Shizuka
Unknown Affiliation
Computer Science & IT

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

Found 2 Documents
Search

 1 
Perancangan Datamart Nilai Akademik Siswa Pada SMA Z Bekasi Marcydiaz, Andrew Haikal; Fitriya, Febby Nurul; Hutagaol, Alice Shizuka; Trisnawarman, Dedi; Beng, Jap Tji
INTECOMS: Journal of Information Technology and Computer Science Vol 7 No 6 (2024): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/intecoms.v7i6.12916

Abstract

Pemantauan prestasi akademik siswa merupakan aspek penting dalam meningkatkan kualitas pendidikan di sekolah. SMA Z Bekasi membangun dashboard analitik untuk membantu pemantauan prestasi akademik siswa. Dalam pembangunan dashboard tersebut, diperlukannya datamart yang memiliki peran penting dalam pengelolaan nilai akademik secara efisien dan terstruktur, serta menyatukan data dalam satu sumber dan format. Penelitian ini bertujuan untuk merancang datamart yang mengakomodasi kebutuhan pengelolaan data nilai akademik siswa secara terpusat. Datamart dirancang menggunakan pendekatan dimensional modeling dengan metode star schema, yang mencakup tabel fakta nilai akademik dan tabel dimensi seperti siswa, mata pelajaran, dan periode waktu. Proses pengembangan meliputi tahapan extract, transform, and load ETL, sehingga data dari berbagai sumber dapat diintegrasikan dengan baik. Hasil penelitian menunjukkan bahwa datamart yang dirancang berhasil meningkatkan efisiensi pengelolaan dan analisis data akademik, serta mendukung proses pengambilan keputusan terkait evaluasi prestasi akademik di SMA Z Bekasi. Implementasi ini juga memudahkan pelaporan dan pemantauan nilai siswa secara lebih cepat dan akurat.
DESIGNING A DATA WAREHOUSE TO OPTIMIZE THE HOTEL BOOKING MONITORING DASHBOARD Hutagaol, Alice Shizuka; Beng, Jap Tji; Wasino, Wasino; Tiatri, Sri; Lunzaga, Ele; Salsabila, Tasya Mulia; Nurkholiza, Rahmiyana
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/rr4rhx45

Abstract

In the rapidly growing tourism industry, efficient data management is crucial for strategic decision-making. This study focuses on the design and implementation of a data warehouse to optimize the monitoring dashboard for hotel bookings on an application X, an online hotel booking platform, a product of PT. XYZ. Along with the increase in volume and complexity of booking transaction data, there is an urgent need for an efficient data management system that can provide insights quickly and accurately. To address this, the study uses Kimball's Nine-Step Methodology and implements a star schema, which simplifies complex data relationships and improves query performance. The ETL (Extract, Transform, Load) process is applied to ensure accurate extraction, transformation, and loading of data from operational systems into the data warehouse, thereby guaranteeing consistency and accuracy for analysis. Tools such as SQL Server Management Studio 2022, Visual Studio 2019, and SQL programming were used to develop the data warehouse and the star schema. The results of the study show that the star schema, with a central fact table and surrounding dimension tables, effectively optimizes data processing and query speed. The system is scalable, allowing for future expansion without significant changes, and provides a robust platform for business intelligence. Recommendations include developing dimension analysis, optimizing the ETL process, and integrating predictive analytics to enhance decision-making. Overall, this study provides a structured data warehouse design that significantly improves PT. XYZ's ability to process, analyze, and visualize hotel booking data for strategic decision-making. Keywords: Data Warehouse, Extract Transform Load (ETL), Dashboard, Nine-Step Kimball, SQL.
Co-Authors Dedi Trisnawarman Fitriya, Febby Nurul Jap Tji Beng Lunzaga, Ele Marcydiaz, Andrew Haikal Nurkholiza, Rahmiyana Salsabila, Tasya Mulia Sri Tiatri Wasino Wasino