Skip to content
PHP2Shell: The PHP Bug
Akshay Thakare

Data Modeling

Grains, keys, normalisation and modelling for analytics.

4 notes · all topicsWarehousing & lakehouse

Start here · beginner2

  1. 1Normalization in Plain English: 1NF, 2NF, 3NFWhat each normal form removes, why OLTP schemas are normalized, and why analytical models deliberately denormalize.
  2. 2Star Schema Basics: Facts, Dimensions and GrainDesign analytics tables that answer business questions quickly and correctly — starting from the grain.

Next · intermediate2

  1. 3Surrogate Keys vs Natural KeysWhy warehouses add their own integer or hash keys, how they enable SCD2 history, and when a natural key is good enough.
  2. 4Three Kinds of Fact Tables: Transaction, Snapshot and AccumulatingMost facts fit one of three patterns. Picking the right one decides whether questions like 'what was the balance on the 1st?' are easy or impossible.