BI & Analytics
Semantic layers, dashboards, product analytics and governed self-serve BI.
5 long reads · 84 minutes in total
Product Analytics Pipeline: A Tracking Plan, RudderStack, and a Warehouse
A medium-scale AWS blueprint for governed product events, RudderStack routing, replayable S3 data, and analytics models in Redshift.
18 Nov 202619 min
BI & Analytics Interview Questions: Cohort Retention and Attribution SQL
Prepare for BI and analytics interviews with 13 questions on cohort design, retention SQL, attribution, experimentation, and analytical correctness.
13 Nov 202613 min
Power BI Architecture: Governed Models, RLS, and Safe Releases
A medium-scale Azure blueprint for trusted Power BI semantic models, dynamic row-level security, staged deployment, and operational visibility.
6 Nov 202618 min
BI & Analytics Interview Questions: Metric Semantics, Reconciliation, and Trust
A 14-question interview guide to defining, reconciling, serving, and monitoring trustworthy BI metrics across teams and tools.
2 Nov 202614 min
Self-Serve Analytics for a Startup: Metabase on PostgreSQL
A small-team blueprint for giving colleagues useful, governed analytics with Metabase and PostgreSQL—without introducing a warehouse, a data platform, or a second full-time job.
31 Oct 202620 min
Newsletter
Get new BI & Analytics reads on Saturday.
The week’s new long reads on architecture, cloud and AI — with the diagrams left in. Delivered Saturday morning, no noise in between.