Skip to interview prep
Apexed

31. A colleague cannot reproduce last month’s report after the source data was corrected. What should the analysis preserve?

MediumAnalysis & visualization

Technical
Show model answer

Retain versioned query or transformation code, metric definitions, source references, extraction time and parameters. Where retention rules permit, preserve an immutable snapshot or a version identifier that supports reconstructing the source state.

Distinguish the originally published result from a corrected restatement. Record the correction reason and reconciliation checks without exposing restricted records. Reproducibility should explain which inputs produced a number, not depend on someone remembering manual spreadsheet edits.

What interviewers listen for

  • Version inputs and logic
  • Original versus restated results
  • Document corrections
A colleague cannot reproduce last month’s report after the source data was corrected. What should the analysis preserve — Data & analytics interview question —