Data analysts turn raw data into answers people can act on. They clean and query data, build reports and dashboards, and explain what the numbers mean for a decision the business is facing.
Where you start matters less than what you can show you have done. This is what the work is built from.
Core skills
Tools and settings
What the work tends to feel like from one day to the next.
Most of the week is spent answering questions with data. Someone asks why a number moved or whether a change worked, and you find the data, check it is trustworthy, analyse it, and explain the answer in a chart and a few plain sentences. There is regular reporting too, and quieter time spent cleaning data or improving a dashboard. The best days end with someone making a decision because of what you showed them.
The day-to-day tasks behind the job title, in plain terms.
There is rarely one route to becoming a data analyst. These are the two most common.
Statistics, economics, maths, science and business degrees all lead here; the common thread is comfort with data.
Public datasets, a clear question and a written-up finding show you can do the job before anyone has paid you to.
How people usually show they can do the work, and how employers tend to weigh each route.
Statistics, maths, computing, economics and the sciences all lead here. The common thread is comfort with numbers and uncertainty.
Questions you chose, data you cleaned and findings you explained matter more than course badges.
Short credentials for a platform or method can help, especially when you are changing careers.
As you gain experience the work tends to fork. These are two directions it commonly takes.
Studying how people use a product and what changes their behaviour.
Forecasting, cost analysis and process improvement.
A typical shape, not a rule: people move at different speeds, and some skip stages.
Statistics, economics, maths, science and business degrees all lead here; the common thread is comfort with data.
Get dependable at sQL, a spreadsheet at an advanced level and a visualisation tool, and learn how your employer's tools and habits work. This is where trust is earned.
Studying how people use a product and what changes their behaviour. Finance and operations analytics is the other common direction.
Understanding how the organisation earns and spends turns a technically correct answer into a useful one.
What usually separates people who progress from people who stay level.
Say what was decided because of your work. People move up by changing outcomes, not by producing more charts.
Understanding how the organisation earns and spends turns a technically correct answer into a useful one.
Documented, tested pipelines and notebooks that someone else can rerun are what lead roles are trusted with.
Every role has them. Knowing what they are is part of choosing it well.
Check it early, document the fixes you make, and tell people honestly how much to trust the result.
Ask what decision the answer will inform, then agree a simple first version before building anything large.
Lead with the recommendation, keep the chart simple, and follow up with the person who owns the decision.
No role suits everyone. These are the traits that help and the things people say they wish they had weighed first.
Meetups, reading groups and online forums are where methods and job openings both circulate.
A short write-up of how you approached a real dataset teaches others and shows your reasoning.
A project that starts from a clear question and ends in a finding reads far better than a tour of a tool.
Describe the data problems you hit and how you handled them; that is the part employers cannot get from a certificate.
The two most common routes are a degree with numbers in it and self-taught with a portfolio. Statistics, economics, maths, science and business degrees all lead here; the common thread is comfort with data. Public datasets, a clear question and a written-up finding show you can do the job before anyone has paid you to.
The essentials are sQL, a spreadsheet at an advanced level and a visualisation tool. Employers also value explaining findings simply, asking what decision the data is for and scepticism about numbers.
Typical tools and settings include sQL databases, a BI or dashboard tool, spreadsheets and a notebook environment. The names change with employer and fashion, so understanding what each kind of tool is for matters more than any one product.
Product and growth analytics: studying how people use a product and what changes their behaviour. Finance and operations analytics: forecasting, cost analysis and process improvement. To move up in this kind of work, tie every analysis to a decision: say what was decided because of your work. People move up by changing outcomes, not by producing more charts.
Almost every organisation now collects data and wants someone to make sense of it, though the entry-level market is competitive and favours people with real projects. It is worth weighing messy data, explaining, not just analysing and fast-moving methods before you decide.
Read the interview questions for the role, then practise answering out loud. HireMonkey lets you upload your resume and a job description and answer an AI interviewer that follows up, then scores each answer and tells you what to fix.
Upload your resume and the job description, and the AI interviewer builds its questions from both. Every answer is scored against the bar for the role, with notes on what to fix.