Uncategorized

Measurelab Dataform webinar with speakers Katie Kaczmarek and Matthew Hooson on dark blue background.

Webinar: Meet Dataform, the smart solution to fragile SQL setups

In this 30-minute webinar, learn how to bring structure and sanity to your SQL workflows, without adding complexity. We cover…
Google Cloud Marketing Analytics specialization badge with colorful geometric background elements and Google Cloud logo.

Measurelab awarded Google Cloud Marketing Analytics Specialisation

At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s…
Measurelab webinar banner titled 'Stop the Martech Madness! Go composable. Deliver value faster.' with photos of Matthew Hooson and Mark Rochefort.

Webinar: Stop the martech madness! Go composable. Deliver value faster.

In this 30-minute webinar, we use three real-world examples to demonstrate how a composable approach can help you do more…
Cartoon of AI and SQL as friendly characters chatting with speech bubbles.

BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights

BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation:…
Illustration of a crystal ball connected to gears, a pie chart, a computer, and a magic wand, symbolising automated forecasting.

How to start forecasting in BigQuery with zero training

If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion…
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…