You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the…

In our recent engagement with a client, we went on a journey to transform their data pipelines, tackling inefficiencies in…

Dataform is a powerful tool for managing your data workflows in a structured, version-controlled, and automated way. Whether you're a…

Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending…

BigQuery offers powerful scripting capabilities that can simplify complex workflows. In this post, we’ll explore two essential techniques: using IF...THEN...END…

Efficient data loading is crucial for managing and updating tables in Dataform. Various strategies exist to handle different use cases,…

Same same but different At the beginning of the year, I wasn't quite sure what Measurelab would look like by…

Managing scheduled queries in BigQuery often feels limiting — there’s no version control, no easy collaboration, and scaling can be…

Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to…

Offline event data import in Google Analytics 4 allows you to upload event data that was acquired outside of your…