Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Tata Kelola dan Kerangka Kerja Teknologi Informasi
Anno Achmat Istiana
Universitas Bina Sarana Informatika
Computer Science & IT

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

Found 1 Documents
Search

 1 
Penerapan Business Intelligence Dengan Metode Nine-Step Kimball Untuk Analisis Penjualan Diamond Game (Studi Kasus: Aplikasi Otak Pulsa) Anno Achmat Istiana; Yusnia Budiarti
Jurnal Tata Kelola dan Kerangka Kerja Teknologi Informasi Vol. 12 No. 2 (2026): Agustus 2026
Publisher : Universitas Komputer Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.34010/jtk3ti.v12i2.21294

Abstract

This study aims to implement Business Intelligence using the Nine-Step Kimball method and develop an dashboard using Microsoft Power BI. A descriptive case study was conducted on 21,143 transactions recorded from February 1, 2025 to February 28, 2026, covering 288 products, 1,032 resellers, and 4 suppliers. Data processing included selection, cleaning, transformation, dimensional modeling, visualization, and interpretation. The resulting sales data mart uses a star schema consisting of the TRANSAKSI fact table and four dimensions: time, Product, RESELLER, and SUPPLIER. The dashboard contains six analytical pages connected through cross-filtering. User acceptance reached 91.43%, categorized as Very Good. The analysis found that transactions peaked in April 2025 and on weekends; FFP70 had the highest transaction volume; GFFR50 generated the highest profit; 73.4% of transactions originated from West Java, Banten, and Jakarta; transaction success reached 98.4%; and the profit margin was approximately 3.1%. These findings can support decisions on promotion, balance availability, supplier capacity, and reseller network development.
Co-Authors Yusnia Budiarti