Business & Productivity · Career
How to become a data analyst without a degree
A realistic route: two tools, three projects, and one honest CV. Here is the order that works, roughly how long it takes, and the shortcut most people miss.
The Nextversity teamBusiness & Productivity schoolUpdated August 10, 20266 min read
On this page
The short answer
You do not need a degree to become a data analyst. You need to be able to get data out of a database, summarize it without making a mistake, and explain what it means to someone who is busy.
The route that works for most people without a relevant degree is: learn spreadsheets and SQL, build three small projects, then move sideways from a job you already have rather than applying cold into a stack of a thousand applicants.
Step 1: the two tools (2 to 4 months, part time)
Spreadsheets first. Lookups, pivot tables, cleaning, and structuring a workbook someone else can read. Most analyst work still passes through a spreadsheet at some point, and this skill is immediately useful in your current job, which matters for motivation.
Then SQL. SELECT, WHERE, GROUP BY, ORDER BY, and joins. Two evenings gets you querying. A few weeks gets you comfortable. This is the skill that appears in nearly every listing and the one most self-taught candidates are weakest on.
Do not learn them at the same time. One properly, then the next.
Step 2: three projects (1 to 2 months)
A portfolio for a first analyst job is smaller than people think. Three pieces, each with a written explanation:
- A cleaning project. Take a genuinely messy public dataset and turn it into something usable. Document each decision, including the ones you were unsure about.
- A question answered with SQL. Not "here are some queries". A real question with a defensible answer and the query visible.
- A small dashboard or report. Three or four charts that answer one recurring question, with a short paragraph on what the reader should do about it.
Use data you find interesting. Sports, transport, music charts, your own budget. Interest keeps you going through the boring middle, and a project you can talk about with enthusiasm interviews far better than a generic one.
Public data sources worth knowing: the US Bureau of Labor Statistics publishes a lot, and Data.gov is a large open catalog.
Step 3: the sideways move
This is the part most guides leave out, and it is the highest-probability route.
If you have any job at all, there is reporting near you that somebody does grudgingly. Ask for it. Do it well, then do it better than it was being done: automate the boring part, add the chart that answers the actual question, and write the summary paragraph nobody asked for.
Six months of that gives you something no bootcamp graduate has: real analysis, on real data, with real stakeholders, that you can describe in an interview. It also frequently turns into the job itself, because internal candidates who already do the work are the easiest hire a manager will ever make.
The best first data job is often the one you build inside the job you already have.
What about a degree
A degree helps in some organizations, particularly large or regulated ones, and it is not a requirement in most. The honest position is that it removes a filter at some employers and does nothing at others.
If you are choosing between a three-year degree and six months of focused practice plus a portfolio, and your goal is a junior analyst role, the second one is faster and cheaper. If your goal is research or data science at a large institution, the degree question is genuinely different.
The CV that works
- Lead with what you can do, not what you studied. "I query a warehouse in SQL and build the weekly sales report" beats a list of course names.
- Link the projects. One line each, with a link.
- Be accurate about credentials. A certificate of completion is not a vendor exam. Say which one you have.
- Include the adjacent work. Reconciling accounts, building rosters, running a stock report. That is analysis, and it counts.
When not to chase this
If you are drawn to data because you heard the salaries are good but the work sounds tedious, listen to that. The job is cleaning, meetings, and explaining the same chart three times. People who enjoy it enjoy the puzzle, not the title.
And if you have three courses open already, finish one before starting another. Completion is the skill under the skill.
Where to learn it
Excel data analysis covers the spreadsheet side, Database management using SQL covers queries, and Python is there when you want it later. Every course includes a certificate of completion, and one subscription opens the whole Business & Productivity school and the Programming school together.
Two tools, three projects, one sideways move. That is the route.
Questions people ask
Can you become a data analyst without a degree?
Yes. Many analysts moved across from finance, operations, marketing or support. Employers hiring juniors care about whether you can query data and explain a result, and a portfolio can demonstrate both.
How long does it take to become a data analyst?
Six to twelve months of consistent part-time study and project work is a realistic range if you are starting from scratch. Faster if your current job already touches data, because you can practice at work.
What is the easiest way into a data role?
Sideways, from a job you already have. Volunteer for the reporting nobody wants, do it well, and apply internally. That route skips the hardest part of the hiring process, which is having no experience to point at.
Do I need to learn Python first?
No. Learn spreadsheets and SQL first because they cover most entry-level work. Add Python later when a repeating task or a large dataset makes it worth the time.
What should be in a data analyst portfolio?
Three short projects: a cleaning job, a SQL analysis answering a specific question, and a small dashboard. Each with a written explanation of the question, the method and the finding.