Article Per Year (5 Year)
p-Index From 2021 - 2026
1.671
P-Index
This Author published in this journals
All Journal Journal of Information System Journal of Computer System and Informatics (JoSYC) Jurnal Informatika dan Teknologi Informasi Sistem Komputer & Teknologi Intelegensi Artifisial (SIKOMTIA) Eksplorasi Teknologi Enterprise & Sistem Informasi (EKSTENSI) Jurnal Information System
Hany Maria Valentine
Universitas Bung Karno, Jakarta
Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Industrial & Manufacturing Engineering

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

Found 11 Documents
Search

 1   2 
Rancangan Model Dimensi Kimball Pada Data Warehouse Perusahaan Manufaktur Fauziyah Fauziyah; Iskandar Zulkarnain; Andy Rio Handoko; Hany Maria Valentine; Dwi Lestari
JOINS (Journal of Information System) Vol 11 No 1 (2026): Edisi (Desember 2025 - Mei 2026)
Publisher : Fakultas Ilmu Komputer, Universitas Dian Nuswantoro

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33633/joins.v11i1.14670

Abstract

Modern manufacturing companies face significant challenges from large data volumes and fragmented information systems, which hinder effective data-driven decision-making. This study aims to address these issues by designing a dimensional model for a data warehouse in an electronics manufacturing company, integrating scattered operational data into a single, unified repository. By applying Kimball's Business Dimensional Life Cycle methodology, this study systematically goes through four stages: defining core business processes, declaring data granularity, identifying dimensions, and identifying facts. The result is a fact constellation model (star schema) consisting of 11 grains, 8 fact tables, 8 star schema models, and 1 dimensional model. This proposed model simplifies data access for in-depth analysis, providing a robust and reusable framework to support strategic decision-making in a modern manufacturing environment
Co-Authors Andy Rio Handoko Ari Tri Anggoro Dion Marusaha Gultom Dwi Lestari Ega Lusiyana Fahri Mejart Fauziyah Fifto Nugroho Helmy Daimon Matulessy Iskandar Zulkarnain Joseph Mesran, Mesran Rendi Achmad Okdiyono Ridwan Chijaya Samuel Ramos Sharyanto Sharyanto Steven Martinus Pedro Pasaribu Susi Susilowati Yoga Listi Prambodo