Google Cloud

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…

Mastering data loading in BigQuery using Dataform

Efficient data loading is crucial for managing and updating tables in Dataform. Various strategies exist to handle different use cases,…

How to set up a Dataform repository with GitHub & Google Cloud integration

Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to…

The complexity paradox: why your spreadsheet is complex and BigQuery is simple

Understanding complexity Everything is complex until you understand it. And yet, not all complexities are created equal. This is the…

You’re sitting on a SQL time bomb: defuse it with Dataform

As a marketing team's maturity evolves, disparate data sources centralise, increasingly sophisticated SQL queries begin to pull together insights and…