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.

The Modeling Room: (M3) Build & connect the warehouse models - (A18) Compare facts safely

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

This post is for paying subscribers only

Already have an account? Sign in.