Claim Missing Document
Check
Articles

Found 2 Documents
Search

ANALISIS RISIKO TI BPKP SUMSEL MENGGUNAKAN COBIT 5 DOMAIN APO12 Ayu Elisya Natama Sianturi; Arron Mosses Jhon Hadi; Wianti Maharani; Sri Andayani
Informatika: Jurnal Teknik Informatika dan Multimedia Vol. 6 No. 1 (2026): MEI : JURNAL INFORMATIKA DAN MULTIMEDIA
Publisher : LPPM Politeknik Pratama Kendal

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51903/informatika.v6i1.1512

Abstract

This study evaluates the capability level of IT risk management processes at BPKP South Sumatra Province based on the COBIT 5 APO12 domain. Data were collected through interviews and questionnaires covering activities APO12.01–APO12.06. The results indicate that the current As-Is capability is at Level 3 (Established Process), meaning the risk management process is defined and consistently executed but still requires improvement in monitoring, mitigation reporting, and risk evaluation. The To-Be condition is set at Level 5 to achieve more proactive, effective, and sustainable IT governance practices.
PERANCANGAN DATA WAREHOUSE E-COMMERCE MENGGUNAKAN POSTGRESQL PADA PUBLIC DATASET OLIST Arron Mosses Jhon Hadi; Ayu Elisya Natama Sianturi; Andri Wijaya
Jurnal Riset Sistem Informasi Vol. 3 No. 1 (2026): Januari : Jurnal Riset Sistem Informasi
Publisher : CV. Denasya Smart Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.69714/8dwt6j74

Abstract

This study designs a PostgreSQL-based data warehouse using the Olist public dataset to address fragmented and unstructured e-commerce transactional data. The research process includes ETL (Extract, Transform, Load), data cleaning and standardization, table consolidation, and the development of a star schema consisting of a sales fact table and multiple dimension tables. OLAP analysis reveals key patterns such as annual sales trends, top product categories, seller performance, preferred payment methods, and customer geographic distribution. The results demonstrate that the data warehouse improves analytical efficiency and provides strategic insights to support business intelligence in the e-commerce environment