12. Sales and finance use different customer counts. How would you resolve the discrepancy?
MediumData & validation
Technical
Show model answer
Compare scope, grain, date, source, and exclusions. Sales may count active accounts while finance counts billed legal entities; both can be valid for different decisions.
Reconcile a safe sample with the owners and agree which definition serves the requested use. Document a bridge between measures instead of forcing one total to match by deleting unexplained records.
What interviewers listen for
- Compare definitions and grain
- Reconcile with owners
- Preserve legitimate measures