Skip to interview prep
Apexed

77. Why can joining today's customer status to last year's transactions mislead a historical report?

HardData & validation

Technical
Show model answer

Current status can differ from the status that applied when the transaction occurred. Using today's value may rewrite history, producing a plausible total that does not answer the time-specific question the stakeholder intended to investigate or compare across reporting periods.

I'd confirm current versus historical intent and find suitable effective-dated evidence. One join rule cannot automatically answer every retrospective and current question without preserving the relevant temporal business meaning.

What interviewers listen for

  • Define the temporal business question
  • Use suitable effective-dated evidence
  • Separate current from historical classification
Why can joining today's customer status to last year's transactions mislead a historical report — Business analysis interview question — Apexed