Jurnal Informatika dan Rekayasa Komputer
Vol 6 No 2 (2026): JAKAKOM Vol 6 No 2 SEPTEMBER 2026

Business Intelligence Implementation Using the Nine-Step Kimball Method for Analyzing Trading Activities in Majalengka Regency Public Markets

Indri Oktaviani (Universitas Catur Insan Cendekia Cirebon)
Marsani Asfi (Universitas Catur Insan Cendekia Cirebon)
Mohammad Umar Fakhrudin (Universitas Catur Insan Cendekia Cirebon)



Article Info

Publish Date
30 Sep 2026

Abstract

Managing trade data and local government market merchant activities requires integrated information to support analysis, evaluation, and decision-making. This study aims to design a data warehouse using the Nine-Step Kimball methodology that integrates ETL processes, as well as implements OLAP and analytical indicators within a Business Intelligence framework to analyze the activities and potential of local government market merchants in Majalengka Regency. The dataset comprises 2023–2025 data from Kadipaten Market, Prapatan Market, Sindangkasih Market, and Talaga Market. The results indicate a total retribution revenue of IDR 7,967,539,000, with an increase in 2024 followed by a decline in 2025, where Kadipaten Market emerged as the primary retribution contributor. The analysis also reveals variations in merchant activity characteristics, trading places, and merchandise categories across markets. Furthermore, estimated potential exceeding actual revenue indicates opportunities for revenue optimization. Additionally, OLAP exploration successfully identified data patterns across time, markets, merchants, trading places, and merchandise categories. The implementation of Business Intelligence delivers multidimensional insights that assist the Industry and Trade Office (Disperdagin) and the Majalengka Regency Government in monitoring, evaluating, and planning local government market management more effectively. 

Copyrights © 2026






Journal Info

Abbrev

jakakom

Publisher

Subject

Computer Science & IT

Description

Jurnal Informatika Dan Rekayasa Komputer (JAKAKOM) merupakan jurnal yang berada dibawah naungan Lembaga Penelitian dan Pengabdian Masyarakat (LPPM) Universitas Dinamika Bangsa dan diterbitkan oleh Universitas Dinamika Bangsa Jambi. Jurnal Informatika Dan Rekayasa Komputer (JAKAKOM) menerbitkan ...