From Data to Offer: The Ultimate 50-Prompt Interview Playbook

 You can paste any of these directly into ChatGPT and practice.

📊 

SQL & Data Wrangling (Core skill)

1. “Act as an interviewer and give me a medium SQL problem using joins and aggregations. Wait for my answer.”
2. “Give me a hard SQL problem with window functions and edge cases.”
3. “Test me on writing SQL to find top-N per group.”
4. “Ask me a SQL problem involving date gaps and streaks.”
5. “Give me a query to detect duplicates and clean data.”
6. “Simulate a live SQL round and evaluate my query logic.”
7. “Ask me to optimize a slow SQL query and explain indexes.”
8. “Give me a business SQL case: revenue, churn, growth.”
9. “Ask me to convert a complex question into SQL step by step.”
10. “After I answer, rewrite my SQL for readability and performance.”

🧮 

Statistics & Probability

11. “Quiz me on mean vs median using business scenarios.”
12. “Ask me probability questions common in interviews.”
13. “Test me on hypothesis testing with examples.”
14. “Give me an A/B testing case and ask how to analyze it.”
15. “Ask me to explain p-value and confidence interval simply.”
16. “Give me a question on sampling bias and pitfalls.”
17. “Test me on correlation vs causation with cases.”
18. “Ask me to choose the right metric for an experiment.”
19. “Give me a scenario to design an experiment end-to-end.”
20. “Evaluate my statistical reasoning like an interviewer.”

📈 

Data Analysis & Case Studies

21. “Give me a product metrics case and ask me what I’d analyze.”
22. “Simulate a business problem and ask which KPIs matter.”
23. “Give me messy data and ask how I’d clean and explore it.”
24. “Ask me how to analyze a sudden drop in user engagement.”
25. “Give me a funnel analysis case interview.”
26. “Ask me to diagnose revenue decline using data.”
27. “Give me a retention/churn analysis problem.”
28. “Simulate a stakeholder asking vague questions—make me clarify.”
29. “Ask me to turn a business question into an analysis plan.”
30. “Critique my approach and suggest better analyses.”

🐍 

Python / Excel for Analysis

31. “Ask me Python questions for pandas data manipulation.”
32. “Give me a pandas problem: groupby, merge, missing values.”
33. “Test me on writing Python to compute KPIs.”
34. “Give me a dataset problem and ask how I’d analyze in pandas.”
35. “Ask me to debug a pandas code snippet.”
36. “Quiz me on when to use vectorization vs loops.”
37. “Ask Excel interview questions using pivot tables.”
38. “Give me an Excel case: dashboards & formulas.”
39. “Ask me to translate Excel logic into Python.”
40. “Review my solution for efficiency and clarity.”

📊 

Visualization & Storytelling

41. “Ask me to choose the right chart for a scenario and explain why.”
42. “Give me results and ask how I’d present to executives.”
43. “Test me on avoiding misleading charts.”
44. “Ask me to turn analysis into a business story.”
45. “Give me a dashboard case and ask what to include.”
46. “Evaluate my communication as if to a non-technical stakeholder.”

🤝 

Behavioral & Role Fit

47. “Mock interview me with data analyst behavioral questions.”
48. “Ask me about a time my analysis influenced a decision.”
49. “Ask how I handled messy or missing data in the past.”
50. “After the mock, give me interviewer-style feedback and score me.”

✅ Why these are 

high impact

 for Data Analysts

They:

• Focus heavily on SQL + stats + business cases (core hiring signals)
• Force structured thinking & communication
• Include live problem + feedback loops
• Mirror real interview formats at companies like Amazon, Google, fintechs, startups

🧭 How to use

Daily:

• 2 SQL prompts
• 1 stats prompt
• 1 case study
• 1 behavioral

Ask the model to:

“Wait for my answer, then critique like an interviewer.”

If you tell me:

• Your experience level (fresher / 1–3 yrs / 4+ yrs)
• Target companies or domain (fintech, product, healthcare, etc.)
• Tools you use most (SQL dialect, Python, Power BI, Tableau)