Although dbt doesn’t directly support UDFs, it’s actually fairly straightforward to define, test and reference them in your models. Data specialist Paul Brabban explains how.

Whatever your role, you might come into contact with a data warehouse at some point. They’re incredibly powerful tools that are frequently ignored or used in ways that cause problems. This post contains tips for handling data in your data warehouse effectively.

Our experience has taught us that building data pipelines can be complex, especially if you are new to them. Here are some of the pitfalls we’ve come across when building data pipelines in partnership with clients. It’s our hope it will help you to navigate them in the future.

As concerns grow over NHS Digital’s plans to share patient data, now is the perfect time to read David Cox’s article on how organisations and individuals can ensure effective ‘data guardianship’.

A data pipeline transports your data from where it is generated to where it can be analysed. Discover how effective ones are critical for any organisation that wants to take data analysis seriously and generate insight that leads to business value.

Our analysis has shown that client interest in data governance is motivated by a wide range of reasons. Here we analyse survey results, discussions with clients and our own experiences to understand better how to talk with IT leaders who see data governance as a challenge.