* affiliate links, I may earn a small commission at no cost to you
02SQL (tap to explore)
customers
id
name
city
1
Kim
LA
2
Khloé
NY
3
Kylie
LA
4
Rob
NY
SELECT *
FROM customers
WHERE city = 'LA'
2 of 4 rows match, dimmed rows are excluded
they might ask:
"are you comfortable with SQL? how do you filter results?"
03Excel (tap to reveal the answer)
04common gotchas (tap to see how to handle it)
05AI prompts (paste into ChatGPT or Claude tonight)
Paste these in the night before your interview.
“I have a data analyst interview tomorrow at [company]. Here is the job description: [paste it]. What are the 5 most likely technical questions they will ask me?”
“Quiz me on SQL LEFT JOINs. Ask me one question, wait for my answer, then tell me if I got it right.”
“I'm interviewing for a data analyst role. Give me 3 behavioral questions I should prepare for and how to structure my answers using the STAR method.”
06know these BI tools
Know the names even if you haven't used them all. This comes up more than you'd think.
coming soon
The full interview cheat sheet
Deeper breakdowns, step-by-step tutorials, AI prompts, and practice problems: everything you need to prep the night before.