Career change to data analyst: a realistic plan for UK adults

A career change to data analyst is one of the more realistic tech switches for UK adults, because the core tools (Excel, SQL and Power BI) can be learned part-time and your existing industry knowledge counts for a lot. Most people need six to twelve months of steady effort to become employable. The fastest route is usually into a data role in the sector you already know.

Here's how to plan it without wasting a year.

Why does data analysis suit career changers?

Because analysts need to understand the business, not only the numbers. A former nurse knows what NHS waiting time data actually means. A retail manager knows why sales dip in certain weeks. An accountant knows which figures finance teams trust. That context is hard to teach and makes your analysis more useful.

The tools are also learnable. You don't need a computer science degree to write good SQL or build a sensible Power BI dashboard. You need practice, and a reason to keep going when it gets dull.

One more reason it suits adults: the soft skills. Analysts spend a lot of time agreeing definitions with colleagues, managing requests from several teams and presenting findings to managers who are short on time. If you've spent years in a workplace dealing with people, deadlines and competing priorities, you're already good at the part many graduates struggle with.

How long does it take to become a data analyst?

It depends on your starting point and hours. As a rough guide for someone studying around eight to ten hours a week:

These are estimates, not promises. For comparison, Coursera says its Google Data Analytics Certificate takes under six months at under ten hours a week, and that only covers the learning stage.

If you already use Excel heavily at work, you'll move faster. If you're starting from basic spreadsheets, give yourself longer.

Is a career change to data analyst in 6 months realistic?

For some people, yes. You'd need to study consistently every week, already have decent spreadsheet skills, and start applying around month three or four rather than waiting until you feel ready.

For most people with a full-time job and family commitments, I'd set a different goal: be interview-ready in six months, hired within twelve. That's still quick for a career change, and it removes the pressure that makes people give up when month six arrives without an offer.

Be wary of any course that guarantees a data job in a few weeks from zero. The skills aren't the slow part. Building evidence and getting someone to take a chance on you is.

What should you learn first?

In this order:

1. Excel properly. Most UK analysts use it daily, even when ads don't list it.
2. SQL. On IT Jobs Watch, SQL appeared in 32% of UK permanent data analyst ads in the six months to November 2026, more than any other skill.
3. Power BI. It appeared in 27% of those ads, well ahead of Tableau at 8%.
4. Python, once you're comfortable with the first three. It appeared in 18.6% of ads.

Don't start with Python because a YouTube video told you to. Start with what employers ask for.

While you learn, use real data wherever you can. If your current job involves any spreadsheets or reports, volunteer to improve one. A small, genuine improvement at work is worth more on your CV than a tutorial project, and it gives you a story for interviews.

Our guide on how to become a data analyst has more on learning resources.

Will you take a pay cut?

Possibly, at least at first. The National Careers Service gives £28,000 as a typical starter salary and £65,000 for experienced data analyst statisticians. IT Jobs Watch showed a median of £58,496 across all UK permanent data analyst ads in late 2026, with the 10th percentile at £32,550.

If you're on £35,000 now, dropping to a starter salary is a real cost. Two ways to soften it:

Move within your sector. A finance professional moving into finance analytics, or a teacher moving into education data, can often skip the most junior level because their domain knowledge is worth something.

Move within your employer. Ask if there's a reporting or MI team. Offer to help with a project. Internal moves are often the quickest and least risky route, because they already trust you.

How do you prove yourself without data experience?

With projects that look like real work. Pick questions from your own industry and answer them with public data.

For example, a former hospitality manager might analyse UK tourism statistics to show which regions recovered fastest after a downturn, clean the data in SQL, build a Power BI dashboard, and write a one-page summary with recommendations for a hotel group. That's a portfolio piece an employer in that sector would understand immediately.

Then rewrite your CV. Lead with a short profile saying what you're moving into. Put projects above work history. Rewrite old job bullets to show where you already used numbers: budgets, rotas, stock, sales, targets, reports.

And talk to people already doing the job. Most analysts are happy to give fifteen minutes on LinkedIn or at a local data meetup. Ask what their first year looked like, which tools their team uses and what they'd look for in a junior hire. You'll learn more from three of those conversations than from another month of tutorials, and occasionally one turns into a referral.

Should you get a qualification?

A structured course helps you learn in the right order. A recognised exam helps you get past CV filters. Neither replaces a portfolio.

If you want a tested credential, CompTIA Data+ (DA0-002, launched in October 2025) is a vendor-neutral exam covering data preparation, analysis, visualisation and governance. CompTIA recommends 18 to 24 months of relevant experience, so it's best taken after you've built some skills, not on day one. The National Careers Service also lists Level 3 and Level 4 data apprenticeships, which pay a wage while you train. Check the eligibility rules for your situation, as they vary.

Our data analyst course guide compares the main formats.

How Experiencely can help

Career changers rarely lack motivation. They lack recent, relevant work to point to. Our data analysis programme includes training and the CompTIA Data+ certification, plus a live data project. You're placed within 48 hours and work about an hour a day for three months, fully remote, so you can keep your current job while you do it. It costs £2,495. If you're not hired within 60 days of finishing, you get your money back (conditions apply). You come away with real project work to put on your CV.

Frequently asked questions

Sources

Figures are taken from the sources below. Salary ranges are indicative and individual offers vary. Last checked 9 November 2026.

1. National Careers Service: Data analyst-statistician
2. IT Jobs Watch: Data Analyst jobs, UK
3. Coursera: Google Data Analytics Professional Certificate
4. CompTIA Data+ (V2) certification