Data Analyst Interview Kit with Excel, SQL, Python pandas and Case Questions

Practice the four rounds a data analyst or business analyst loop actually tests -- an Excel exercise, a SQL round, a Python/pandas task and a business case -- on one consistent fictional dataset instead of scattered, mismatched examples.

What's inside

• Data-Analyst-Interview-Kit-v1.0.zip: data/ (5 CSVs: users, restaurants, campaigns, orders, deliveries -- a fictional food-delivery business, TiffinTrail), excel/ (20-exercise workbook plus a fully solved and recalculated answer key), sql/ (25 questions on a SQLite database, one solution file per question, and the verified output of every query), python/ (20 pandas exercises as function stubs, a filled answer key, and a pytest suite that checks your work), and README.md.
• Data-Analyst-Interview-Kit-Guide.pdf: a 62-page guide covering every exercise and question with an interview-relevant note, 10 worked case questions (metric drops, campaign ROI, city expansion, delivery complaints, pricing, dashboard design, restaurant churn, activation funnels, plan upgrades, agent coaching), a statistics refresher and a short guide to presenting an analysis clearly.

How to use it

1. Work the Excel, SQL and pandas exercises in any order -- they all use the same TiffinTrail dataset, not separate examples.
2. For each case question, write down your own clarifying questions and analysis steps before reading the guide's worked answer.
3. Run the SQL and pandas answer keys yourself (sql/analyst.db with any SQLite client; pytest test_solutions.py for pandas) to see that every number is real and reproducible, not just printed in a PDF.

Requirements

• Microsoft Excel 2021 or Microsoft 365 for XLOOKUP (an INDEX/MATCH alternative is included for Excel 2016-2019).
• Any SQLite client (for example DB Browser for SQLite) to open analyst.db; the SQL also runs unchanged in MySQL 8 and PostgreSQL 16 except where the guide notes a syntax difference.