Skip to interview prep
Apexed

73. A report doubles revenue after joining orders to order lines. What would you check?

MediumData & validation

Technical
Show model answer

I'd check the grain and join relationships before assuming revenue actually changed. An order-level amount repeated across several line rows can be summed multiple times, so syntactically valid results may still answer the wrong business question using a misleading denominator.

I'd reconcile fictional cases and definitions with owners. Blind deduplication or distinct counts may also be wrong; preserve the actual measure and relationship rather than force an expected total.

What interviewers listen for

  • Identify grain and join cardinality
  • Reconcile representative cases
  • Do not deduplicate blindly
A report doubles revenue after joining orders to order lines. What would you check — Business analysis interview question — Apexed