
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…
Show Me The Data is a curated collection of articles that explore ideas from adjacent disciplines to help you make better business decisions.
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…
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
How can you count things like to total number of fish in the sea, or drug users in a city, when you can only see a small subset of the population?
You hear this phrase left and right, yet it couldn’t be farther from the truth. Let’s use Bayes’ theorem to break down why this statement is untrue.
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!
Weighted scorecards are great for making a good decision quickly… Wait a minute… Are they?