Indonesia Education Data Analysis

Why This Project

I was curious: how wide is the education gap between provinces in Indonesia? The data exists across BPS (national statistics bureau), but rarely compiled and compared side by side. So I did it myself.

What I Did

• Collected data from BPS: Human Development Index (HDI), average years of schooling, open unemployment rate, and primary school infrastructure per province
• Cleaned and merged datasets across multiple years (2017-2023)
• Created visualizations comparing provinces and tracking trends over time
• Analyzed correlations between schooling duration, HDI, and unemployment

Interesting Findings

• Provinces with high average schooling years don’t always have the highest HDI. Other factors are at play.
• The infrastructure gap between Java and outer islands remains wide.
• Some provinces show significant improvement over the last 6 years, especially in Sulawesi and Kalimantan.

What I Learned

This was my first serious project with Indonesian public data. The hardest part wasn’t the analysis, it was cleaning the data. BPS formats are inconsistent across years, province names change, and missing values need careful handling to avoid misleading conclusions.