Blog

In my last article, I went through how I turned the raw GA4 export into a star schema with dbt. This one picks up where that left off, in two parts: first the… Read more: Building a Power BI report on top of a GA4 star schema

Since GA4 was first introduced, a commonly touted benefit was the ability to export the raw event-level data, and create your own analysis with that data. This is amazing! We were finally able… Read more: Turning raw GA4 data into a star schema with dbt

I have used many different trackers in my career and always thought, how does it work under the hood? What would it take to build a simple web analytics tracker myself? Using server-side… Read more: How I built a Lightweight Web Analytics Tracker

Every year, the New Zealand Pie Awards crown the country’s best pies. Bakers from all New Zealand over compete for gold, silver, and bronze across a range of categories, from the classic steak… Read more: New Zealand Pie Awards Map

For this project, I dove into Melbourne’s public transport disruptions using data engineering and analysis. I wanted to get a better understanding of disruption patterns across the Metro Trains, Metro Trams, and Metro… Read more: Exploring Melbourne’s Public Transport Disruptions: My Data Project