Data Analyst Interview Prep Kit | 150 SQL Questions, 60 Python Pandas Exercises, 3 Take-Home Case Studies, Presentation Template & Tracker

THE COMPLETE DATA ANALYST INTERVIEW PREP KIT - PRACTICE ON A REAL DATABASE, NOT A LIST OF QUESTIONS:

Interviews test what you can DO. This kit gives you a realistic e-commerce database, 210 exercises that run against it, three full take-home case studies with model solutions, a 10-slide presentation template and a tracker, everything you need to walk into a SQL screen, a pandas live-coding round or a case presentation and know exactly what to say.

📦 WHAT'S INSIDE (88 files, 6 folders)

📗 01 SQL INTERVIEW WORKBOOK (PDF, 134 pages) ✔ 150 interview questions in 3 levels: Foundations, Intermediate, Advanced ✔ Every question with model solution, expected output, "why this works" explanation and an interview tip you can say out loud ✔ 37 topics: joins, CTEs, window functions, LAG/LEAD, cohorts & retention, funnels, recursive CTEs, RFM, ROAS, data-quality checks ✔ Part A = questions only for self-testing · Part B = full solutions ✔ Plus .sql files: questions to fill in + verified solutions per level

📘 02 PYTHON & PANDAS WORKBOOK (PDF, 71 pages) ✔ 60 hands-on exercises with printed output, explanation and interview tip ✔ Part 1 core pandas · Part 2 analyst workflows (cleaning, pivots, cohorts, RFM, QA checks, end-to-end KPI table) ✔ Plus exercises.ipynb and solutions.ipynb ready to run in Jupyter

📙 03 THREE TAKE-HOME CASE STUDIES (data + brief + model solution + executed notebook) ✔ Subscription churn analysis (8,000 subscribers) churn definition, segments, leading indicators, price-change impact ✔ Checkout A/B test (25,000 users) sample-ratio mismatch trap, z-test & confidence intervals, novelty effect, guardrail metrics, ship decision ✔ Retail store performance (24 stores, 2 years) normalised ranking, promotion effect, closure & investment shortlist ✔ Each with 6–7 charts, recommendations with impact and caveats, and the INTERVIEWER'S GRADING NOTES (what a strong vs weak answer looks like)

📕 04 CASE STUDY PRESENTATION TEMPLATE (PowerPoint, 10 slides) ✔ Recommendation-first storyline, filled with a complete example ✔ Template notes in every slide's speaker notes

📊 05 INTERVIEW TRACKER (Excel) ✔ Progress dashboard for all 213 items, 4-week study plan, application funnel, real-interview question log

📄 06 BONUS: 4 CHEAT SHEETS (PDF) ✔ SQL · Python · Data Analyst Programming (pandas) · Data Analyst Fundamentals (statistics & machine learning)

🗄️ THE DATABASE ✔ Brightcart: 13 tables, 500 customers, 1,990 orders, 6,000 web sessions, campaigns, reviews, returns, a messy staging table ✔ As CSV + PostgreSQL script + SQLite script, every solution runs on it

💡 WHO IT'S FOR
Junior to mid-level data analyst, business analyst and analytics engineer candidates; career switchers finishing a bootcamp; anyone with a SQL test or take-home assignment on the calendar.

💻 WHAT YOU NEED
✔ PostgreSQL (recommended) or SQLite, or a free online SQL sandbox ✔ Python 3 with pandas 2.2+ and Jupyter for the notebooks (optional the PDFs stand alone) ✔ PowerPoint / Keynote / Google Slides · Excel / Google Sheets

📥 DELIVERY
Instant ZIP download after purchase (PDF, SQL, IPYNB, CSV, PPTX, XLSX). No physical item is shipped.

Licence: personal use by the purchaser. No redistribution or resale.

❓ Questions? Send me a message, I usually reply within a day. And if the kit helps you land the role, a review makes my day.