Insights
SQL queries, database management, and data analysis techniques (134 posts)
Explore a topic across our insights
134 results · Page 2 of 8
In this episode of The Measure Pod, Dara and Matt are joined by Verónica Delgado-Benito to chat through her journey from molecular biology PhD to data analyst at Springer Nature.
In this episode of The Measure Pod, Dara and Matt dive into a whole mix of marketing analytics news and musings. From new BigQuery features and GA4 updates to ChatGPT integrations and data quality best practices.
In this episode of Behind the Cloud, Matt explores BigQuery’s new Data Preparation feature, an AI-powered, point-and-click tool for transforming data with ease. From natural language transformations using Gemini to automated workflows and scheduled outputs, learn how Google is simplifying data prep for analytics and machine learning. Video transcript [00:00:00] Hello and welcome to another episode of Behind the Cloud. Today we are gonna look at a feature or a service, or whatever you wanna ca
You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the thing: AI isn't magic. If you want it to be accurate and useful, you need to set it up for success. One of the best ways to do that? Improve the metadata in your BigQuery warehouse. Metadata is like the index or contents page in a book, it quickly tells you exactly what’s inside and where to find it. Creating clear metadata means AI can more easily understand your data warehouse
In this episode of The Measure Pod, Dara and Matthew take the reins and dive into the biggest takeaways from Google Cloud Next 2025.
Dataform is a powerful tool for managing your data workflows in a structured, version-controlled, and automated way. Whether you're a beginner or an experienced data engineer, Dataform simplifies SQL-based transformations while integrating seamlessly with Google BigQuery. Although this blog offers a basic introduction to Dataform's functionality, users can achieve significantly more with Dataform. From advanced scheduling, parameterised queries, and dependency management to complex data modelli
In this special episode of The Measure Pod, Dan and Bhav bid farewell as they step back from the show, making way for Dara to take the helm as a familiar voice returning to the podcast.
In this week's episode of The Measure Pod, Dan and Bhav are joined by Jorge Ahumada Garcia from Coppel, one of Mexico’s largest retailers and banks.
Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending them, making GA4 event sequencing in BigQuery more complex. Fortunately, three fields—batch_event_index, batch_ordering_id, and batch_page_id—help provide precise sequencing information. For a full schema of the GA4 export, head over to google documentation. This article breaks down these fields in a clear, practical way and shows how to use them togethe
In this episode of The Measure Pod, Dan and Bhav are joined by Ole Bossdorf, an analytics expert at venture capital firm Project A, which boasts a portfolio of over 120 companies.
In this week's episode of The Measure Pod, Dan and Bhav are joined by János Moldvay from Funnel to dive into the intricacies of Marketing Mix Modeling (MMM), Multi-Touch Attribution (MTA), and the future of marketing measurement.
In this week's episode of The Measure Pod, Dan and Bhav dive into the intricate world of product analytics.
Managing scheduled queries in BigQuery often feels limiting — there’s no version control, no easy collaboration, and scaling can be difficult. If you’ve ever wondered how to make SQL workflows smoother, Dataform is your answer. In this post, I’ll show you how I migrated a BigQuery scheduled query to Dataform and how it transformed the way I manage my data pipelines. After all, we all want to know who’s been touching our queries, don’t we? Getting started in Dataform First thing you need to
Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to optimise your workflow, this guide will show you how to seamlessly connect it with GitHub and Google Cloud (GC). What is Dataform and why use it? Dataform is a powerful tool for managing version-controlled SQL workflows in a collaborative way. GC incorporates BigQuery and GitHub integration, providing an efficient way to organise and maintain complex data pipelines. Let’s bre
In this episode of The Measure Pod, Dan and Bhav welcome back Adam Greco from Amplitude.
This week's episode of The Measure Pod was recorded live at MeasureCamp London, where Dan and Bhav discussed the future of analytics, specifically what it could look like in the next decade.
Learn how Dataform can solve the challenges of outdated SQL, improving data reliability, scalability, and efficiency for marketing teams.
In this week's episode of The Measure Pod, Dan and Bhav had the pleasure of speaking with Gabor Mester, a seasoned analytics professional who has spent over 13 years at Sony, specifically with PlayStation.