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.
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
- Excel: formulas, lookups, pivot tables and charts.
- SQL: querying, joining and summarising data. This is the most tested skill in analyst interviews.
- A visualisation tool: Power BI or Tableau.
- Statistics basics: averages, distributions, correlation, sampling and A/B testing ideas.
- Python or R: pandas for analysis and automation.
- Business understanding and communication: turning numbers into clear recommendations.
Build a portfolio
Employers want proof. Build three to four projects using public datasets:
- A sales or e-commerce analysis with a dashboard.
- A customer churn or retention analysis.
- An HR attrition or recruitment analysis.
- A topic you care about, such as cricket statistics, public transport or air quality.
For each, write a short summary: the question, your approach, key findings and recommendations.
Getting the first role
- Target titles like data analyst, business analyst, MIS analyst, reporting analyst and operations analyst.
- Tailor your resume to each job's tools.
- Practise SQL problems and case questions: "How would you investigate a 20% drop in orders?"
- Consider internships or internal moves; many analysts start in operations or finance and move into analytics.
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.


