About
Hey! I’m Dumky, analytics engineer. I’ve spent the first half of my working life in web analytics turning Google Tag Manager (GTM) inside out. Nowadays I spend most of my time working with dbt, building reliable data transformations and teaching teams how to write better SQL. I am co-author of The Fundamentals of Analytics Engineering together with some of my colleagues from Xebia Data. The book is a great way to familiarize yourself with the many topics involved in analytics engineering, from extracting and loading data, to governance, data modelling and data quality.
Start here
If you’re interested in some of my top and favourite posts, here are a few to get you started.
dbt and Analytics Engineering
- Beyond Tables and Views: Building a Custom dbt Materialization to Deploy Streamlit Apps on Snowflake
- Optimizing Snowflake Costs with dbt Query Tags
- Test Driven Development (TDD) with dbt: Test First, SQL Later
- Unit Testing dbt Macros: A workaround for dbt’s unit testing limitations
- Dbt In a Box: Using Google Cloud Run and BigQuery to run your dbt SQL models from a Docker container
BigQuery, SQL and data analysis
- Language Detection in SQL with BigQuery Remote Functions
- Tf-Idf in Google Sheets: implementing text analysis, keyword counting, tokenisation and stemming in a spreadsheet
- A Visual Leviathan: Hobbes’ Schizophrenic Writing
Consent and browser automation
- Check Cookie Consent with Playwright’s browser automation in Python
- Analytics and tag testing with Cypress
- Cookie Consent: A Simple Checklist for Compliance
Google Tag Manager (GTM) & Web Analytics
- Own your web analytics pipeline for €0.02 per day: Snowplow, Terraform, dbt, BigQuery and Docker
- How I got millions of credit card details using agencies’ Google Tag Manager (GTM) accounts
- 8 ways to optimise Google Tag Manager (GTM) for speed and performance
- Using GTM with a Content Security Policy (CSP) and impress your DevOps team in the process
- DocTags: automatically generate documentation from the notes field in Google Tag Manager (GTM)
- Building a complete tag monitoring solution for Google Tag Manager