COMPREHENSIVE VISUALIZATION OF MULTISECTORAL DATA IN PAGAR ALAM CITY: INTEGRATION OF BPS STATISTICS INTO A GOOGLE LOOKER STUDIO DASHBOARD TO SUPPORT REGIONAL PLANNING

Abstract

This study aims to develop a comprehensive visualization of multisectoral data for the City of Pagar Alam by integrating data from the Central Bureau of Statistics (BPS) into a Google Looker Studio dashboard to support more effective regional planning. Optimal regional planning is expected to drive sustainable growth and improve community welfare. Although BPS provides accurate data, challenges in its presentation and interpretation often hinder effective decision-making. Through the Google Looker Studio platform, this study explores the creation of an interactive dashboard that presents demographic, education, agriculture, and economic sector data, enabling stakeholders to more easily identify patterns and trends. The results of this study show that effective data visualization can enhance transparency and accountability in the planning process and provide deeper insights for strategic decision-making. These findings not only contribute to improving planning in Pagar Alam City but also serve as a potential model for other regions in Indonesia aiming to optimize data use in decision- making.