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