Insights

SQL

SQL queries, database management, and data analysis techniques (134 posts)

Browse the archive

134 results · Page 4 of 8

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 when we were named one of the UK’s best places to work and became a fully-certified GCP partner, a summer that saw the sunsetting of Universal Analytics, followed by the new dawn of generative AI and the beginning of an augmented analytics era. Into the sunset From the very beginning of January, right up to the deprecation deadline of July 1st, we were swamped with GA4 migratio

Steven Elliott-22 Dec 2023

#92 Christmas Special: Year in review and predictions for 2024

In this week's episode of The Measure Pod, it's our Christmas special! Dan and Bhav discuss the highs and lows of the past year, and predictions for 2024.

Will Hayes-22 Dec 2023

#91 Warehouse native analytics (with Adam Greco @ Amplitude)

In this week's episode of The Measure Pod we spoke to Adam Greco from Amplitude. We talked specifically around warehouse native analytics, and whether it's a passing trend or an integral part of the future.

Will Hayes-15 Dec 2023

Connecting GPT to BigQuery: Zapier AI actions

Using Zapier AI automation, we aim to build our very own GPT capable of grabbing data from BigQuery for analysis.

Matthew Hooson-20 Nov 2023

How to debug your SQL in BigQuery

Discover how to efficiently troubleshoot and find missing data in your code. Dive deep into the step-by-step process of querying code segments in BigQuery, leveraging CTEs, and ensuring you understand the flow of your data. Master the art of debugging with hands-on examples.

Katie Kaczmarek-3 Nov 2023

The Google Cloud tools of the marketing analytics trade

The GCP is vast and overwhelming. We aim to sort through the clutter and help highlight what you need to know as a digital marketing professional.

Matthew Hooson-2 Nov 2023

Gathering insights at MeasureCamp London 2023 (BONUS)

Full show notes, transcript and (NEW!) AI chatbot - https://bit.ly/3tEDQL8. 00:00 Start 00:15 Intro 00:40 Main topic 00:40 What’s the biggest challenge today which will be gone in five years time? 03:42 What will be the biggest challenge in the next five years? 07:53 Outro ----- Episode Summary:

Will Hayes-25 Oct 2023

#90 Self-serve analytics: yay or nay

In this week's episode of The Measure Pod, Bhav reflects on his biggest career failure: self-serve analytics. They discuss the challenges and complexities of implementing self-serve analytics in organisations, highlighting the factors that contribute to its success or failure.

Daniel Perry-Reed-13 Oct 2023

#89 Integrating analytics into product teams (with Barry Pace @ Penfold)

In this week's episode, Dara, Bhav, and Barry dive into the world of product management and analytics. They discuss the importance of integrating analytics into the product development process and how it can enhance decision-making.

Daniel Perry-Reed-6 Oct 2023

#87 A/B testing controversies and generative AI (with Shaun McGirr @ Dataiku)

In this week's episode of The Measure Pod, we speak with Shaun McGirr from Dataiku. We explore the world of A/B testing, experimentation, and the future of analysts' roles as generative AI becomes more prevalent.

Daniel Perry-Reed-22 Sept 2023

#86 The evolving challenge of SEO measurement (with Alex Harvey @ ASOS)

In this episode Dan, Dara and Bhav had the pleasure of chatting with Alex, Head of SEO & Marketing Technology at ASOS.

Daniel Perry-Reed-15 Sept 2023

#85 Who cares about data literacy?

Join Dan, Dara and Bhav dive into the topic of data literacy, discussing the importance of data curiosity, data storytelling, and effective data communication.

Daniel Perry-Reed-8 Sept 2023

#84 The future of product analytics tools

Join Dan, Dara and Bhav discuss the future of product analytics tools and the intersection between product analytics and marketing analytics.

Daniel Perry-Reed-1 Sept 2023

#83 GA is dead, long live GA!

In this week's episode of The Measure Pod, Dan, Dara and Bhav delve deep into the transition from Universal Analytics (UA) to Google Analytics 4 (GA4).

Daniel Perry-Reed-25 Aug 2023

The Derelict Data Warehouse

A well-maintained and utilised data warehouse is a thing of beauty. Imagine all your data from disparate sources autonomously extracted, loaded and transformed into nice neat reporting tables. Picture, if you can, impactful analysis, company-wide data-driven decision-making, a true understanding of return on ad spend. It’s enough to make anyone weak at the knees. But therein lies the problem. Companies (or ambitious individuals) can be too desperate to reach the promised land and rush headlong

Matthew Hooson-24 Aug 2023

#81 Marketing vs. product analytics

Dan and Dara kick off a new season of The Measure Pod by introducing Bhav Patel as a guest co-host and discussing all things marketing and product analytics.

Daniel Perry-Reed-11 Aug 2023

#80 A chat about $PodcastSubject with $GuestName (with Rasmus Houlind @ Agillic)

This week Dan and Dara are joined by Rasmus Houlind - author of the book Hello $FirstName and CXO at Agillic.

Daniel Perry-Reed-12 May 2023

#79 Quant and qual data, different but complementary

This week Dan and Dara chat about quantitative and qualitative data, the merits of each type, and how they need to be used together and not siloed away in different teams.

Daniel Perry-Reed-5 May 2023

What we do

Keep your measurement working as things change.

Diminishing data

Cloud technology

AI disruption

SQL