Interactive Dashboard for Visualizing Teacher Distribution in Tangerang City Using BigQuery and Looker Studio

Abstract

The uneven distribution of teachers directly affects the quality and equity of educational services. The Tangerang City Government, which oversees 13 sub-districts, requires well-visualized and analyzable education workforce data to support educational planning and policy-making processes. This study involves the design of a comprehensive and interactive data visualization of teacher distribution using BigQuery and Looker Studio. The authors collected data from the Ministry of Education’s Dapodik portal for the years 2021 to 2023, processed it in BigQuery, and built the visualizations in Looker Studio. The data processing involved data cleaning, transformation, SQL querying, and the development of an interactive dashboard. The final output is a dashboard that presents teacher distribution patterns based on sub-district, gender, and institution type (elementary, junior high, senior high, and vocational schools). Through this visualization, the authors aim to support educational authorities in making precise decisions to achieve equitable teacher allocation.