Enhancing handicraft exports in West Java: A business intelligence approach to market expansion

Abstract

The creative industries in West Java have significantly boosted the region's economy, contributing to higher GDP, more jobs, and increased exports. However, the handicraft sector seeks to grow its presence in the international market, where it currently holds a minor share. To address the challenges of expanding, such as limited information, marketing obstacles, and regulatory hurdles, the handicraft industry is encouraged to adopt a business intelligence (BI) platform. This study aims to use a BI platform to present and analyze export data for West Java's craft industry, examining its distribution, trends, and future prospects to help increase exports from this Indonesian province. The analysis employs clustering with k-means, time series analysis, and forecasting methods, including exponential smoothing and the compound annual growth rate (CAGR), using export data from 2018 to 2022. The process involves collecting primary and secondary data, transforming it through ETL (Extract, Transform, Load) technology, and integrating it into the BI platform for analysis. This analysis aims to identify export patterns, trends, and make forecasts that can guide decision-making. The findings indicate that handicraft exports are categorized into three destination country clusters, each favoring different product types, revealing trends and growth opportunities for various handicraft items. Additionally, the study provides forecasts for handicraft exports, offering valuable insights for strategic planning.