dataarchitect.studio

Topic — 7 essays

Data Architecture

Warehouses, lakes, lakehouses, medallion layers, and the modern data stack — where data should live, how it should be layered, and which structures earn their complexity.

01

Field Notes

Kimball vs Inmon: Two Ways to Build a Data Warehouse

Kimball and Inmon are the two foundational approaches to building a data warehouse. The difference is one decision: build dimensional marts bottom-up, or a normalize...

Jun 14, 20265 min
02

Reconsidered

Is the Modern Data Stack Dead?

The modern data stack isn't dead — but the era of bolting together a dozen best-of-breed SaaS tools as the default is ending. Here's what's actually happening, and w...

Jun 09, 20264 min
03

Field Notes

Data Warehouse vs Data Lake vs Lakehouse: A Clear Comparison

A data warehouse stores structured, modeled data for analytics. A data lake stores raw data of any shape, cheaply. A lakehouse tries to be both. Here's the real trad...

May 30, 20265 min
04

Essay

What Is a Semantic Layer, and Why Does Your Data Stack Need One?

A semantic layer is the single, governed place where business metrics are defined once — independent of any dashboard. Here's what it is, what it isn't, and why it f...

May 28, 20264 min
05

Reconsidered

The Medallion Architecture, Reconsidered

Bronze, silver, gold is a useful default and a dangerous dogma. A second look at what the layers get right, and where they quietly fall apart.

May 27, 20264 min
06

Field Notes

OLTP vs OLAP: Why You Shouldn't Run Analytics on Your App Database

OLTP systems handle many small transactions fast. OLAP systems scan huge volumes for analysis. They're optimized for opposite things — which is why querying your pro...

May 23, 20265 min
07

Manifesto

The Shape of Data

Every dataset has a shape. The only question is whether you chose it, or whether it happened to you.

Apr 22, 20264 min