← Back to Projects

Regional Socioeconomic Analysis / Data Analytics

Sydney SA2 Analysis

Sydney SA2 Analysis

Apr 2025 - Jun 2025

Overview

A regional socioeconomic analysis project using PostgreSQL, Python, and Tableau to study Sydney SA2 regions and construct interpretable indicators of regional prosperity.

My Contribution

  • Conducted large-scale regional socioeconomic analysis leveraging PostgreSQL and Python across Sydney SA2 regions.
  • Integrated demographic, business, transport, and education datasets to construct interpretable indicators of regional prosperity.
  • Performed data cleaning, transformation, and spatial analysis to support evidence-based insights.
  • Collaborated within a project team to develop interactive Tableau dashboards and communicate findings to non-technical audiences.

Evaluation / Outputs

  • Interactive Tableau dashboards
  • Interpretable regional prosperity indicators

Methods / Tools

PythonPostgreSQLTableauSpatial analysisData cleaning and transformation

Tags

PythonPostgreSQLTableauSpatial AnalysisData CleaningSocioeconomic AnalysisDashboardTeam Project