Project Every Record Counts: Data Engineering for Backend Engineers
Part 4: "Grain Before Glory" — Dimensional Modeling
A discount report that counted each basket once per line, stock summed across days, refunds in the wrong quarter. Rohan builds Larkspur's first star schema in DuckDB: grain, facts and dimensions, fact table types, slowly changing dimensions, as-of joins and early-arriving facts.