Free resources · Data analytics
Data analytics resources
Last reviewed
Practice01
SQL interview questions for data analysts
29 SQL interview questions with answer-first explanations and runnable queries on a practice e-commerce database — joins, window functions, CTEs, dates, NULLs and business cases.
Practice02
Excel interview questions with answers
Excel interview questions for analyst roles — lookups, PivotTables, conditional aggregation, dates, dynamic arrays and data cleaning — with worked answers.
Practice03
Excel practice
Downloadable datasets with graded exercises and solutions.
Tool04
Online SQL compiler
Run SQL in your browser against a practice database.
Tool05
Online Python compiler
Run Python in your browser — no install.
List06
Books, newsletters & podcasts
A short, curated reading list with notes on why each is worth your time.
Tool07
Job board
Curated roles in this field.
Tool08
Resume builder
Build a clean, ATS-friendly resume in your browser.
Start with these sql interview questions for data analysts
- In what order does SQL logically evaluate the clauses of a SELECT query?Easy
- How do BETWEEN, IN and LIKE behave, and what are their common pitfalls?Easy
- Explain INNER, LEFT, RIGHT, FULL OUTER and CROSS joins.Easy
- How would you find customers who have never placed an order?Easy
- In a LEFT JOIN, what is the difference between putting a filter in ON and in WHERE?Medium
- How do you use a self-join to show each employee alongside their manager?Medium
Start with these excel interview questions
- What is the difference between VLOOKUP and XLOOKUP?Easy
- How does INDEX-MATCH work, and why was it preferred over VLOOKUP?Medium
- How do SUMIFS and COUNTIFS work with multiple conditions?Easy
- When would you use a PivotTable, and what are its main parts?Easy
- How do you get a distinct count in a PivotTable?Medium
- Which text functions do you use most for cleaning data?Easy
Frequently asked questions
What skills do I need for an entry-level data analyst role?
Most entry-level roles expect solid SQL, confident spreadsheet work, basic statistics and one visualisation tool. Just as important is the ability to turn a vague business question into a precise one, check data quality before trusting it, and explain findings in plain language. Python is increasingly useful but is usually tested after SQL and business reasoning.
How do I prepare for a data analyst interview?
Practise SQL on realistic schemas, especially joins, aggregations, window functions and handling nulls. Revise core statistics such as distributions, sampling and A/B testing. Prepare to walk through one analysis end to end: the question, the data, your method, the result and the decision it informed. Expect a case question on diagnosing a drop in a business metric.
Is SQL or Python more important for data analysts?
For most analyst roles SQL comes first, because the bulk of day-to-day work is pulling, joining and summarising data from databases. Python becomes valuable for automation, larger datasets, statistical analysis and repeatable reports. Start by becoming fluent in SQL, then learn enough Python with a data library to clean, analyse and visualise a dataset on your own.
What should a data analytics portfolio project look like?
A good project starts with a clear business question, uses a real or realistic dataset, and documents how you cleaned and checked the data. It should show your analysis, a small number of well-chosen charts and a short recommendation with its limitations. Publish the queries or notebook alongside a one-page summary written for a non-technical reader.
Want structure and feedback?
Data Analytics Fellowship
Go from spreadsheets to SQL, Python and dashboards that change decisions.