Everything you need to crack the data analyst interview
Real SQL, Python and business case-study questions, worked solutions, and a structured 8-week roadmap — all open and free to use.
| region | customer_id | revenue |
|---|---|---|
| North | C-1043 | 84,200 |
| South | C-2270 | 77,600 |
| West | C-0918 | 69,300 |
Every round of the interview, in one place
From your first SELECT statement to a full business case — pick a track and start practising.
SQL Interview Prep
Joins, subqueries and window functions, worked through with real interview-style questions.
Explore SQLPython for Analytics
Pandas, NumPy and data-cleaning workflows — the Python you’re actually asked about.
Explore PythonBusiness Case Studies
Structured frameworks for product, metric and root-cause analysis scenarios.
Explore casesTechnical Rounds
Data modeling, ETL concepts and BI-tool questions explained from the ground up.
Explore roundsDashboards & Metrics
KPIs, funnels, cohorts and A/B testing — plus how to tell a story with data.
Explore metricsResume & Storytelling
Frame your projects and answer behavioural questions with a clear structure.
Explore prepWhat you’ll actually be asked
The core topics mapped by difficulty, so you know where to spend your time.
SQL Interview Topics
Six core areas that come up in most data analyst SQL rounds.
Python Interview Topics
The libraries and workflows tested in Python analytics rounds.
Practice with real interview-style questions
A taste of the question bank — grouped by round and difficulty. Full worked solutions live inside each topic guide.
An 8-week roadmap you can actually follow
A week-by-week path from the basics to interview-ready. Move faster if you already know the fundamentals.
SQL foundations
Master SELECT, GROUP BY, HAVING, JOINs and subqueries. Work through easy and medium SQL questions until they feel routine.
Advanced SQL + Python basics
Window functions, CTEs and complex queries. Start Python with Pandas DataFrames, filtering and groupby, then complete a first end-to-end analysis.
Case studies + metrics
Business case frameworks, metric design, A/B testing and funnel analysis. Practise talking through your reasoning out loud.
Full practice + storytelling
Time yourself on mixed question sets covering all rounds. Polish your resume, prepare behavioural answers, and fix any remaining gaps.
Free guides to get you started
Practical walkthroughs on SQL, Python and career prep — written for people actively interviewing.
Customer Churn Analysis Case Study
An end-to-end churn analysis in SQL and Python — the kind of case asked at product companies.
Power BI Dashboard Projects for Your Portfolio
Ten dashboard projects you can build and show recruiters, from beginner to advanced.
Top SQL Queries Every Data Analyst Must Know
The SQL patterns that show up in most analyst interviews, with full explanations and examples.
Questions, answered
Is everything really free?
+Yes. The topic guides, question bank, worked solutions and the 8-week roadmap are all open — no account, email or payment required. The site is supported by ads, not paywalls.
Do I need coding experience to start?
+No. The SQL and Python tracks start from the absolute basics and build up gradually, so you can begin with zero prior coding knowledge and still follow along.
How long does it take to get interview-ready?
+The roadmap is designed around eight focused weeks. If you already know the fundamentals of SQL or Python you can move through it faster — the point is to have a clear order to study in rather than a fixed deadline.
Are these the exact questions companies ask?
+They’re modelled on the style and difficulty of questions common in data analyst interviews. The goal is to build the underlying skill so you can handle any variation, rather than memorising a specific list.
Is this suitable for career switchers?
+Absolutely. The material assumes no analytics background, and the roadmap gives switchers from other fields a structured, step-by-step way to build the skills interviews test for.
How often is the content updated?
+New questions and guides are added regularly, and existing content is reviewed to keep it current with what analyst interviews look like in 2026.
Start preparing today — for free
Pick a track, work through the questions, and follow the roadmap. No sign-up needed.