ENGINEERING DATA / INTERACTIVE LAB

Analytical Truth Lab.

See how grain and join cardinality can silently corrupt otherwise valid analytics.

ANALYTICAL TRUTH

data contracts before dashboards

EXPECTED GRAIN1 row/task

ROWS4

TRUE HOURS22

REPORTED HOURS22

INFLATION0%

TASKS4 rows · task grain

⟶ AGGREGATE THEN JOIN ⟶

EVENTS7 rows · event grain

RESULTING METRIC ROWS · EACH BLOCK CARRIES TASK HOURS

T15hT28hT33hT46h

4 task-grain rows → 22 additive hours

Event data is aggregated to task grain before the join. The metric remains additive and traceable.