The short answer
Learn the skills in this order: spreadsheets, SQL, one BI tool (Power BI or Tableau), Python basics, then statistics. Build three portfolio projects on real data. HTD Talent's program data puts job-ready skills at about 148 study hours, or 15 weeks at 10 hours a week. SQL shows up in 71% of postings.
Key takeaways
- SQL is the skill to learn first after spreadsheets, because it appears in 71% of the data and BI analyst postings HTD Talent sampled.
- At 10 hours a week, the study time to job-ready skills is about 15 weeks. That's study time. Hiring takes as long as it takes.
- Three portfolio projects built on messy public data do more for an entry level data analyst application than a stack of certificates.
- The fastest first role is often an internal transfer, where you already know the data and the people who use it.
- Certifications like Microsoft PL-300 or the Google Data Analytics certificate are optional. They help with structure and with recruiters who filter on them.
You can become a data analyst with no experience. Plenty of people do it from operations, finance, customer support, retail management and teaching. What they have in common is a sequence. They learn the tools a hiring manager will test, in the order those tools build on each other, and they prove it with work anyone can open.
This guide gives you that sequence, the study hours behind it, and an honest look at who should pick a different path.
What an entry level data analyst does all day
An entry level data analyst pulls data, cleans it, and turns it into an answer someone can act on. Most days that means writing SQL against a company database, building or fixing a dashboard, and explaining a number to a manager who wants to know why it moved.
O*NET's profile for business intelligence analysts lists tasks like generating standard or custom reports, maintaining dashboards, and supporting the people who use them (O*NET OnLine, 2026). Job titles vary a lot. "Reporting analyst," "BI analyst," "operations analyst" and "data analyst" often describe the same seat.
Most of the work is getting the right data, getting it right, and saying what it means in plain English. The math is lighter than most career changers fear.
If you're still deciding between this and the more math-heavy track, read our breakdown of data analyst vs. data scientist first.
The data analyst skills to learn, in order
Here's the order that works for career changers. Each step uses the one before it, so don't skip ahead.
Share of data and BI analyst postings that mention each skill
Step 1. Get fluent in spreadsheets
Start in Excel or Google Sheets. You need sorting, filtering, lookups (XLOOKUP or INDEX/MATCH), pivot tables, and basic charts.
This is where you learn to think in rows and columns. Almost every analyst still exports to a spreadsheet at some point, and many interviews include a quick spreadsheet task.
If you already build pivot tables at work, give this step a week and move on.
Step 2. Learn SQL well
SQL is the core data analyst skill. In HTD Talent's program data (October 2026), 71% of sampled data and BI analyst postings mention SQL, more than any other tool.
Learn SELECT, WHERE, GROUP BY, the JOIN types, subqueries, CASE statements and window functions. Then practice on a real database until you can answer a business question without looking up syntax.
Most technical screens for analyst roles are SQL screens. Spend the most time here.
Step 3. Pick one BI tool
Choose Power BI or Tableau and go deep on one. Don't learn both at the start.
Power BI Desktop is a free download, but it runs on Windows only (Microsoft Learn). Tableau Public is free too, and everything you publish there is public, which makes it a ready-made portfolio (Tableau). Tableau appears in 33% of the postings in our sample.
Our rule of thumb: check 20 postings in your city or target industry and pick whichever tool shows up more. Banks and insurers lean toward Microsoft shops. You'll see the pattern quickly.
Step 4. Add Python basics
Python appears in 54% of the postings HTD Talent sampled. For an analyst, "basics" means pandas for cleaning and reshaping data, a plotting library, and Jupyter notebooks.
The goal is to automate the cleanup you'd otherwise do by hand in a spreadsheet, and to handle files too big for Excel. Software-developer depth can wait.
Step 5. Learn the statistics you'll use
Learn descriptive stats (mean, median, spread, percentiles), distributions, correlation, sampling, and how A/B tests work. Learn when a difference is noise.
This is the step that keeps you from presenting a 2% blip as a trend. It's also what separates an analyst from someone who makes charts.
Step 6. Build three portfolio projects on real data
A portfolio is your experience when you have no analyst title. Three projects is enough if each one answers a real question from start to finish.
Use public data that needs cleaning. Data.gov hosts U.S. government datasets on almost any topic, and your city's open data portal is a good source of local questions people care about.
Make each project show something different:
- A SQL project where you join several tables and answer a business question, with your queries on GitHub.
- A dashboard in Power BI or Tableau that a manager could use every Monday.
- A Python notebook that cleans a messy file and explains one finding with a chart.
Write a short summary for each: the question, the data, what you found, and what you'd recommend. Hiring managers read that summary first. Many never open the code.
If you work in a specific industry now, build at least one project on data from that industry. A former pharmacy tech who analyzes prescription fill data reads as an analyst who already knows the domain.
Step 7. Decide whether you want a certification
Certifications are optional for an entry level data analyst. They give you a structured syllabus and a line recruiters can filter on, and that's their main value.
Two worth knowing:
| Certification | What it covers | Format and upkeep |
|---|---|---|
| Microsoft PL-300: Power BI Data Analyst Associate | Preparing data, modeling, visualizing and analyzing, managing and securing Power BI | 100-minute proctored exam. Renews every 12 months through a free online assessment (Microsoft Learn) |
| Google Data Analytics Professional Certificate | Spreadsheets, SQL, Tableau, Python, presenting findings | 9 courses on Coursera, beginner level, no prior experience required. Google estimates about 6 months at 10 hours a week (Coursera) |
Our take: if your target employers run Microsoft, PL-300 is the stronger signal because it tests the exact tool you'll use. The Google certificate is a good guided start if you want someone else to set the syllabus.
Neither replaces a portfolio. A certificate says you studied. A project shows you can do the work.
Step 8. Land your first data analyst role
Your first data role usually comes from one of three places. Go after the one closest to you first.
Start with an internal transfer
If you have a job now, look inside your company before you apply anywhere else. You already know the data, the systems and the people asking for reports. That's experience an outside candidate can't match.
Volunteer to own a recurring report. Rebuild a manual spreadsheet as a dashboard. Then tell your manager you want an analyst role and ask what it would take. Doing the work before you have the title makes that conversation much easier.
Apply to "analyst-adjacent" titles
Reporting analyst, operations analyst, junior BI developer, and data coordinator roles often have lower experience bars. They also teach you the company's data, which is the hard part of any analyst job.
Talk to a recruiter
Recruiters see which employers hire juniors and which skills they screen for this quarter. A short conversation can keep you from applying to roles that were never going to consider a career changer. You can speak with an HTD Talent recruiter for free.
On your resume, describe your current job in data terms. "Built a weekly sales tracker used by 12 store managers" says more than "managed reporting."
How long it takes to become a data analyst
HTD Talent's Data and BI Analytics program takes about 148 hours of study to reach job-ready skills, based on our program data (October 2026). That covers 7 courses and 5 labs, mapped to live job-posting data for business intelligence analyst roles.
| Weekly study time | Weeks to job-ready skills |
|---|---|
| 5 hours a week | About 30 weeks |
| 10 hours a week | About 15 weeks |
| 20 hours a week | About 8 weeks |
Those numbers measure study time to job-ready skills. The job search comes on top of that. How long it takes depends on your market, your background and how many applications you send, and nobody can honestly promise you a date.
If you already know spreadsheets or some SQL, you'll move faster. For more on how prior experience changes the math, see how long it takes to learn to code.
When this path is the wrong choice
Be honest with yourself before you start. Data analytics is a poor fit if you dislike detail work. A big share of the job is checking why two numbers that should match don't.
It's also a harder road if you have no degree. In O*NET's survey of business intelligence analysts, 68% said new hires need a bachelor's degree (O*NET OnLine, 2026). Plenty of employers will look past that for a strong portfolio or an internal candidate. Some won't. Expect more applications and lean harder on internal transfers.
And if what excites you is building predictive models and machine learning, you're probably aiming at data science, a separate path with more math and more Python. The data analyst vs. data scientist guide covers the difference.
Your next step
Pick your route and put it on a calendar this week. If you want a ready-made plan, the Data and BI Analytics program follows the order in this guide, with labs, expert review of your projects and optional certification prep.
If you already know some of this, build your own plan instead. You choose the job, skip what you know, and set your weekly hours.
Frequently asked questions
Can I become a data analyst without a degree?
Yes, though it's harder with some employers. Most of the screening happens on SQL tests and portfolio reviews, so strong projects and an internal transfer are your best routes in. Expect some postings to filter on a degree no matter what.
Do I need to be good at math to be a data analyst?
You need comfort with percentages, averages and basic statistics. You don't need calculus or linear algebra for most analyst roles. If you can explain why a median is more useful than an average for salaries or house prices, you're in good shape.
Should I learn R or Python?
Learn Python unless your target employer uses R. Python showed up in 54% of the analyst postings HTD Talent sampled, and it carries over to automation and data engineering work later.
Is Excel enough to get a data analyst job?
Rarely, for roles titled data analyst. Excel can get you into reporting or operations roles, which are a fine first step. To move into analyst roles, add SQL and a BI tool.
Sources
- Business Intelligence Analysts (15-2051.01), O*NET OnLine, U.S. Department of Labor, 2026
- Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Learn, 2026
- Get Power BI Desktop, Microsoft Learn, 2026
- Google Data Analytics Professional Certificate, Coursera, 2026
- Tableau Public, Tableau, 2026
- Data.gov, U.S. General Services Administration
- HTD Talent's program data (October 2026), Data and BI Analytics program: study hours and share of sampled job postings mentioning each tool

