Analytics Engineering

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

3 years ago
  • 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…

3 years ago
  • 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?…

3 years ago
  • 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…

3 years ago
  • 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…

3 years ago