How to Become a Data Analyst With No Experience: Start Inside a Job You Can Get
Start in a job where you already handle numbers, build SQL into it, then apply as someone who has done the work.
6 min read
The usual answer to how to become a data analyst with no experience is a course and a portfolio. Then the postings ask for years.
The data analyst title is rarely open to beginners, so the realistic way in is analyst work under another title first, then a move that counts it.
About 2 in 100 data analyst postings with a known level were marked entry level
As of 6 November 2026, more than 1,500 data analyst jobs at more than 720 companies were open on the employer career sites TeaKo reads in the US and Canada. About 2 in 100 of those with a known level were marked entry level.
On those sites on that date, the median data analyst posting asked for at least 4 years of experience. In US postings that showed pay, the median posted floor was $90,000 and the median posted ceiling $141,000 a year.
The postings ask for years of the work, and TeaKo's view is that those years can be earned under another title.
SQL leads the tool list, and a missing tool is not always a bar
Among data analyst postings open on the employer career sites TeaKo reads on 6 November 2026 that list skills, SQL was named in about six in ten. Python and Power BI were each named in about four in ten, and Excel and Tableau each in about three in ten.
HR managers in one survey said they would bend. A 2019 Robert Half survey found that 84% of HR managers said they would hire and train someone who lacks a required skill, and that 42% of applicants did not meet the stated requirements.
In a 2024 experiment on Uber's corporate job ads, removing optional qualifications raised applications by 7%, because people take every listed item as a bar to clear.
Experience is weighed more heavily than education. A 2023 SHRM study of more than 1,000 recruiters found that at the first resume screen they weigh years and type of experience far ahead of education. TeaKo's view is that a missing tool is worth applying around, while missing years of the work are what the route below builds.
The way in is analyst work inside a job you can get
TeaKo's view is that years spent pulling, cleaning and explaining data under another title count toward what a data analyst posting asks for, as long as the resume shows the work. The SHRM recruiters weighed the type of experience as well as its length, so the work has to look like analysis, not just sit near it.
The analyst roles next door are not easy first doors either. On the employer career sites TeaKo reads, on 6 November 2026, about 4 in 100 financial analyst postings and about 2 in 100 business analyst postings with a known level were marked entry level.
The roles with more entry-level postings are elsewhere. On the employer career sites TeaKo reads, on 6 November 2026, about seven in ten customer support representative postings and about two in ten IT support specialist postings with a known level were marked entry level.
That gives two routes. If you already work in finance, operations, marketing or support, find the reports in your job and take them over. If you are starting out, a support role where you can take on the reporting is a realistic first job, since support is one of the roles with many entry-level postings.
A course and a portfolio still help: they teach the tools and show them. A report your team relies on shows the tools and a result someone used, which is closer to what a posting means by experience.
What the evidence says about a data analyst without a degree
In SHRM's 2023 study, 35% of recruiters rated education level important at the first screen, against 84% for years of experience. And a 2024 Burning Glass Institute and Harvard Business School study found that when large US firms dropped degree requirements, who they hired barely changed: fewer than 1 in 700 hires.
In the SHRM study, recruiters weighed a degree less than experience. In the Burning Glass study, dropping the degree line changed little about who was hired, which suggests the degree still counted at those firms. TeaKo's view is that without a degree, years of analyst work carry more of the weight.
How to use this: build the years where you are
Step 1. Find the data in the job you have or can get: a report someone builds by hand each week, a spreadsheet that feeds a decision, a dashboard nobody maintains.
Step 2. Learn SQL first, since it leads the postings, and use it on that report. A course teaches the syntax; the report gives you a result to describe.
Step 3. Write it as work. "Rebuilt the weekly sales report in SQL and Power BI so the team gets it each Monday without manual work" names two tools and a result. The post on how to write a strong resume covers the rest of the page.
Step 4. Read the role guides on the career paths pages for the roles you are weighing, and apply first where your domain counts. Then apply to data analyst postings that ask for the years you now have.
Step 5. Count your years honestly. How long it takes to become a data analyst depends on when you start doing the work, and TeaKo's view is that the count starts at your first real report.
The title comes after the work
On these sites, very few data analyst postings are open to someone with no experience. The work they ask for can start in a job you can get now.
If your data analyst career path starts in a role next to data analysis, the next useful step is to read about the roles you are weighing. TeaKo's role guides are grouped by discipline, with data as one of them.