The Roadmap to Become a Data Analyst

šŸ” How I Would Become a Data Analyst In 2025 (if I had to start over again)

November 20, 2024ā€¢4 min read

If I woke up one morning and suddenly lost ALL my experience in data and HAD to start ALL OVER, here are the 9 steps Iā€™d take to become a data analyst as quickly as possible in 2025 šŸ‘‡

1. Exploring the Various Data Analytics Job Opportunities

In the data world, there are way more job titles than just ā€œData Analystā€. Thereā€™s:

  • Business Analyst

  • Financial Analyst

  • Marketing Analyst

  • Operations Analyst

  • Pricing Analyst

  • Business Intelligence Engineer

  • Qualitative Analyst

  • Data Viz Specialist

  • Product Analyst

And a bunch more.

Iā€™d first try to see which of these might match my prior experience best & select it as a target

2. Pinpoint the Necessary Skills as a Data Analyst

Before going straight into learning data skills on an online platform, Iā€™d actually try to figure out exactly what I need to learn. Iā€™m lazy so I donā€™t want to learn more than necessary.

How would I know what to learn? By studying the crap out of job descriptions for roles I picked out in step 1. Or I could just trust what the research in this article says here.

Short answer? ETS.

Excel. Tableau. SQL.

You can remember it by ā€œEvery Turtle Swimsā€.

These three amigos are your best betā€”the simplest, easiest, and most kick-butt starting point. It's like reaching for the low-hanging fruit; they're all easy to learn & used the most in the field.

3. Create a Plan to Gain Hiring Managerā€™s Trust (Projects)

I wouldnā€™t be able to land a job because I wouldnā€™t have experience.

But I couldnā€™t get experience until I landed a job.

A real frustrated ā€œchicken or the eggā€ scenario.

So Iā€™d need to create my own experience, or at least some tangible evidence to get hiring managers to trust me.

So Iā€™d create projects.

Theyā€™d serve as my ā€œexperienceā€.

4. Learn The Basic Data Analytics Skills (and only the basics)

This is when Iā€™d start actually learning stuff. Not before figuring out my target role, figuring out whatā€™s required for that role, and realizing I need projects.

Iā€™d learn by building projects on real data.

Where would I get real data? Iā€™d follow this simple guide here.

But if I wanted high-quality projects with guidance, Iā€™d consider something like The Accelerator.

5. Create a Home for My Projects (Data Portfolio)

Of course, once I built the project, Iā€™d need to have a home for them. Projects canā€™t serve as evidence if people canā€™t see them.

Iā€™d stay away from GitHub (too messy, too ugly, too complicated).

Instead, Iā€™d shoot for something like Carrd or LinkedIn.

6. Optimize My LinkedIn and Resume for Success

When Iā€™d be applying for jobs, my LinkedIn and resume would be the only two things I can really control.

Iā€™d optimize the crap out of these to PASS THE ATS. Thatā€™s the only purpose of my resumeā€”get me past the ATS.

So Iā€™d try to:

  • Keyword stuff

  • Utilize action verbs

  • Quantify my achievements

  • Mention my desired role title AMAP (as much as possible, I think I made that up? Is that a term)

7. Start Applying For Jobs Like a Scientist

Next, Iā€™d start applying for jobs.

Iā€™d start early and often, realizing itā€™s a numbers game. Rejection sucks. But 99.99% of job seekers will receive DOZENS of rejections. Itā€™s just part of the process. Iā€™d try to not take it personally and just move on to the next one.

Iā€™d also track all my applicationsā€”that way I could approach it from a data-driven approach.

8. Start Networking Like a Friend

Since Iā€™m starting from scratch, Iā€™d assume I donā€™t have many contacts in the data world. Darn it.

But Iā€™d start with the contacts I do have.

So Iā€™d simply just follow ā€œThe Phone Book Method.ā€ Nothing fancy, but itā€™s a start.

9. Prepare for Technical and Behavioral Interviews

Lastly, once Iā€™m building projects and posting on my portfolio, applying for jobs, and networking as a friend, interviews are bound to start soon.

Iā€™d want to make sure Iā€™m prepared as h*ck.

Iā€™d practice technical interviews on StrataScratch & behavioral interviews on InterviewSimulator.

Full disclosure, Iā€™m an affiliate for StrataScratch and I created InterviewSimulator, so Iā€™m biased but I do think these are the best tools on the market for data interview prep!

10. Wait For Offers to Trickle In

If I successfully did steps 1-9, itā€™s only a matter of time before an offer would come.

I would be important for me to remember that luck plays a role here, but the more and the better I follow steps 1-9, the luckier Iā€™d get.

Iā€™d keep repeating steps 1-9, until I get the dream offer.

I hope these 10 steps are useful to you!

Youā€™re welcome to follow these steps on your own, but if youā€™d like a step-by-step plan, a coach helping you, and a community supporting you, consider joining my all-inclusive data analyst land-a-job bootcamp, The Accelerator.

<< Click here to check it out>>

The king of all things data

Back to Blog

Subscribe to the Newsletter

Join 10k other aspiring analyst & get these articles sent to your inbox, every week.

Read More Articles

Learn the fundamentals of a data career, one article at a time.

Listen to The Latest Episode

Prefer audio versions of these articles? Subscriber to our podcast!

Data Career Newsletter

Join 10k+ aspiring data analysts and get technical tips, expert analysis, and career advice in your inbox.

ā­ā­ā­ā­ā­

Trusted by 10k+ Data Analysts

123 Elmwood Drive Suite 456

(555) 123-4567