04 Apr 2026
What Three Census Editions Reveal About Melbourne's Demographic Shift
Using the harmonised census dataset I built earlier, I looked at how Melbourne's birthplace, language, and religion profile has changed from 2011 to 2021 - and what a 2026 projection suggests...
Analysis ABS Census Python Demographics Melbourne
03 Apr 2026
What I Look for Before Trusting a Dataset
Before I build a dashboard, automate a report, or start analysing trends, I try to answer one question first: can this dataset actually be trusted? Here's what I check before relying on data for decisions.
Methods Data Quality Analytics Decision Making Reporting
30 Mar 2026
How I Harmonised ABS Census Data Across Changing Suburb and LGA Boundaries
Australian census geography changes over time, which makes suburb and LGA trend analysis much harder than it looks. Here's how I used SA1 data, ABS allocation files, and correspondence files to...
Methods ABS Census Python Demographics
28 Mar 2026
What's Actually Driving Lego's Growth?
Lego has tripled the number of sets it launches per year since 2005. But the growth isn't just about more sets — it's a strategic shift toward licensed IP and the adult market that's fundamentally...
Analysis FMCG Range Review Data Analysis
23 Mar 2026
How Three Datasets Reversed a -48% Product Decline
A core product range was declining at -48% year-on-year. No single dataset could explain why. Here's how combining scan data, consumer panels, and custom research identified the root cause and...
Case Studies FMCG Category Management Data Analysis