Senior Data Analyst

Melbourne-based analytics, data products and applied AI grounded in 10+ years of commercial experience.

Melbourne, Australia

← Back to case studiesCase Study · Public Data

LGA Language Explorer

An interactive Australian Census dashboard built from harmonised 2011, 2016 and 2021 data, allowing non-technical users to compare language change across suburbs and local government areas.

pythonpublic datadata visualisation
Open dashboard →
josephsaba.me/lga_languages.html
LGA Language Explorer project screenshot

01 - The problem

Census geography changes make local trends hard to trust

Suburbs split, LGAs merge, and boundaries shift between Census years. A simple comparison can accidentally mix boundary change with real demographic change.

02 - What I built

A searchable local demographic report

I rebuilt the data from SA1 level using ABS correspondence files to harmonise 2011, 2016, and 2021 onto consistent boundaries, then added a projection layer for 2026.

03 - Walkthrough

From place search to local context

language explorer
Search. Pick any suburb or LGA and generate a local field report.
brisbane trend
Trend. The same data layer feeds deeper city-level analysis.

04 - Outcomes

What it covers

8,465

suburbs in the source geography

549

LGAs available for comparison

15 years

of harmonised Census trend data

2026

projection layer for near-term planning

Related analysis

How the data was built and analysed

Read the Census harmonisation methodology or explore the broader Australian public data and demographic analysis guide.

Built with

Python, FastAPI, JavaScript, harmonised ABS Census extracts, SA1 correspondence files, static JSON data, and a client-side search/report interface.

pythonjavascriptabs censusdata harmonisationpublic dashboard

Keep exploring

See the rest of the case studies

← Back to case studies