The Modeling Room: (M3) Build & connect the warehouse models - (A18) Compare facts safely
Series: The Modeling Room, module 3, article 18 of 26. Joining labor and parts rows on job number repeats both charges and still looks complete. Learn to aggregate each fact separately, compare the subtotals at one grain, and reconcile every total against its own input.
Who should read it?
Students learning modelstorming, analysts, report builders, data modelers working with business experts
Prerequisite
You can say what one input row means and keep job milestones separate from labor occurrences, as in article 17
Learning objectives
Compare 2 separately recorded facts without multiplying their measures and prove the result by reconciliation
Artifact
A comparison card with both input grains, scope, population policy, and reconciled subtotals
Why this matters
A labor and parts report can show every charge twice and still look complete. On JOB-2042 a joined report said EUR 180.00 where Mia Chen's 2 activities recorded EUR 90.00. Nobody edited a record. The join repeated it. This lesson shows how to compare two facts without multiplying either.
What you'll learn
- Why a raw join on job number repeats both measures, and how that multiplication happens.
- How to compare two facts with drill across: aggregate each side first, then place the summaries beside each other.
Your output: a comparison card with both input grains, one agreed comparison grain, and reconciled subtotals.
New terms: fanout and drill across