How-To

Modern data warehouses have upended the way that data teams function. Increasingly, companies are hiring a new kind of technical analyst to bridge the gap between data engineers and data analysts. Here's why and how you can hire one too.

Advice from analysts and data engineers at HubSpot, Managed by Q, GitLab, Wong Decision Intelligence, AskWonder, and Calogica

Stephen Whitworth, Data Engineering Lead at Monzo, spoke at the London dbt Meetup a few weeks ago. Here are my thoughts on his talk and what the dbt community can learn from it.

Unnesting arrays on Redshift is a pain, but it’s doable. This post walks through the entire process, start to finish.

At Fishtown Analytics, we've set up Snowflake accounts for several dozen clients and have an approach we like quite a lot.

If you’re a hotshot junior analyst and you want a guide for breaking through this skills plateau, this guide is for you.

This is a very stupid problem. I am not writing this post because it’s a fascinating topic—rather, I’m writing it in the hopes that you avoid the headaches I've gone through.

I got this question on my last post. It is a good one, and one that I’ve gotten a bunch of times over the past year and a half. This post is my attempt to answer it.

dbt and Looker were built with the same ethos: analysts should be working in code.

Frequently asked questions about Looker explores and how to design them very well.

Want to go from syncing new data to having transformed data models built in minutes? Packages are going to be your friend.

Over the past nine months I’ve worked with over a dozen venture-funded startups to build out their internal analytics. In doing so, there’s a single SQL function that I have come to use surprisingly often.