How to become a data analyst (without the bootcamp fairy tale)
Jeff Baker · November 20, 2026
Learn SQL, pick a BI tool, build projects on real data, and prove it on your resume. That's the job. Here's the pay, the skills employers actually list, and an honest read on the competition.
To become a data analyst, learn SQL, get very good at spreadsheets, pick one BI tool (Power BI or Tableau), learn enough statistics and Python or R to not embarrass yourself, then build two or three projects on real data and put them on your resume. Most employers expect a bachelor's degree. The skills are learnable. The hard part is getting someone to hire you for your first analyst title, so this post spends real time on that too.
What this is based on: BLS Occupational Outlook Handbook (May 2025 pay, 2025 to 2035 projections) and O*NET's employer-based skills data (2025 job postings). Checked November 2026.
Quick credibility note: I've spent about 15 years in marketing and analytics. So I'm going to tell you what the job looks like after the course ends.
What a data analyst actually does
O*NET's profile for business intelligence analysts, one of the closest official matches to "data analyst," lists tasks like creating standard or custom reports for executives and stakeholders, keeping dashboards and BI tools up to date, and identifying trends that affect business strategy.
In real life, the job is roughly:
- Someone asks a question ("Why did signups drop in March?").
- You find the data, which lives in four places and is wrong in two of them.
- You clean it. This is most of the job.
- You analyze it.
- You explain it in plain English to someone who wanted the answer yesterday.
If step 5 sounds miserable, think hard about this career. The analysts who get promoted are the ones who can explain things, not the ones with the fanciest code.
Data analyst pay and job outlook
Here's the honest catch: BLS doesn't track "data analyst" as its own occupation. Analyst work gets spread across several categories. The closest ones in the Occupational Outlook Handbook:
| BLS occupation | Median annual pay (May 2025) | Projected growth, 2025 to 2035 | Average openings per year |
|---|---|---|---|
| Data scientists | $120,230 | 35% | About 24,800 |
| Operations research analysts | $88,940 | 12% | About 7,500 |
| Market research analysts | $78,760 | 7% | About 82,000 |
A few things to know before you start daydreaming about that first row:
- A median includes everyone. Senior people with 15 years of experience are in that number. Your first analyst job will most likely pay less.
- Data scientist is a step up the ladder. The BLS data scientist profile notes that some employers require or prefer a master's or doctoral degree. Many people start as analysts and grow into that title.
- O*NET groups business intelligence analysts with data scientists for wage data, which is why you'll see that $120,230 figure quoted for BI roles all over the internet. Take it with a grain of salt.
The growth numbers are genuinely strong. The data scientist category is projected to grow 35% over the decade, and O*NET labels the outlook for business intelligence analysts "much faster than average." That's good news for the long game, even when the entry-level market feels brutal. Want to know what you specifically could earn? The Salary Coach gives estimates customized to your skills, with negotiation headroom.
The skills employers actually ask for
Forget the "top 47 data skills" listicles. O*NET publishes the software skills that show up in real job postings, based on Lightcast job posting data for 2025. For business intelligence analysts:
| Skill | Share of 2025 job postings mentioning it |
|---|---|
| SQL | 35% |
| Microsoft Power BI | 20% |
| Python | 20% |
| Tableau | 19% |
| SAP software | 19% |
| Microsoft Excel | 17% |
| R | 10% |
| Amazon Web Services | 9% |
| Microsoft Azure | 8% |
| Snowflake | 5% |
How to read this:
- SQL is the price of entry. It's at the top for a reason. Learn it first.
- Power BI or Tableau, not both (yet). Pick the one that shows up most in listings for the industry you want.
- Python edges out R in this data. Learn one well rather than both badly.
- Excel only shows up in 17% of postings. In my experience that's because employers assume you know it, not because they don't care. If you can't do a pivot table and a lookup in your sleep, fix that this week.
BLS also lists the important qualities for data scientists: analytical, computer, communication, logical-thinking, math and problem-solving skills. Notice communication is on there. It's not decoration.
Do you need a degree?
Mostly, yes. BLS says data scientists typically need a bachelor's degree, usually in math, statistics, computer science or a related field. In O*NET's survey for business intelligence analysts, 68% said a bachelor's degree is required for new hires and 23% said a master's.
That doesn't make it impossible without one. It makes it harder, and it changes the strategy. If you don't have a degree, your best shot is usually an internal move: becoming the "data person" on your current team and turning that into an analyst title.
How to become a data analyst: 8 steps
- Pick a lane. Marketing, finance, healthcare, operations, product. Domain knowledge is a huge advantage, and your current job is probably your best lane.
- Learn SQL. Joins, aggregations, window functions. Practice on real public datasets, not just tutorials.
- Get excellent at spreadsheets. Pivot tables, lookups, cleaning messy data. This is where half the real work happens.
- Learn one BI tool. Power BI or Tableau. Build actual dashboards, not just follow-along exercises.
- Learn statistics basics and Python or R. Averages lie. Know distributions, correlation vs causation and how to tell when a difference is real.
- Build two or three portfolio projects. Use messy real data, answer a real business question, and write up what you found.
- Start doing analysis at your current job. Volunteer for the report nobody wants. That becomes your strongest resume bullet.
- Apply with a targeted resume. Match the tools and keywords in each posting (here's how to tailor your resume to a job description), and list your tools clearly with the right skills on your resume.
A portfolio project template
Every project write-up should answer the same five questions. Copy this:
Question: What business question did I answer? (One sentence.)
Data: Where did it come from, and what was wrong with it?
Method: What did I do, and in what tool? (SQL, Power BI, Python, etc.)
Finding: What did I find? Lead with the answer, include one chart.
So what: What should a business do differently because of this?
That last line is the one hiring managers care about, and the one most portfolios skip.
A resume bullet formula
Built [dashboard or analysis] in [tool] using [data source] to answer [business question], which [result: time saved, decision made, money found].
Fill in real numbers from your own work. Don't make them up. Interviewers will ask.
Titles to search (not just "data analyst")
O*NET's sample titles for business intelligence analysts include Business Analyst, Business Intelligence Analyst, Competitive Intelligence Analyst and Market Intelligence Analyst. Add the variations you'll see on job boards:
| Search this title | Usually means |
|---|---|
| Data analyst | General analysis, reporting, SQL |
| Business intelligence (BI) analyst | Dashboards, reporting tools, data models |
| Reporting analyst | Recurring reports, often a good first role |
| Marketing analyst | Campaign and channel performance |
| Operations analyst | Process, cost and efficiency data |
| Business analyst | Can be data-heavy or requirements-heavy, read the listing |
The honest part: competition
Entry-level data analyst jobs are crowded. A lot of people are trying to break in through online courses and certificates, which means a certificate alone rarely sets you apart. Neither does a portfolio full of the same three famous practice datasets everyone uses.
What actually separates you: domain knowledge, projects on messy real data, analysis you've done at a real job, and a human who'll vouch for you. If you're switching fields, read how to change careers for the bigger picture.
And if you want remote: analyst work happens on a computer, so plenty of roles are remote or hybrid. But fully remote listings attract a pile of applicants, and remote doesn't mean you can live anywhere. Most remote analyst jobs still restrict you to a country, a list of states or a time zone. For your first analyst role, a hybrid job can be the easier door in. Then go remote with a title and a track record. 🚀
When you're ready to look, set custom job alerts for "data analyst" with your minimum salary so remote matches land in your inbox instead of you refreshing job boards all night. If you're not getting callbacks, the free "Why am I not hearing back?" quiz takes about 90 seconds and gives you three fixes, no email needed.
Frequently asked questions
Can I become a data analyst without a degree?
It's possible but harder. BLS lists a bachelor's degree as the typical entry-level education for data scientists, and in O*NET's survey of business intelligence analysts, 68% said a bachelor's degree is required for new hires. Without one, an internal move at your current job is usually the most realistic path.
How much do data analysts make?
BLS doesn't track data analyst as its own occupation, so there's no single official number. Closely related BLS occupations had May 2025 median pay of $120,230 (data scientists), $88,940 (operations research analysts) and $78,760 (market research analysts). Entry-level analyst roles usually start below those medians.
What skills do I need to be a data analyst?
SQL first. In 2025 job postings tracked by O*NET for business intelligence analysts, SQL appeared in 35%, followed by Power BI, Python, Tableau, SAP and Excel. You also need statistics basics and the ability to explain findings to people who don't care about your query.
How long does it take to become a data analyst?
It depends on where you start. Someone already working with spreadsheets and reports can often move over in months; someone starting from zero should plan on longer, because the portfolio and job search take as much time as the learning.
Is data analyst a good remote job?
The work is all on a computer, so many analyst roles can be remote or hybrid. Fully remote listings draw a lot of applicants, though, and most still limit where you can live by country, state or time zone.
Is it hard to get an entry-level data analyst job?
Yes, it's competitive. Lots of people are trying to break in through courses and certificates, so a certificate alone rarely gets you hired. Real projects, domain knowledge and referrals are what separate you.
Sources
- BLS Occupational Outlook Handbook, Data Scientists
- BLS Occupational Outlook Handbook, Operations Research Analysts
- BLS Occupational Outlook Handbook, Market Research Analysts
- O*NET OnLine, Business Intelligence Analysts: Summary
- O*NET OnLine, Business Intelligence Analysts: Employer-Based In Demand Software Skills
