Indri Oktaviani
Universitas Catur Insan Cendekia Cirebon

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

Found 1 Documents
Search

Business Intelligence Implementation Using the Nine-Step Kimball Method for Analyzing Trading Activities in Majalengka Regency Public Markets Indri Oktaviani; Marsani Asfi; Mohammad Umar Fakhrudin
Jurnal Informatika Dan Rekayasa Komputer(JAKAKOM) Vol 6 No 2 (2026): JAKAKOM Vol 6 No 2 SEPTEMBER 2026
Publisher : LPPM Universitas Dinamika Bangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33998/jakakom.2026.6.2.2971

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.