What should you do first when you receive a new dataset?
PICTURE THIS: SQL JOIN
Simple meaning
Confirm grain, time range, source, and how the extract was filtered before computing fancy stats.
WHY — EDA instead of guessing?
Why interviewers care about EDA:
who only read docs from people who shipped.
and tied to Data Science work.
Name the idea, why it exists, then one short example.
End with when you use it and one common pitfall.
STEPS — What happens step by step?
Before you speak the answer, walk the interviewer through these steps:
- 1Confirm grain, time range,
source, and how the extract was filtered before computing fancy stats.
- 2Then check shape, dtypes,
missingness, duplicates, and a few raw rows.
- 3Those steps catch join
explosions and truncated dumps that would invalidate every later chart.
- 4Give an example
One tiny concrete case you can say aloud.
- 5Common mistake
What juniors usually get wrong.
- 6Close
When you pick this over the alternative.
EXAMPLE — See it in action
Here's a short line you can speak, broken into clear beats:
Note: Adapt this scaffold to your own project — keep it under 60–90 seconds.
Key takeaway
Confirm grain, time range, source, and how the extract was filtered before computing fancy stats. Then check shape, dtypes, missingness, duplicates, and a few raw rows.