David Krevitt

Union'ing two or more tables with a long list of columns can be an error-prone chore, which dbt + dbt_utils abstracts away.

DATEADD Function syntax varies across data warehouses. Learn how to standardize your syntax no matter the container.

David Krevitt | Jason Ganz | Sanjana Sen 30 Jun 2022

What's a surrogate key, and how can you generate them across BigQuery, Databricks, Redshift, Snowflake and other data warehouses?

Two fundamental technological advances, ETL tools and cloud data warehouses, enable analytics engineers to practice the ELT workflow.

Christine Berger | David Krevitt | Randy Pitcher

Explore practical examples of modular data modeling techniques from traditional to modern and modular techniques.

The tale of migrating from a stored procedure-based ELT workflow to an ELT data transformation workflow on BigQuery, and the 3x productivity gains that ensued.

Reporting quality can make or break your data team's reputation - will your colleagues cherish your visualizations, or question their validity?

Organize your organization's information with a high-quality data documentation process.