The Final Checklist

Before your interview, can you:

• [ ] Write a top-N-per-group query with a window function and CTE?
• [ ] Calculate Bayes' theorem for a new scenario from scratch?
• [ ] Explain what a p-value IS and IS NOT?
• [ ] Name 3 A/B testing pitfalls and fixes?
• [ ] Explain bias-variance tradeoff with a diagnosis for each scenario?
• [ ] Say when to use L1 vs L2 and explain why L1 does feature selection?
• [ ] Use the GAME framework for a product metrics question?
• [ ] Walk through root cause analysis for a dropped metric?
• [ ] Tell 3 STAR stories (data decision, failure, collaboration) under 2 min each?
• [ ] Define: ETL, data warehouse vs lake, OLAP vs OLTP, CAP theorem?
• [ ] Explain why accuracy is bad for imbalanced data and what to use instead?
• [ ] Write transform() vs agg() use cases without mixing them up?

If you can check all of those, you're ready. Go get it. 🔪