International Journal Software Engineering and Computer Science (IJSECS)
Vol. 5 No. 2 (2025): AUGUST 2025

Student Data Visualization of Metro City Using Google Looker Studio

Pamungkas, Galih Putra (Unknown)
Saprudin, Usep (Unknown)



Article Info

Publish Date
01 Aug 2025

Abstract

Metro City educational landscape encompasses over 50,000 students across multiple institutional levels, yet systematic enrollment pattern analysis remains underdeveloped. Gender disparities and uneven institutional distribution challenge educational planners seeking evidence-based policy solutions. Our research examined student enrollment data from Metro City Education Department for the 2025/2026 academic year, focusing on gender balance and institutional representation across KB, TK, SD, SMP, SMA, SMK, and SLB schools. Using descriptive quantitative methodology, we processed secondary data through spreadsheet applications before implementing Google Looker Studio visualization. The platform transformed numerical datasets into interactive dashboards featuring bar charts, pie diagrams, and filterable tables accessible to non-technical stakeholders. Analysis revealed unexpected findings challenging conventional gender imbalance assumptions. Rather than anticipated male dominance, data showed near-equal gender distribution (55% male, 45% female) across 64 institutions serving 14,298 students. However, enrollment concentration became apparent when SMP Muhammadiyah Ahmad Dahlan Metro accounted for 50% of total student population, potentially skewing statistical interpretation. Educational staff demographics differed significantly, with female educators outnumbering males 2:1, suggesting professional preference rather than access barriers. Google Looker Studio demonstrated practical effectiveness for real-time data processing, enabling rapid information retrieval and policy formulation support. Research limitations include single-year scope without longitudinal analysis or socio-economic variables. Future investigations should incorporate historical perspectives and predictive modeling. The visualization platform successfully addressed research objectives, providing Metro City education leadership with actionable insights for policy development and resource allocation strategies.

Copyrights © 2025






Journal Info

Abbrev

ijsecs

Publisher

Subject

Computer Science & IT

Description

IJSECS is committed to bridge the theory and practice of information technology and computer science. From innovative ideas to specific algorithms and full system implementations, IJSECS publishes original, peer-reviewed, and high quality articles in the areas of information technology and computer ...