Uncategorized

Illustration of two people assembling abstract shapes and data icons into a structured wall. One person is holding a green triangle and a square, while the other holds a circle and a square. The wall features icons like a lightbulb, chart, magnifying glass, and pie chart, symbolising collaboration, analysis, and innovation.

Easy ways to prepare your BigQuery warehouse for AI

You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the…
Illustration of a modern data pipeline workflow featuring cloud storage, automation, data analytics, and mobile integration, representing streamlined data processing and operational efficiency.

Data pipeline optimisation with Google Cloud and Dataform

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

Dataform for BigQuery: A basic end-to-end guide

Dataform is a powerful tool for managing your data workflows in a structured, version-controlled, and automated way. Whether you're a…
A visual depiction of cloud computing, illustrating clouds connected by lines, symbolising data transfer and technology.

How to extract GA4's event sequencing in BigQuery using the new batch fields

Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending…
Illustration of a crystal ball connected to various data and automation symbols, including gears, a pie chart, a computer, and a magic wand, representing analytics and automation.

Automating BigQuery workflows with conditional logic and data readiness checks

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

2024: Measurelab's year in review

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

How to set up a Dataform repository with GitHub & Google Cloud integration

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

The life of Brian: Measurelab's generative AI journey

I recently had the pleasure of attending the AI Summit London 24 which was chock full of fascinating talks, opinions…

2023: Measurelab's year in review

2023 was a momentous year for Measurelab. It marked a decade of delivering analytics excellence to the world, a year…

How to debug your SQL in BigQuery

How often have you run your code in BigQuery only to find a bit of data missing that you KNOW…