Metrics & Measurement
The Right Way to Measure ROI on Data Quality
Introducing a better approach for measuring the cost of bad data to your business. No hand-waving required.
April 25, 2021
Data-Driven, Demystified.
Show Me The Data is a curated collection of articles that explore ideas from adjacent disciplines to help you make better business decisions.
Analytics Engineering
Escaping SQL Traps with the Unified Star Schema
The Chasm Trap and the Fan Trap are two common SQL JOIN mistakes that cause unwanted duplicates in the result of queries. The Unified Star Schema is a powerful new solution to these old problems.
April 11, 2021
Analytics Engineering
How Do Column Types Affect Join Speeds In Data Warehouses?
Does the type of your columns affect the speed of your joins in data warehouses? If so, by how much? Let’s run an experiment…
January 29, 2021
Analytics Engineering
Generating Unique Keys In BigQuery
If you’ve ever tried to build an enterprise data warehouse using BigQuery, you’ll quickly realize that the auto-incrementing primary keys you were so fond of
January 26, 2021
Analytics Engineering
Agile Machine Learning with dbt and BigQuery ML
What if I told you there was a way to drastically cut down the time it takes for you to deploy machine learning models to production using your data warehouse?
It’s totally possible with dbt and BigQuery!
January 4, 2021
