Business Intelligence for Food Security Decision-Making from Transformed Paddy and Rice Production Data in North Kalimantan

Abstract

The agribusiness sector in North Kalimantan Province faces challenges of supply chain inefficiencies and limited post-harvest infrastructure, which hinder food security and stability. This study aims to transform historical data on rice and paddy production from the Statistics Indonesia into Business Intelligence tools to support precise decision-making. The method used is a descriptive-quantitative approach, with an action research design. Historical data for the period 2018-2025 is processed and visualized in Looker studio. The main focus of the analysis is the extraction of production variables into technical indicators of efficiency, using yield percentages and geospatial mapping. The study's results show that the system successfully integrates production metrics, with an average actual yield of 59.15%, which is below the national standard of 64.02%. Analysis of the time-series chart shows a decrease in production, especially in Nunukan, which is a producer of Adan rice with premium varieties. Geospatial visualization reveals the region's polarization, where the administrative area is not directly proportional to production volume. The conclusion of this study confirms that the development of this dashboard is effective as a visual audit tool for detecting technical inefficiencies and spatial disparities. The transformation of tabular data into interactive insights enables policymakers to determine more targeted agricultural technology interventions to strengthen regional agribusiness supply chains.