Data analyst career roadmap: skills, projects and first job

Written by LitCareer · 13 Oct 2026 · 2 min read

The skills to learn in order, the portfolio projects that impress, and how to land your first analyst role.

Data analyst career roadmap: skills, projects and first job

What data analysts do

Analysts turn data into answers for business questions: Why did sales drop last month? Which customers are likely to leave? Which marketing channel works best? They clean data, analyse it, build reports and explain findings to non-technical colleagues.

Skills to learn, in order

  1. Excel: formulas, lookups, pivot tables and charts.
  2. SQL: querying, joining and summarising data. This is the most tested skill in analyst interviews.
  3. A visualisation tool: Power BI or Tableau.
  4. Statistics basics: averages, distributions, correlation, sampling and A/B testing ideas.
  5. Python or R: pandas for analysis and automation.
  6. Business understanding and communication: turning numbers into clear recommendations.

Build a portfolio

Employers want proof. Build three to four projects using public datasets:

For each, write a short summary: the question, your approach, key findings and recommendations.

Getting the first role

Growing from there

Senior analyst, analytics manager, data scientist or data engineer, depending on whether you enjoy business problems, modelling or building data pipelines.

Your next steps

  • Learn Excel, then SQL, then a BI tool
  • Build three portfolio projects with written findings
  • Practise SQL and business case questions
  • Apply to MIS and operations analyst roles too

General guidance for learning, not professional, legal or financial advice. Want help for your own situation? Book 1:1 career help.

More in Digital & tech skills

Keep learning