Data · Career guide
Data Analyst
Turn raw data into clear answers that help teams make better decisions.
Role overview
Data analysts clean, query and visualise data, then explain what it means. The most valuable analysts ask sharp questions, are careful about data quality, and communicate findings simply to non-technical people.
Typical responsibilities
- Write queries to answer business questions
- Build and maintain dashboards
- Check data quality
- Present findings and recommendations
Beginner roadmap
- 1
Spreadsheets
Formulas, pivot tables, lookups, charts.
- 2
SQL
SELECT, joins, GROUP BY, window functions.
- 3
Statistics
Distributions, sampling, hypothesis tests, correlation vs causation.
- 4
Visualisation
Choosing the right chart, dashboard design.
- 5
Python for data
pandas, cleaning, basic plotting.
- 6
Communicating insight
Writing clear summaries and recommendations.
- 7
Portfolio
Three analyses on public datasets with written conclusions.
Advanced directions
Project ideas
beginner
Personal expense analysis
Clean a spending export and chart where money goes.
intermediate
Public dataset dashboard
Interactive dashboard with a written insight report.
advanced
A/B test analysis
Design and analyse an experiment with confidence intervals.
Interview topics
- SQL joins & window functions
- Metric definitions
- Case: why did a metric drop?
- Statistics basics
- Presenting to stakeholders
Resume guidance
- Describe the decision your analysis informed.
- Name the datasets and tools you used.