Transaction Fact Tables: Model Atomic Business Events Without Summary Rows
A practical guide to designing event-level fact tables that reconcile cleanly and do not mix transactions with rollups.
The ColdStart Data blog
A blog about data engineering, analytics, and the details that make data reliable. Explore practical guides, field notes, and lessons on everything from a first warehouse to AI-ready data.
From the blog
A practical guide to designing event-level fact tables that reconcile cleanly and do not mix transactions with rollups.
A practical guide to designing snapshot facts for balances observed at regular intervals, including days with no business activity.
A practical guide to modeling processes such as orders, claims, tickets, and applications as one row that updates as milestones are completed.
How to model who or what was expected to participate separately from the events that actually happened.
A practical way to state which dimensions permit summation before a metric reaches a dashboard.
How to keep invoice, order, ticket, or receipt identifiers in a fact table without building empty dimensions.
Topics
Practical guidance for choosing and arranging ingestion, warehouse, modeling, orchestration, and BI tools.
How to shape raw data into documented tables, shared definitions, and durable business concepts.
Methods for making dashboards credible, explainable, and consistent with the way the business operates.
Move from spreadsheets, legacy databases, or tangled scripts into a cleaner stack without breaking reporting.
Use scheduling, retries, alerts, and runbooks to make routine data work quiet and dependable.
Prepare clean, governed, contextual data so AI systems have something trustworthy to use.
Reading tracks
Collections of articles for exploring a subject from the foundations onward.
Build the warehouse, naming conventions, models, and source-of-truth habits that make every later data project easier.
Turn fragile scripts and silent failures into monitored, observable, recoverable data movement.
Design metrics, dashboards, and business definitions that match reality and survive operational pressure.
Prepare governed, documented, well-modeled data before adding AI workflows on top of the business.