Data analyst interview preparation, round by round
Data analyst interviews test SQL more than any other skill, so this page starts there. After SQL come Excel and Power BI, then basic statistics such as A/B tests.
21 resources · 17 free · plus 23 for every role · Links checked 15 October 2026 · How we pick
Change role
- Software engineer 54 resources
- Backend developer 45 resources
- Frontend developer 37 resources
- Full stack developer 43 resources
- Mobile developer 19 resources
- DevOps and SRE 24 resources
- Data engineer 23 resources
- Data analyst 21 resources
- Data scientist 24 resources
- ML engineer 31 resources
- AI engineer 27 resources
- QA and SDET 12 resources
Start here
Three resources, in this order. Everything below is for going deeper on one round.
- LeetCode SQL 50 study plan
Practice site · Free
SQL carries the most weight in analyst interviews. These 50 problems cover the joins and GROUP BY queries that come up first.
- Ankit Bansal: Complex SQL Questions for Interview Preparation
Video · Free
After SQL 50, work through the harder window-function and self-join questions that analyst rounds often ask.
- Alex The Analyst (YouTube)
YouTube channel · Free
Once your SQL is solid, use this channel for the Excel and Power BI questions, and for a portfolio project to discuss.
Nothing matches these filters. Use Show all to see every resource again.
SQL 13 resources
Writing queries with joins, grouping and window functions on realistic tables
LeetCode SQL 50 study plan
Practice site · leetcode.com
Fifty judged SQL problems in seven groups, from selects and joins to aggregates, subqueries and string functions, mostly easy, as a first structured pass.
Best for a first structured set of SQL interview problems for any data or backend role
Ankit Bansal: Complex SQL Questions for Interview Preparation
Video · youtube.com
A 96-video playlist that works through tricky company-style SQL problems step by step, often solving each one several ways with CTEs, self-joins and window functions.
Best for Indian data analyst and data engineer candidates preparing for the SQL coding round
Alex The Analyst (YouTube)
YouTube channel · youtube.com
Free bootcamp-style tutorials on SQL, Excel, Power BI, Tableau and Python for analysts, plus portfolio projects, interview walkthroughs and salary advice.
Best for entry-level analysts covering every tool an analyst interview might test
Also in Excel, Power BI and data analysis questions
Data Science Interviews (Alexey Grigorev)
GitHub repo · alexeygrigorev/data-science-interviews
Community-written answers to common data science theory and technical questions, from linear models, trees and metrics to SQL and Python, plus probability problems.
Best for quick revision of theory and SQL basics before a data science phone screen
Also in Excel, Power BI and data analysis questions, ML theory and statistics
SQLBolt
Website · sqlbolt.com
Bite-sized interactive SQL lessons with in-browser exercises, from SELECT and filtering through joins, aggregates and changing tables.
Best for complete beginners who need SQL basics before interview problem sets
roadmap.sh interview question guides
Website · roadmap.sh
Free topic-by-topic Q&A guides with quiz cards, from backend, frontend, Java, Spring Boot, Go, Python and Node.js to SQL, Kubernetes, DevOps and data analysis.
Best for quick topic-wise revision of language, framework and tool questions before an interview
Also in Excel, Power BI and data analysis questions
codebasics (YouTube)
YouTube channel · youtube.com
Dhaval Patel's channel of free Python, SQL, Power BI and Excel tutorials, end-to-end analytics projects, and data career and interview advice.
Best for Indian analyst candidates who want tool tutorials, project ideas and interview tips in one place
Also in Excel, Power BI and data analysis questions
Emma Ding (Data Interview Pro)
YouTube channel · youtube.com
A former Airbnb data scientist's channel that walks through product-sense cases, metric design, A/B testing, statistics and SQL interview questions.
Best for product-analytics data science interviews built around metrics, experiments and cases
Also in ML theory and statistics
Aced Practice (formerly Exponent; Pramp moved here)
Practice site · aced.io
Free peer mock interviews where you pair with another candidate and take turns as interviewer, in DSA, system design, behavioral, SQL, data science, ML and frontend.
Best for regular, cheap live practice and a feel for the interviewer's side of the table
Also in Coding and DSA
DataLemur
Practice site · datalemur.com
Company-tagged SQL problems on realistic product-analytics tables, plus probability, statistics, ML and Python questions and a free SQL tutorial.
Best for analyst and data science candidates practising the business-style SQL that big-tech screens use
Also in Excel, Power BI and data analysis questions, ML theory and statistics
LeetCode
Practice site · leetcode.com
The default site for interview-style coding practice: thousands of problems, free study plans such as Top Interview 150 and SQL 50, and weekly contests.
Best for daily practice and timed contests (Premium mainly adds company-tagged lists)
Also in Coding and DSA
StrataScratch
Practice site · stratascratch.com
A large bank of SQL, Python, statistics and ML questions reported from real data interviews, filterable by company, with dialect choice and community solutions.
Best for volume and company-specific SQL and pandas practice once your SQL basics are solid
Also in Excel, Power BI and data analysis questions, ML theory and statistics
PostgreSQL Exercises
Practice site · pgexercises.com
Learn-by-doing exercises on one sample database in real PostgreSQL, covering joins, subqueries, aggregates, window functions, dates, strings and recursive queries.
Best for backend developers who want realistic Postgres practice beyond single-table toy problems
Excel, Power BI and data analysis questions 4 resources
Questions on your stack: languages, frameworks, cloud, testing and data tools
Microsoft Learn: Power BI training
Official guide · learn.microsoft.com
Microsoft's free self-paced Power BI learning paths on shaping data in Power Query, modelling and DAX, and building and sharing reports.
Best for analysts who list Power BI on their resume and need to defend it in a tools round
DAX Guide (SQLBI)
Website · dax.guide
A searchable reference for every DAX function, with syntax, examples, and notes on row context, filter context and context transition.
Best for brushing up on CALCULATE, filter context and time intelligence before Power BI rounds
Kimball dimensional modeling techniques
Official guide · kimballgroup.com
The Kimball Group's reference list of dimensional-modelling techniques: grain, fact table types, conformed and role-playing dimensions, and slowly changing dimensions.
Best for data modelling rounds on star schemas, SCD Type 2 and fact versus dimension design
A/B Testing by Google (Udacity)
Course · udacity.com
A short free course by Google data scientists on running experiments: choosing and checking metrics, sizing and designing a test, ethics, and analysing results.
Best for product data science loops that include an experimentation or A/B testing round
Also in ML theory and statistics
ML theory and statistics 3 resources
Statistics, probability, A/B tests, ML algorithms and how to judge a model
An Introduction to Statistical Learning (ISLR / ISLP)
Book · statlearning.com
The standard introductory text on regression, classification, resampling, tree methods and unsupervised learning, with R and Python editions free from the authors.
Best for the classical-ML fundamentals that data science interviews keep probing
StatQuest with Josh Starmer
YouTube channel · youtube.com
Short, step-by-step video explanations of statistics, classic ML algorithms and neural networks, built for filling gaps before a theory round.
Best for revisiting a concept you can't yet explain cleanly, such as p-values or gradient boosting
Harvard Stat 110: Probability (Blitzstein & Hwang)
Course · stat110.hsites.harvard.edu
Harvard's probability course with recorded lectures, topic-wise practice problems with full solutions, and a free online edition of the Blitzstein-Hwang textbook.
Best for the probability puzzles and distribution questions in data science and ML screens
Coding and DSA 1 resource
Solving problems with data structures and algorithms, and explaining your approach
Amazon - How We Hire (role-specific interview prep)
Official guide · amazon.jobs
Amazon's hiring hub, explaining each stage from application to the final loop, with role-specific prep pages for SDE, front-end, BI engineer and scientist roles.
Best for finding out what Amazon tests for your role and level, and how its loop works
Same for every role
Behavioral rounds, resumes, pay and company guides do not change with the job. These 23 live on the interview resources hub.
Behavioral and HR
- GeeksforGeeks - HR interview questions
- Microsoft Careers - Interview tips
- MIT CAPD - The STAR method for behavioral interviews
- Tech Interview Handbook - Behavioral interviews
- reverse-interview
- Amazon Leadership Principles
- Google Careers - Interview tips
- Jeff H Sipe - Practice Interviews (YouTube)
- A Life Engineered (Steve Huynh, YouTube)
Practice and communities
Resume, companies and offers
- Tech Interview Handbook - Software engineer resume guide
- Reactive Resume
- Jake's Resume (LaTeX template on Overleaf)
- Hiring Without Whiteboards
- r/developersIndia Community Wiki
- AmbitionBox
- Anthropic - Candidate AI guidance
- Haseeb Qureshi - Ten rules for negotiating a job offer
- Thoughtworks India - AI policy for recruitment
- Levels.fyi - Software engineer pay in India
- r/EngineeringResumes wiki
From the team that keeps this list
Helpwing is a desktop app for interviews where AI help is allowed: it hears the question and drafts an answer from your resume. It is not for online assessments or tests.