• Metrics & Measurement

Your Conversion Rates Are Lying To You

3 years ago

Your conversion rate metrics are lying to you in subtle ways. Can you avoid the hidden traps when using conversion rates to set targets?

  • Metrics & Measurement

The Surprising Power Of Small Samples

3 years ago

How much does a sample of 1 tell you about a particular metric or measurement? The answer will surprise you.

  • Analytics Engineering

How Do Column Types Affect Join Speeds In Data Warehouses?

3 years ago

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...

  • Analytics Engineering

Generating Unique Keys In BigQuery

3 years ago

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 in operational databases are not a thing in BigQuery.  This is by design. It's not…

  • Metrics & Measurement

How To Measure What You Can’t See

3 years ago

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?

  • Decision Making

Absence of Evidence IS Evidence of Absence

3 years ago

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.

  • Analytics Engineering

Agile Machine Learning with dbt and BigQuery ML

3 years ago

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!

  • Business Analytics

Please Stop Using Scorecards to Make Critical Business Decisions

3 years ago

Weighted scorecards are great for making a good decision quickly... Wait a minute... Are they?