Interview prep · 50 questions
SQL interview questions
50 timed questions of the kind data analyst interviews and technical tests ask, on Brightwell's data.
Basics: filtering, NULLs, text (10) · Summarising and grouping (10) · Joins and self-joins (10) · Window functions (10) · Business analysis (10)
Checking your access…
Talk through your project
Interviews often ask about work you've done. Answer these out loud about your portfolio project, in two minutes each.
- Walk me through the analysis you're proudest of. What question did it answer?
- How did you check your numbers were right before you shared them?
- Tell me about some messy data you dealt with. What was wrong, and what did you do?
- Which of your findings would you act on first, and why?
- What would you do differently with more time, or more data?