Claim Missing Document
Check
Articles

Found 2 Documents
Search

Perancangan Data Warehouse Penjualan Minimarket XYZ Menggunakan Kimball Modeling dan Analisis OLAP Wikananda, Ketut Agus; Muhammad Raka Nur Habibi; Andri Wijaya
Jurnal Sains Dan Teknologi | E-ISSN : 3063-9980 Vol. 2 No. 2 (2025): Oktober - Desember
Publisher : GLOBAL SCIENTS PUBLISHER

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Minimarkets generate large volumes of transaction data every day that have not been fully utilized for business analysis. This study aims to design a minimarket sales data warehouse using the Kimball method and to conduct OLAP analysis using RapidMiner. The steps carried out include identifying requirements, designing a dimensional model based on a star schema, performing ETL processes, and conducting OLAP analysis. Sales data are processed into a fact table and several dimension tables. The analysis results indicate that the data warehouse can display sales information multidimensionally based on time, product, and region, which is useful for managerial decision-making.
Analisis Manajemen Risiko TI Menggunakan COBIT 5 Domain APO12 pada PT VWX Sanjaya, Aloisius Egi; Wikananda, Ketut Agus; Sitompul , Mayer Dhani; Andayani , Sri
Jurnal Sains dan Teknologi (JSIT) Vol. 6 No. 1 (2026): Januari - April
Publisher : CV. Information Technology Training Center - Indonesia (ITTC)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jsit.v6i1.4192

Abstract

The use of Information Technology (IT) in distribution companies plays a crucial role in supporting operational efficiency, data accuracy, and business continuity. PT VWX is a stationery (ATK) distribution company that procures goods from factories and distributes them to suppliers in large quantities. The company relies on a centralized application provided by the head office and utilizes Microsoft Excel for data input processes. This dependency creates several IT-related risks, including human error in data entry, dependency on centralized systems, limited IT human resources, and outdated hardware specifications. This study aims to analyze IT risk management at PT VWX using the COBIT 5 framework, specifically the APO12 (Manage Risk) domain. The research method involved interviews with IT personnel and an analysis of the As-Is and To-Be conditions. The results indicate that the current IT risk management capability level is at Level 2 (Managed Process), which has not yet reached the targeted Level 3 (Established Process). Therefore, formal procedures, risk registers, and improved risk mitigation mechanisms are required to achieve more systematic and proactive IT risk management.