Reporting Analytics

Getting data out of the warehouse and into a chart someone can act on. Practical posts on Power BI, BigQuery, and making reporting not terrible.

Standard SQL in BigQuery Cheatsheet

A one-page BigQuery Standard SQL reference, every snippet explained line by line: filtering and sorting, aggregates, GROUP BY versus HAVING, dates, joins and nulls, CASE, CTEs, window functions, views, and cost habits.

July 28, 2026

1 min read

Standard SQL in BigQuery: 10 Code-Along Examples

July 27, 2026

Flattening Nested Data with UNNEST Cheatsheet

July 26, 2026

Flattening Nested Data in BigQuery with UNNEST: 10 Code-Along Examples

July 26, 2026

EXISTS and NOT EXISTS in BigQuery Cheatsheet

July 26, 2026

EXISTS and NOT EXISTS in BigQuery: 10 Code-Along Examples

July 26, 2026

Semi-Joins and Anti-Joins in BigQuery Cheatsheet

July 19, 2026

Semi-Joins and Anti-Joins in BigQuery: 10 Code-Along Examples

July 19, 2026

Window Functions in BigQuery Cheatsheet

July 18, 2026

Window Functions in BigQuery: 10 Code-Along Examples

July 18, 2026

Transformer Models with PyTorch Cheatsheet

July 11, 2026

CSS Display Property Cheatsheet

Understanding the CSS Display Property: 10 Code-Along Examples

Standard SQL in BigQuery Cheatsheet

Standard SQL in BigQuery: 10 Code-Along Examples

Reporting Analytics

Standard SQL in BigQuery Cheatsheet

Standard SQL in BigQuery: 10 Code-Along Examples

Flattening Nested Data with UNNEST Cheatsheet

Flattening Nested Data in BigQuery with UNNEST: 10 Code-Along Examples

EXISTS and NOT EXISTS in BigQuery Cheatsheet

EXISTS and NOT EXISTS in BigQuery: 10 Code-Along Examples

Semi-Joins and Anti-Joins in BigQuery Cheatsheet

Semi-Joins and Anti-Joins in BigQuery: 10 Code-Along Examples

Window Functions in BigQuery Cheatsheet

Window Functions in BigQuery: 10 Code-Along Examples

Transformer Models with PyTorch Cheatsheet

Reporting Analytics

Subscribe to My Newsletter