How long does it take to become a data analyst?

With consistent part-time study, most self-learners reach a portfolio-ready level in roughly 4–8 months. The variable is not intelligence, it is finishing projects. The SQL and stats are learnable in weeks; the portfolio and job search take the rest.

No. Plenty of analysts come from non-technical degrees or none at all. Employers hiring analysts care about demonstrable SQL, a portfolio and clear communication far more than the subject on your diploma.

Do I need to learn Python?

Not to start. SQL, spreadsheets and a BI tool are enough for most entry-level analyst roles. Python helps and opens more doors later, but leading with it before you are fluent in SQL is the common mistake.

Is the Google Data Analytics certificate worth it?

As a structured starting point for a complete beginner, it is reasonable. As a hiring signal on its own, it is weak: a certificate is common, a portfolio of real analysis is not. Treat it as a syllabus, not a finish line.

How to Become a Data Analyst

A no-degree-required path, in five phases you can actually finish.

Free
5 phases
A milestone for every phase

You do not need a computer-science degree or a bootcamp loan to become a data analyst. You need three demonstrable skills (SQL, statistics, and turning numbers into a decision) plus a small portfolio that proves them. This roadmap orders that learning so each phase builds on the last, and points only at resources that are genuinely free to start.

Who this is for: Students, career-switchers and anyone self-teaching from scratch. It assumes no prior coding.

1
1 · Spreadsheets and data thinking
Learn to clean, shape and reason about data before touching code.
- Excel / Google Sheets
- Pivot tables
- VLOOKUP / XLOOKUP
- Basic charts
- Data cleaning
Free resources
- ExcelJet formulas & shortcuts
- Google Sheets training (Google)
You're ready when
You can take a messy exported sheet, clean it, and answer a question with a pivot table and a chart.
Practise on the CSV Cleaner
2
2 · SQL, the non-negotiable skill
SQL is on essentially every analyst job description. This is where most of your time should go.
- SELECT / WHERE / ORDER BY
- GROUP BY & aggregates
- JOINs
- Subqueries & CTEs
- Window functions
Free resources
You're ready when
You can write a query with a JOIN, a GROUP BY and a window function to answer a business question without looking up the syntax each time.
Practise with SQL case studies
3
3 · Statistics that actually get used
Not a stats degree, just the working subset: distributions, averages that don't lie, and testing.
- Descriptive statistics
- Distributions
- Correlation
- Hypothesis testing
- A/B testing basics
Free resources
- Khan Academy: Statistics & Probability
- StatQuest (YouTube)
You're ready when
You can explain the difference between mean and median to a stakeholder, read a p-value honestly, and say when a result is too small to trust.
Try the A/B Test Calculator
4
4 · Visualisation, BI and a portfolio
Turn analysis into something a decision-maker acts on, and prove you can do it publicly.
- Tableau or Power BI
- Chart choice & design
- Dashboards
- Storytelling with data
- 2–3 portfolio projects
Free resources
You're ready when
You have 2–3 finished projects online, each with a question, the SQL/analysis, a visual and a written takeaway.
See portfolio project ideas
5
5 · The job search
Target analyst-specific roles, tailor to each posting, and apply where the competition is thinner.
- Analyst-focused resume
- Matching skills to the JD
- Cover note / outreach
- Interview prep
Free resources
- Google Data Analytics Certificate (structured starter, paid)(paid)
  Optional. A decent structured on-ramp, but a portfolio beats a certificate with hiring managers.
You're ready when
Your resume names the same skills the job description does, and you are applying to real analyst roles, not generic 'data' listings.
Match your resume to a job

Frequently asked

How long does it take to become a data analyst?: With consistent part-time study, most self-learners reach a portfolio-ready level in roughly 4–8 months. The variable is not intelligence, it is finishing projects. The SQL and stats are learnable in weeks; the portfolio and job search take the rest.
Do I need a degree?: No. Plenty of analysts come from non-technical degrees or none at all. Employers hiring analysts care about demonstrable SQL, a portfolio and clear communication far more than the subject on your diploma.
Do I need to learn Python?: Not to start. SQL, spreadsheets and a BI tool are enough for most entry-level analyst roles. Python helps and opens more doors later, but leading with it before you are fluent in SQL is the common mistake.
Is the Google Data Analytics certificate worth it?: As a structured starting point for a complete beginner, it is reasonable. As a hiring signal on its own, it is weak: a certificate is common, a portfolio of real analysis is not. Treat it as a syllabus, not a finish line.

Other free tools

When you're ready, the jobs are here

Real analyst roles scraped daily from company career pages. No ghost jobs.

Browse analyst jobs

1 · Spreadsheets and data thinking

2 · SQL, the non-negotiable skill

3 · Statistics that actually get used

4 · Visualisation, BI and a portfolio

5 · The job search

Frequently asked

Other free tools

When you're ready, the jobs are here