Skip to content

Free resources · Data analytics

Data analytics resources

This hub collects practical material for people moving into data and business analyst roles. You will find guidance on the SQL, spreadsheet and statistics skills interviewers test, how to frame business problems as analysis questions, and how to present findings so decision-makers act on them. Use it alongside hands-on practice, because analytics is learnt by working with real, messy data rather than by reading.

Last reviewed

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.