Data Foundations

Data Modeling

How to shape raw data into documented tables, shared definitions, and durable business concepts.

Data Foundations

Ownership And Runbooks: Plain-English Guide

A practical guide to deciding who owns data work, what a runbook should contain, and how to keep data systems reliable after the first build.

Guide · 9 min · Beginner
Data Foundations

Analytics Handoff: Plain-English Guide

How to pass business questions, metrics, models, and ownership from one team or system to another without losing trust.

Guide · 8 min · Beginner
Data Foundations

Pipeline Freshness: Common Mistake

Why a successful pipeline run does not always mean the data is current, and how to model freshness so dashboards stay trustworthy.

Guide · 8 min · Beginner
Data Foundations

Backfills: Common Mistake

The practical mistake that causes historical data repairs to create new trust problems instead of fixing old ones.

Guide · 7 min · Beginner
Data Foundations

Customer Data Modeling: Common Mistake

Why most customer models fail by mixing people, accounts, subscriptions, and events into one unstable definition.

Guide · 9 min · Beginner
Data Foundations

Metric Definitions: Operator Checklist

A practical checklist for defining metrics clearly enough that dashboards, data models, and business conversations stay aligned.

Checklist · 9 min · Beginner
Data Foundations

Source System Drift: Operator Checklist

A practical checklist for spotting, triaging, and controlling changes in source systems before they damage models, pipelines, and dashboards.

Checklist · 9 min · Beginner
Data Foundations

AI-Ready Data: Operator Checklist

A practical checklist for turning messy operational data into data that analytics, automation, and AI systems can safely use.

Checklist · 9 min read · Beginner
Data Foundations

Warehouse First Analytics: Founder Framework

A practical way for founders to decide when the warehouse should become the center of reporting, modeling, and business measurement.

Guide · 10 min · Beginner
Data Foundations

Pipeline Freshness: Migration Playbook

A practical migration plan for making stale data visible, measurable, and fixable before users lose trust in the system.

Playbook · 9 min · Beginner
Data Foundations

Backfills: Migration Playbook

A practical beginner playbook for moving, rebuilding, or repairing historical data without breaking trust in the new model.

Playbook · 10 min · Beginner
Data Foundations

Customer Data Modeling: Migration Playbook

A practical way to redesign customer entities, identifiers, and history before migrating dashboards, pipelines, or CRM reporting.

Playbook · 12 min · Beginner
Data Foundations

Candidate Keys and Alternate Keys

A practical guide to separating possible row identifiers from the one you choose as the primary key.

Guide · 8 min read · Beginner
Data Foundations

Natural Keys Versus Surrogate Keys

How to explain identifier stability when a source system identifier can change, be reused, or stop meaning what it used to mean.

Guide · 8 min · Intermediate
Data Foundations

SQL Null and Three-Valued Logic

A practical guide to why UNKNOWN changes SQL filters, joins, constraints, and predicate reasoning.

Guide · 9 min read · Intermediate
Data Foundations

Set semantics versus bag semantics in SQL

A practical guide to showing why duplicate rows survive normal SQL queries unless you explicitly remove or prevent them.

Guide · 8 min read · Intermediate
Data Foundations

First Normal Form and Repeating Groups

How to reshape repeated attributes into child rows while keeping the original parent record clear and queryable.

Guide · 9 min read · Beginner
Data Foundations

Lossless Decomposition of Relational Tables

A practical guide to proving whether decomposed tables join back to the original records without missing or invented rows.

Guide · 9 min read · Intermediate
Data Foundations

Entity Identity Versus Record Identity

A practical guide to separating a business thing from the many rows that describe, observe, or mention it.

Guide · 9 min · Intermediate
Data Foundations

Unit Conversions in Analytical Models

How to store original units, normalized values, and conversion provenance without losing numeric meaning.

Guide · 9 min · Intermediate
Data Foundations

Currency Conversion Dates in Reporting

How to tell whether a number should use the transaction date rate or the reporting date rate before it reaches a dashboard.

Guide · 8 min read · Intermediate
Data Foundations

Exchange-rate direction and inversion

A practical guide to preventing multiplication-versus-division mistakes in currency normalization.

Guide · 9 min read · Intermediate
Data Foundations

Approximate Distinct Counts and Error Bounds

How to explain estimated unique counts honestly, set acceptable error, and avoid presenting probabilistic metrics as exact facts.

Guide · 9 min read · Intermediate
Data Foundations

Precision Loss in Identifier Conversions

How to keep long numeric identifiers from being rounded as they move through files, APIs, warehouses, spreadsheets, and BI tools.

Guide · 8 min · Intermediate
Data Foundations

Missing Measurements Versus Measured Zero

How to model unavailable observations separately from real absence of activity so totals, averages, rates, and alerts stay honest.

Guide · 9 min · Intermediate
Data Foundations

Fiscal Calendars and Reporting Periods

How to model fiscal boundaries without assuming months, quarters, or years line up with the calendar.

Guide · 9 min · Intermediate
Data Foundations

ISO Week Years Versus Calendar Years

How to explain why weekly reports around New Year can appear to move days into the “wrong” year.

Guide · 8 min · Intermediate
Data Foundations

Clock Skew in Distributed Event Logs

A practical guide to telling clock disagreement apart from real event reordering in multi-system logs.

Guide · 9 min · Intermediate
Data Foundations

Bitemporal Data Modeling

Represent corrected history without losing what your data system believed at the time.

Guide · 9 min read · Advanced
Data Foundations

Elapsed Duration Versus Calendar Duration

A practical guide to separating hours elapsed from calendar days advanced in data models, SLAs, and time-based metrics.

Guide · 8 min · Intermediate
Data Foundations

Factless Fact Tables for Coverage

How to model who or what was expected to participate separately from the events that actually happened.

Guide · 10 min · Intermediate