Two numbers tell the whole story.
Bookkeeping: -28% job postings. Data analysis: +35%.
One career is shrinking. The other is exploding. And here’s the thing: you already have 60% of the skills you need.
This isn’t a warning. That’s over here. This is your plan. Six months, step by step, from debits and credits to dashboards and data stories.
Salary increase when switching
Median salaries US: Bookkeeper $45,860, Data Analyst $82,360
Why Data Analyst?
Not every career switch makes sense. This one does.
As a bookkeeper, you work with numbers every day. You spot patterns in financial data. You know what an anomaly means. You can run Excel in your sleep. You understand business processes from the inside.
That’s not a coincidence. Bookkeeping and data analysis share a core: structured thinking with numbers.
The difference? Bookkeepers look backward. What happened? Data analysts look forward. What will happen? And what should we do about it?
That’s the shift you’ll train over six months.
What You Already Know (And What You Don’t)
The honest inventory shows: you’re not starting from scratch.
You already have
| Skill | Why it matters |
|---|---|
| Excel (formulas, filters, reports) | Every data analyst’s baseline tool |
| Number sense | You read balance sheets. A data table is easier. |
| Accuracy | Finding errors in data is your daily work |
| Business understanding | Most data analysts have to learn this from scratch |
| Reporting | You already build reports. Soon you’ll build better ones. |
You need to learn
| Skill | Time investment | Difficulty |
|---|---|---|
| SQL | 4-6 weeks | Medium (similar to Excel formulas) |
| Python basics | 6-8 weeks | Medium |
| Data visualization (Tableau/Power BI) | 3-4 weeks | Easy (visual, actually fun) |
| Statistical thinking | Ongoing | Builds gradually |
The 6-Month Plan
Eight to ten hours per week. Mornings before work, evenings, weekends. How you split it doesn’t matter. That you stick with it does.
Months 1-2: SQL + Advanced Excel
You know Excel. Now you’ll get dangerously good at it.
Weeks 1-4: Learn SQL
- SQLBolt.com (free, interactive, 20 lessons)
- SELECT, WHERE, JOIN, GROUP BY. That’s 80% of what data analysts use daily
- Practice with real datasets on Kaggle
Weeks 5-8: Excel at Analyst Level
- Pivot tables (if you’re not already confident)
- Power Query for data cleaning
- XLOOKUP, INDEX/MATCH instead of VLOOKUP
- Build your first dashboards
Time commitment: 8-10h/week
Months 3-4: Python + Data Visualization
Don’t be afraid of coding. Python is the friendliest programming language out there.
Weeks 9-12: Python Basics
- Google Colab (free, nothing to install)
- pandas library: load tables, filter, group
- If you understand
=SUMIFSin Excel, you’ll understanddf.groupby()
Weeks 13-16: Data Visualization
- Power BI (free) OR Tableau Public (free)
- Build interactive dashboards
- Storytelling with data: show the why, not just the what
Time commitment: 10h/week (this is the intensive phase)
Month 5: Your Portfolio Project
This is where your biggest advantage kicks in. Other career changers analyze movie data or Spotify playlists. You take financial data. Your turf.
Project ideas:
- Cost analysis of a fictional company (procurement data, trends, forecasts)
- Cash flow dashboard with anomaly detection
- Industry comparison using public financial data
What you deliver:
- Jupyter Notebook with clean code
- Interactive dashboard in Power BI or Tableau
- 2-page summary: problem, method, result
Upload to GitHub. Share on LinkedIn. This is your application letter.
Time commitment: 10h/week
Month 6: Applications + Interview Prep
Weeks 21-22: Rebuild your resume
- Reframe bookkeeper skills as data analyst skills
- “Created monthly financial reports” becomes “Developed data-driven decision templates for executive leadership”
- Feature your portfolio link prominently
Weeks 23-24: Start applying
- 3-5 targeted applications per week
- Focus on “Junior Data Analyst” and “Business Analyst” roles
- Align your LinkedIn profile toward data analysis
Time commitment: 8h/week
What It Costs and Who Pays
Three paths, three budgets.
| Path | Duration | Cost | Best for |
|---|---|---|---|
| Self-learner (Google Data Analytics Certificate, Coursera) | 6 months | $49/month (~$294) | Disciplined learners with a stable job |
| Bootcamp (various providers) | 3-6 months | $5,000-15,000 | Career changers wanting structure |
| Employer-sponsored (tuition reimbursement) | 6-12 months | $0 if approved | Employees at larger companies |
The Honest Part: What to Expect
No career change without friction. Here’s what’s coming.
The first month of SQL feels like learning a foreign language. By month three, it clicks. By month five, you wonder why you didn’t start sooner.
1. The learning curve is real. Python will frustrate you. You’ll get errors you don’t understand. That’s normal. Every programmer started this way. Stack Overflow and ChatGPT are your friends. Don’t quit in week three.
2. Your age isn’t a problem. It’s an advantage. Companies don’t just hire data analysts. They hire people who understand data AND business. A 25-year-old with Python skills doesn’t have 15 years of financial experience. You do.
3. Impostor syndrome will hit. Guaranteed. You’ll wonder if you’re “too old” or “too late.” You’re not. The talent shortage in data analysis is real. 35% growth means there aren’t enough people. You’re needed.
4. The switch doesn’t happen overnight. Some find a job in month 6. Some need 9 or 12 months. Both are fine. You’re building a career for the next 20 years. Three extra months don’t matter.
Entry-Level Jobs: Where You Start
Forget “Senior Data Scientist.” That’s not your first target. These positions are:
Junior Data Analyst ($55K-65K) Entry level. Build dashboards, create reports, clean data. Your bookkeeping background makes you faster than other juniors here.
Business Analyst ($60K-75K) The bridge between tech and business. Your business understanding is gold here. Many business analyst roles require less Python than a pure data analyst position.
Financial Data Analyst ($65K-80K) Your sweet spot. Finance industry, but with data analysis tools. You know the domain. You speak the language. Hiring managers love ex-bookkeepers for this role.
After two to three years as a data analyst, every door opens: Senior Analyst, Analytics Manager, Data Engineer, or specialized roles in finance. Getting in is the hardest part. After that, it gets easier.
Next Steps
See how automation is affecting your current job
View Bookkeeper Analysis →Salary, growth, required skills, and entry paths
View Data Analyst Profile →Your Personal Career Plan
2-minute assessment with personalized recommendations
More on automation risk for bookkeepers in our detailed analysis.
Data sources: JobPivots database, BLS Occupational Outlook Handbook, ONET OnLine, Glassdoor salary data 2025.*