dbt (Data Build Tool) is an open source command-line tool for managing and automating data transformation workflows. It enables a standardised, modular approach to building analytics code and is typically used as part of an increasingly popular method of developing data warehouses and data platforms called analytics engineering. The analytics…

A couple of months ago I blogged about our experiments using ChatGPT to create dbt models and data transformations and I’m talking about this at the London dbt Meetup on July 12th 2023, if you’re in the area that evening. Since writing that blog back in May 2023, ChatGPT…

Google recently announced that first-click, linear, time-decay and positional marketing attribution was being removed from Google Analytics 4 and Google Ads in-favour of their data-driven attribution model. Data-driven attribution offers, in-theory, a number of benefits compared to “rules-based” models such as first-click and linear attribution, including being able to…

One of the new features added into Looker in the past year is integration with Looker Studio, the new name for Google Data Studio, along with similar integration with Google Sheets. Users of Looker Studio can now build reports using governed metrics and dimensions from their Looker semantic model while…

Everyone’s talking about ChatGPT, generative AI models and the impact they are likely to have on white collar jobs, software engineering (e.g. Github Co-Pilot) and more closer-to-home, data roles within the modern data stack. We can even use generative AI to create an opening illustration for this blog, reassuring illustrators…

Along with Recency, Frequency and Monetary Value (RFM) segmentation, one of the most valuable and actionable ways that you can segment your customers is by the first, last and most frequent products and services they order. The first product a customer orders from you is usually a good predictor of…

Looking back at the past year, a common request we had from new clients was to perform a healthcheck of their modern data stack and to provide enablement for their data team. The healthchecks have been for a number of different organisations and had a different choice of data stack…

The rise of the modern data stack has made it easier, cheaper and faster-than-ever for businesses to centralize their data. …

A few weeks ago when checking our company website stats in Looker, I noticed that our site traffic had dropped significantly since we updated it with our new branding back in August. My first thought was that something about the design, usability or changes we’d made to content we may…