Data Analyst Roadmap - FASTEST Way To a Data Analyst Job
3 Video Views·Oct 11, 2024
I've talked about how to become a data analyst before, but I've finally put together a roadmap including exact courses and skills to learn.
Becoming a data analyst is actually harder than it's ever been, but it's still the perfect
job for beginners.
It's highly in demand, you can often work from home, and the pay is absolutely amazing
with a median entry-level salary of $74,000 per year.
But the fact is that entry-level jobs are becoming more and more competitive, and while
a certificate might have been enough before, they're simply not enough anymore.
If you don't fix this, you simply won't get a job.
By the end of this video, you'll know exactly how to get a job like this one fast as a new
data analyst, even if you've no specific experience or education.
And there's 5 levels to this, starting with level 1, getting a Data Analyst Certificate.
Data Analyst Certificates are really useful if you do it right, but they're only level
1.
I recommend the classic Google Data Analytics Certificate, and at the end, I'll share a
full Data Analyst Roadmap with all the best courses to take.
Now to get a job, we need to be qualified and credible.
Qualified means that you have the skills, and credible means that somebody wants to
hire you.
Luckily, it's pretty easy to achieve.
So how do you become qualified?
If you feel like you understand the basics of data analysis, then you're qualified for
an entry-level job as a data analyst.
You don't have to be an expert.
It's about knowing the fundamentals, so you can often learn things on the job, although
you do need a few key things.
Once you've completed a Data Analyst course, it's easy to get stuck.
That's why in level 2, it's now time to specialize in the skills you really need.
Firstly, we have SQL.
SQL means Structured Query Language, and it's for working with databases, basically large
amounts of data.
SQL is an absolutely essential skill as a data analyst, and I recommend Codecademy and
their short SQL courses.
This comes at a cost, but wait, I've got a free option for you that's just as good.
You can learn SQL for free on We3schools, and they offer free, hands-on learning.
Remember, you don't have to be an expert at SQL to land your first job as a data analyst.
Moving over to level 3, you need to learn Python or R. Do you need to be an expert?
Again, no.
All you have to do is understand the basics of Python and some specific data analyst tasks
like web scraping or creating visualizations.
Honestly, if you know the basics, you can just google the things you need when you need
it, so don't worry if you don't know everything right now.
I prefer Python since it's beginner-friendly and widely used, opening up lots of new jobs
for you.
The course Python for Everybody is a great way to get started, but that requires a subscription,
so a great free alternative is CS50 Introduction to Programming with Python.
It's a free online course that comes with a free Python certificate.
Next, level 4, learn Tableau or Power BI.
Both visualization tools are popular, so which one should you pick?
I recommend just taking a quick course on one of them or both, for example these ones
on Datacamp.
They're just a few hours long and will give you the basic Tableau or Power BI experience
to put it on your resume.
If you're looking for your first data analyst job, that's definitely enough and you can
focus on other things.
Level 5 is the step where most people mess up.
I remember starting out thinking all I had to do was take some courses, and I was so
wrong.
Because the most important thing is not a course or a certificate, it's how you can
show these skills to employers.
It's about becoming credible.
Let's make some portfolio projects to do this.
Projects are essential to learn and show your skills to employers.
You can be qualified, but you need a portfolio to land a job.
I recommend keeping your first projects very simple, guided projects on Coursera are perfect
to get started.
I like this one, COVID-19 data analysis using Python.
You follow along with the instructor on a split screen, and after you're done, you get
a Python project that you can put in your portfolio right away.
Some projects require a subscription, but there are lots of free projects too, and they're
definitely enough.
You still need a portfolio to put your projects in, so head over to Kaggle, a free site by
Google, create your account and then a notebook, upload your projects and make them public.
After that, you can add a link to your Kaggle profile in your resume like this.
It's really simple.
I would say put 3-4 projects in your portfolio to start as a beginner, and then just keep
adding more projects while improving the quality as you get more experienced.
To make your resume, check out these free templates on Canva, they're specifically for
data analysts so you can see what a proper resume should look like.
If you want me to make a more dedicated video on creating a portfolio, let me know in the
comments.
Now, how do we get a job?
Well, you can start looking on the popular websites like LinkedIn and Indeed, but I would
also encourage you to check smaller websites with lower competition.
For example, I found this job site specifically for data analysts.
It's on Datacamp, so the companies will likely value your online certificates higher compared
to others on LinkedIn, because you know, the company is hired through an online course
website.
Many of the jobs are remote, and it's free to sign up and use.
Keep improving as a data analyst every single day, because even though you may not have
that job now, you can do it.
I believe in you.
The full data analyst roadmap including exact courses and free projects are linked in the
description, and check out my other videos here where I help you become a data analyst
and get a job.

