The short version
- Spreadsheet fluency: 2 to 4 weeks.
- SQL fundamentals: 3 to 6 weeks with daily practice.
- A visualisation tool such as Power BI or Tableau: 2 to 3 weeks.
- A portfolio of three real analyses: 4 to 8 weeks.
- Realistic total for entry level readiness: 3 to 6 months part time.
A sequence that does not waste time
| Stage | Focus | Output you should finish with |
|---|---|---|
| 1 | Spreadsheets, cleaning, pivot tables | A cleaned dataset with a summary sheet |
| 2 | SQL joins, filters, aggregation | Ten queries answering business questions |
| 3 | Visualisation and dashboards | One dashboard that answers a stakeholder question |
| 4 | Statistics for decisions | An analysis with a clear recommendation |
| 5 | Communication | A one page written summary for a non technical reader |
What actually gets people hired
Employers hire analysts who turn a messy question into a defensible answer. That means the last two stages matter more than most learners expect. A candidate who can explain why a metric moved, in plain language, beats a candidate who knows more syntax.
Common mistakes
- Spending months on tool tutorials without ever analysing a real dataset.
- Learning Python before being solid in SQL, which is what most jobs use daily.
- Building dashboards with no stated question and no recommendation.
Key takeaways
- Three to six months part time is the honest range for entry level.
- SQL plus one visualisation tool covers most job listings.
- Portfolio work and clear communication decide interviews, not tool count.
Frequently asked questions
Do you need a degree to be a data analyst?
No. Many analysts move in from operations, finance, marketing or support roles. Employers increasingly screen on a portfolio and a practical test rather than on the subject of your degree.
Should I learn Python or SQL first?
SQL first. It is the language used daily in most analyst roles, it is faster to learn, and it unlocks real datasets. Python is valuable later for automation and heavier analysis.
How many portfolio projects do I need?
Three well documented analyses beat ten shallow ones. Each should state the question, the data source, the method, the finding and the recommendation in plain language.
Can I learn analytics while working full time?
Yes. Around 6 to 8 focused hours a week is enough to reach entry level readiness in roughly six months, provided the hours go into practice rather than passive watching.