Blogs

Our Recent Articles

Practical writing on business intelligence, data engineering, and applied AI — the things we keep explaining in client workshops, written down.

AnalyticsSeptember 15, 2026

The Join That Silently Deleted Rows

Orders present in the raw table and in the intermediate model were missing from the final one. Nothing errored. Two ordinary-looking pieces of SQL were quietly discarding rows.

Data EngineeringFebruary 17, 2026

When Your Schema Is Inferred From One Sampled Row

A transformation job failed intermittently for weeks. The cause was a field that arrives as an object in most documents and an array in a few — and a macro that guessed the type by sampling a single row.

AIOctober 9, 2025

Tokens, Tokenization, and Vocabulary in AI Engineering

How language models represent text — what a token actually is, why tokenization exists, and why vocabulary size is a trade-off every model makes.

AnalyticsOctober 1, 2025

Orchestrating Reliable Data Pipelines With Apache Airflow

Why teams outgrow cron jobs, and how treating workflows as code — with retries, backfills, and visible DAGs — turns fragile pipelines into infrastructure you can trust.

AnalyticsSeptember 1, 2025

Understand the Analytics That Leaders Actually Use

Vanity metrics look like progress but rarely change a decision. How to move from dashboards that reassure to analytics built around the choices leaders actually have to make.