Blog

Insights and Perspectives from a hands on Data Consultant

Blog posts that are genuinely useful to the everyday engineer.

Data Engineering

What makes dbt (Data Build Tool) so popular?

What is all the fuss about this revolutionary tool?

Series of yellow steps with the top step highlighted red

Analytics Engineering

Recursive queries for levelling up your hierarchies

An Analytics Engineers guide to querying hierarchical data and creating a dimension using a dynamic pivot in dbt.

Mockup dbt for dummies book

Analytics Engineering

dbt (Data Build Tool) - Frequently Asked Questions

Some very basic FAQs about dbt (Data Build Tool) for beginners.

Data Engineering

Snowflake cost and efficiency optimisation checklist

An easy to navigate checklist of things to consider in order to optimise your snowflake environment and help reduce costs and increase efficiency.

A spread of pin nails with thread tied between

Data Architecture

How to choose the right data modelling technique for your project.

A brief guide to all the different modelling methods and when to use them.

A Stack of Pancakes

What is the Data Renaissance Stack?

We've heard of the Modern Data Stack, but when does it stop being modern?