Skip to content

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. 1

    Spreadsheets

    Formulas, pivot tables, lookups, charts.

  2. 2

    SQL

    SELECT, joins, GROUP BY, window functions.

  3. 3

    Statistics

    Distributions, sampling, hypothesis tests, correlation vs causation.

  4. 4

    Visualisation

    Choosing the right chart, dashboard design.

  5. 5

    Python for data

    pandas, cleaning, basic plotting.

  6. 6

    Communicating insight

    Writing clear summaries and recommendations.

  7. 7

    Portfolio

    Three analyses on public datasets with written conclusions.

Advanced directions

Experiment design (A/B testing)Data modelling (dbt)ForecastingAnalytics engineering

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.