How to change career to data analyst in the UK

You can move into data analysis from almost any background. Many career changers get there by learning three core tools (Excel, SQL and a dashboard tool such as Power BI), taking on data work in their current job, and building two or three small projects that show what they can do. In England there are free and funded routes too, including Skills Bootcamps for adults and a level 4 data analyst apprenticeship with no upper age limit. Plan in months rather than weeks: at 8 to 10 hours a week, 6 to 12 months is a realistic target for learning the basics and building a portfolio.

What does a data analyst do day to day?#

Data analysts turn raw data into answers people can act on. The National Careers Service describes the job as gathering and organising data, finding patterns and trends, and presenting findings to the people who make decisions. Prospects adds producing reports and dashboards with tools such as Power BI, Tableau and SQL, and explaining results to technical and non-technical colleagues. Hours are usually 9am to 5pm, Monday to Friday.

A typical week might include:

• writing SQL to pull last month’s sales or customer data
• checking it for gaps, duplicates and odd values
• refreshing a weekly dashboard that managers rely on
• answering a one-off question, such as why returns rose in March
• explaining what you found, and what you would do about it, to someone who is not an analyst

If you are still at the graduate stage, our guide to becoming a graduate data analyst covers graduate schemes and entry requirements. This guide is for people moving across from another job.

Which of your skills transfer to data analysis?#

More than you might think. Analysis is only useful when someone understands the business question, and that is what you bring from your current job. Prospects also lists excellent communication skills as essential for analysts, because findings have to be explained clearly to the people who use them.

Your background also tells you where to apply first. A retail manager who can write SQL is a natural fit for a retail insight role. An accountant who can build a Power BI dashboard fits finance and reporting analyst roles.

What do you need to learn?#

Start with the tools almost every analyst job uses, in this order:

1. Excel. Lookups, pivot tables, SUMIFS, cleaning messy data and clear charts. The Open University’s free Data analysis: visualisations in Excel course takes about 6 hours.
2. SQL. Filtering, grouping and joining tables. It is how analysts get data out of databases, and Prospects lists it among the skills employers want.
3. Power BI or Tableau. Pick one, based on the job adverts you see most. Microsoft Learn has self-paced Power BI learning paths you can follow for free.
4. Basic statistics. Averages, percentages, distributions, and the difference between correlation and causation.
5. Python (optional). Prospects lists Python or R among the skills employers look for, and they matter more in technical roles. They are not usually the place to start.

If you want a certificate, Microsoft’s PL-300 Power BI Data Analyst exam covers preparing, modelling and visualising data, and managing Power BI, and there is a free practice assessment. It can give your learning a structure and a deadline, but it does not replace projects that show you can use the tools.

How long does it take to become a data analyst?#

It depends on your starting point and the time you have. A realistic plan at 8 to 10 hours a week looks like this:

• Months 1 to 2: Excel, plus any data tasks you can take on at work.
• Months 2 to 4: SQL, practising on real datasets.
• Months 4 to 6: Power BI or Tableau, and your first project.
• Months 6 to 9: two more projects, your CV and your first applications.

If you already use Excel every day, you may move faster. A Skills Bootcamp is shorter, and an apprenticeship longer, as set out below. When you think you have the basics, the free Readiness Check tests SQL, spreadsheets, Power BI and charts in 20 minutes, so you can see what to practise next.

What free and funded routes are there?#

Skills Bootcamps (England). GOV.UK describes Skills Bootcamps as free, flexible courses lasting up to 16 weeks, for people aged 19 or over living in England, whether employed, self-employed or unemployed. They are free if you take one yourself rather than through your employer, and when you finish you are offered a job interview with an employer. What is available depends on where you live, so search the course finder on the National Careers Service website, which is renamed “Get careers information and advice” from 1 October 2026, for data courses near you.

Data analyst apprenticeships. The level 4 data analyst apprenticeship typically lasts 24 months, plus the final assessment, and covers handling data, analysis, visualisation and data protection. Apprentices must be 16 or over, living in England and not in full-time education, and there is no upper age limit. You can apply for a new apprentice job, or train as an existing employee if your employer agrees. You earn a wage throughout, but check the pay: the legal minimum for an apprentice aged 19 or over in their first year is the apprentice rate, £8 an hour from April 2026, although employers can pay more. Search “data analyst” on GOV.UK’s Find an apprenticeship service.

Free learning. Microsoft Learn and the Open University’s OpenLearn both offer free courses, and plenty of free SQL practice exists online. Free learning suits people who are disciplined and have time; its weakness is that nobody checks your work.

To compare self-study, a Skills Bootcamp, a paid bootcamp and a master’s on cost, time and support, use Options Compared.

How can you get data experience in your current job?#

This is often the quickest way to build evidence, because it is real work for real users.

• Offer to own a regular report or dashboard your team already needs.
• Automate a manual spreadsheet task, and record the time it saves.
• Ask your data or BI team if you can shadow them or help test a new dashboard.
• Ask whether you can have read access to a reporting database to practise SQL, following your organisation’s data rules.
• Ask your manager or HR about training. Apprenticeships are open to existing employees of all ages, and some employers offer shorter apprenticeship units to current staff.
• Watch for internal analyst vacancies. Moving within your organisation lets you keep your business knowledge.

Then describe the work with numbers. “Built a weekly stock report used by 12 store managers” tells an employer far more than “advanced Excel”.

How do you build a small portfolio?#

Two or three solid projects are enough. Make at least one about the sector you know: a former teacher might analyse published school performance statistics, and a retail worker might look at retail sales data from the ONS. For each project, start with a clear question, clean and analyse the data, build one clear dashboard and write a short summary of what you found and what you would recommend. Never use confidential data from your employer in a public portfolio.

Which job titles should you search for?#

Data jobs go by many names, so search for all of these:

• data analyst
• BI (business intelligence) analyst
• reporting analyst
• insight analyst
• MI (management information) analyst

Sector titles such as sales analyst, marketing analyst, finance analyst and performance analyst can involve the same work. Read the duties, not just the title: if an advert asks for SQL, Excel and dashboards, it is worth a look.

How much do data analysts earn?#

• Across all data analysts. In the ONS Annual Survey of Hours and Earnings (2025, provisional), full-time data analysts had median gross pay of £38,572 a year. A quarter earned less than £30,835 and a tenth less than £27,338. These figures only count people who had been in the same job for more than a year, so they do not show starting pay.
• Starting pay. The National Careers Service puts a typical starting salary at about £28,000, and Prospects (2024) £23,000 to £25,000 for entry-level roles.

A career change can mean a pay cut at first, especially if you are senior in your current field or start as an apprentice. Check pay for your region and the job titles above with the free Salary Checker, which uses ONS figures.

What mistakes do career changers make?#

• Collecting certificates instead of evidence. Courses teach you; projects and work examples show employers what you can do.
• Starting with Python or machine learning. Get solid at Excel and SQL first.
• Hiding your previous career. Your sector knowledge is a strength. Lead with it on your CV and in interviews.
• Searching for one job title. Use all the titles above, and look inside your own organisation.
• Paying for a course before trying the free routes, and before checking you enjoy the work.
• Waiting to feel ready. Once you can write basic SQL and build a simple dashboard, start applying and learn from each application.

Our guide to data analyst interviews and technical tests explains what the selection process usually involves.