Skip to interview prep
Apexed

89. Data from one region is unavailable. Should an international dashboard show zero for that region?

EasyAnalysis & visualization

Technical
Show model answer

Only if zero is the verified observation. Unavailable data means the value is unknown, and replacing it with zero can distort totals, rankings and comparisons while hiding a coverage gap.

Mark the region as unavailable and state whether aggregates exclude it or remain incomplete. Provide the observed coverage period and recovery status where known, and avoid estimating a value unless a justified method and clear label are provided.

What interviewers listen for

  • Separate unknown from observed zero
  • Disclose aggregate coverage
  • Label any justified estimate
Data from one region is unavailable. Should an international dashboard show zero for that region — Data & analytics interview question — Apexed