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