Skip to interview prep
Apexed

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
Sales and finance use different customer counts. How would you resolve the discrepancy — Business analysis interview question — Apexed