Data Analyst Roadmap 2024 | Data Analyst Weekly Study Plan | Free Resources to Become Data Analyst
2 Video Views·Nov 26, 2024
The only roadmap you need to learn data analyst skills in 3 months by spending 4 hours a day. No clickbait, no BS. Only real advice. The previous version of this roadmap has already helped many folks prepare for data analyst skills and get a job. I will discuss all the FREE learning resources, exact week-by-week study plans, assignments, and milestones. This also contains a free assignment tracker where you can track your weekly progress. We will also discuss resume and interview preparation for the data analyst job profile with a free resume and LinkedIn check list.
This is the time of the year where many YouTubers publish roadmap videos
and many of them talk about unrealistic things such as
become data analyst in one month or get 10 lakh per annum job etc.
I'm not going to say anything unrealistic just to increase the views
of this video. Following this roadmap will require
three to six months time period where you have to spend four hours in
your study every day. Basically it requires a lot of hard
work so if you're looking for a shortcut do not waste your time
leave the video right now. The roadmap will cover week by week study plan
using free learning resources, assignment tracker and lot of
checklist which will help you become a data analyst.
Now I say this with a lot of confidence because me and the
co-creator of this video Hamanan, we both are hiring managers.
We interview data analyst candidates in our company's ethnic technologies
and core basics. In fact Hamanan has seven plus years of data analytics
manager experience in Europe. I also have 12 plus years of
industry experience working for Bloomberg USA. So whatever we are saying
is based on real industry experience. Talking about upskilling we'll talk
about tool skills and also core skills.
Once you have learned all these skills they are not enough
you have to learn how to showcase your work
so that you can get an interview call and crack the interview.
Now let's move on to the pdf file for the roadmap.
This is something you can download from the video description below.
Here it says three months time period where one and half hour goes in tool
skills one hour in core skills etc. Okay now before you start with week number
one there is week zero where you need to do
proper research to protect yourself from scams.
If you look at some big influencers like Sandeep Maheshwari
they are now talking about these scams which are happening in the market
where people sell their courses by making false promises.
Many times you will see youtubers influencers
and people who make courses they do not have real industry experience
they are just good in talking they are good in making false promises
and they are able to sell their courses so if you get caught
in these scams it is going to be very bad for you.
So first do a proper research I have provided some videos and some linkedin
post in the linkedin post you will see
comments from people where they will talk about the
scams that you know they were victim of.
Basically the idea is you learn from a legitimate instructor if the instructor
has industry experience that is always good because then they
are not teaching you just the theoretical concepts they can
tell you how these concepts are used in the industry so they can make you
industry ready in a true sense. Excel is the most
basic and fundamental skill that you need to learn
as a data analyst so in week one and two you'll be focusing on that
as well as business math and statistics and in terms of
core skills you will work on creating a linkedin profile.
Now in excel it's a big topic you don't need to learn
every single feature of excel you just learn basic formulas some advanced
formulas pivot table basic charting etc you don't
need to learn VBA macros etc because they are dying down
okay you can do the same thing in power query and using other features
so you can ignore VBA and macros in terms of
learning resources I have this youtube video
where we talk about using business math
in excel and in this video we have given
data sets we have given all the necessary resources
for generating let's say pnl and so on and here we are covering
the essential concepts such as mean median mode variance
standard deviation average percentages the 20 percent concepts that you will be
using 80 percent of the time they are all
covered okay another resource that we have is google
template library so if you click on this you will go here
here you see various templates and if you click on lesson monthly budget
it will show you this particular file where you can
enter your monthly budget numbers so what you have to do is you have to
start using this excel file and then try to
understand what kind of formulas are written for example if you look at
any cell here for example this one there is a sparkline formula
then there is if formula here okay you can also customize this file as per
your need so you are becoming your own client
you are using it for real life use cases and you're not only learning it but
you're customizing it as per your need there is another file
called annual budget you can go through it
it is self-explanatory here you can maintain your expenses
income etc now there is a this website called vertex 42
where they provide these kind of templates but in
excel format xlsx previously we were talking about google sheets
so you can download any of these templates for example college student
budget so if you are a college student use this and try to understand what
kind of formula they are using try to customize it for learning excel i will
recommend using chandu's youtube channel he provides
a lot of useful tutorials so if you want to learn any particular concept in excel
you can go through this now say if you want to spend some money
and you want more structured way of learning excel
then i myself have this excel course where we have covered
all the basic concepts plus the advanced concepts such as how do you
do data transformation using power query
in excel many people are not even aware that you they can use power query in
excel we have covered some industry projects
and so on all the reviews are real by the way
so you can check that out while you're learning excel
you have to also learn business math and statistics in that
you learn the concepts such as arithmetic percentages what is market
share what is year over year growth and so on
and all of those things we have covered in the video that i just mentioned to
you few seconds ago the video is available in both english
and hindi there is a khan academy course also on
this topic for example introduction to percentages
so you can watch that you can also refer to mathisfun.com
this website is really good it provides you simple
explanations now in terms of your core skills
you need to focus on creating a linkedin profile
now linkedin profile is not something you will create after you have learned
all the data analyst skills etc it is better
if you start working on core skills while you are learning the tool skills
so that way you can make progress in both the direction
in parallel okay you have to create a professional looking linkedin profile
and for creating a linkedin profile we have given
a complete checklist so if you again check video description
you will be able to download this linkedin checklist
where you are given all the instructions such as
how do you create personalized linkedin url okay you can create using this
option and when you have created it just tick
tick mark this okay tick mark this as you keep on checking these
boxes your profile will keep on getting better and better as a motivation i want
to refer you to this interview where a bcom person
got five data analyst job offers Arijit Sadhu was that person
and he had a bcom degree and despite that he got
five data analyst job offers in big companies like bank of america
ansan young and so on so you can get a lot of
useful career insight related tips from this particular video now we have
given you the assignment so you can open assignment tracker which
we have built in a tool called notion so if you click on this link you will
get this particular page you can just create a duplicate okay and
if you don't have an account on notion notion is by the way free tool
it helps you track your assignments you can
create a free account okay and after the free account is created
when you click on duplicate it will copy the template that i have given you
to your personal space so i'm going to let's say add it to my private space
here and it will create the duplicate copy so
when the copy is created that copy is your own copy now here you
can track your assignments so for example
for the week one and two we have all these
assignments right so create a professional looking
linkedin profile so if you click on open you will be able to open the page you
will have more details but once that task is complete you can
say done okay this is done then if you have used your linkedin
checklist then okay this is done and as a result what will happen is
in the grid that is above your progress will change so here see i
have 33.3 percent progress you see we can
one two thirty three point three percent progress
so this way you can track the progress uh for your
12-week study plan and it will be better if you can create
a group with your friends let's say your friends also wants to learn data
analysis okay you will create a group and then you can
have weekly meeting and you can hold each other accountable you can check
each other's progress that way you will have motivation you
will be more thrilled to do this study it's like going to
gym if you go to gym alone it's not going to be fun but if you go
with bunch of friends it's always fun now the quick insight here is that only
60 among 100 aspirants will continue further
you can be one of them if you are disciplined and committed
for a data analyst knowing one bi tool is a must
you can learn either power bi or tablu which are popular bi tools
or say if you're learning power bi you need to learn
how you can connect power bi with different data sources
how you can do data transformation in power query and all of these topics
in terms of your free learning resources you can use
sales insight power bi project now in this project
we are not only going over power bi basics
but we are teaching you how you can execute
a data analytics project using power bi in the industry
if you look at the views and read the comments you will get an idea on the
quality of this particular playlist and this playlist has
helped many people get a job it is totally free
data set everything is available on youtube we have
other guided projects too for example in this project we
invited abhishek who is a manager in oyo rooms he's a revenue manager in
oyo rooms which is a big hospitality company
in india and here he gave the requirements from the hospitality
industry standpoint and we built a power bi dashboard the
other project is end-to-end t20 cricket data analytics
where we downloaded t20 world cup cricket data from espn
cricket info we actually did web scrapping okay so we
covered web scraping then we covered data cleaning and
transformation using pandas and then dashboard building in power bi
the other project is hr analytics i'm sitting in atlix
office which is a software and data analytics company and
we invited hr of this company uh to give the requirements on the insights
dashboard that she wanted to build and we built
this dashboard so all of these projects are
real life projects we are not using any toy data sets here
now one may have confusion whether they should learn power bi or tableau
if you ask me i will always say power bi because
as per gardner's research power bi is consistently
ranked as number one bi tool and the adoption
of power bi is increasing see microsoft has a
deep penetration in the industry so for them
it is easy to sell power bi therefore i believe
learning power bi makes sense tab is also a good tool so if you have strong
reason you can definitely learn that for tableau
also we have given a few videos here for
learning power bi you can use all of these youtube
channels which we have mentioned here if you are interested in uh learning
in a very structured way then we have a power bi course as well
talking about soft skills on linkedin you need to start following some
prominent data influencers for example haman and body will
writes nice linkedin post here he talked about
what is domain what is functions and how these things help you
in your data analytics career so when you're reading this post when you're
following these data influencers you not only get
to learn things but you can also engage let's say if
you have a question you can ask a question and maybe him on will respond
now folks when you engage in linkedin post make sure you write
meaningful comments see these are generic comments which no one will
engage to but if you write a meaningful comment
then there will be many people who will engage and you'll ask me
that okay if naveen uh wrote this uh comment
and if 11 people liked it what's the big deal well
these 11 people some of them might be data analytics manager they might be
or there could be a data analyst working in the industry
now when they like your comment you are leaving a good impression
on their brain so if you keep on doing this again and again
then that person will build a good repo okay and if they are hiring in their
team you can ask them for a referral or maybe
they'll reach out to you and you can get a job so engaging on
linkedin is definitely valuable now moving to core
skills you need to build some strong business fundamentals for this
you can follow some business case study youtube channels for example think
school they have this case study on how amul beat
the competition during covid and this person talks about uh data
analytics variety of numbers and also he gives
business understanding so by watching these videos by understanding
this business case studies you are making your business fundamentals
stronger and in the video description you will
find a link of a discord server where we have like around 40 000 members
again this discord server is free so if you're learning power bi excel if
you have any question you can post the question there
and some of the community members will help you okay
now when you post a question there is an art
that you need to use you can't just uh post a question hey i'm stuck here
someone help uh you need to say things little differently you should send a
message that look i'm doing my due diligence
and all i'm asking is for a direction and i'm not
uh expecting any ready-made answer so when you learn
that art and by the way i'm linking all this a linkedin post so that
you can learn the art of asking questions in a right way
for motivation we interviewed uh rohini krishnamurthy
who was working as a nurse for many years then she had a
career break as a mom then she learned data analytics and right now she's
working as a data analyst in the industry
so by watching this particular interview
you will get some solid tips and then here is the assignment folks
use this assignment use the notion board that i talked about earlier
uh for example one of the assignment is making a post on unguided project
here let's say haris uh made this post where he
uh presentation see uh you are learning data analytics you are presenting
insights and you are also uh publishing a video presentation
which will help you improve your presentation skills
and then people will engage and overall it's going to be very beneficial
in terms of your core skills in week six seven eight you need to focus on sql
we call sql a sort of data science it is a must skill
for any data analyst now in sql you don't need to learn
everything for example you don't need to learn database creation index triggers
etc that is more for data engineers dbs and
so on here you want to focus on the basics of
sql's what is relational database joins and so on
in terms of learning resources we have this free youtube video which is
one hour 26 minute it will teach you all the basics
which are needed for a data analyst we have given data set exercise everything
so you just watch this video and you will learn these skills you can use
other resources w3 school sql board etc and we have a course
on sql on our website now when it comes to
core skills uh in this three-week time period
you want to improve your presentation skills and for this
my most favorite video is on youtube which is
how to avoid death by powerpoint this person has given amazing insights
on how you should build your powerpoint presentation and how you should improve
your presentation skills so please make sure you check it next comes the
ats resume ats stands for application tracking system
a resume which is compliant to ats so that your resume doesn't get
filtered automatically now we have made a video
on how me and him on we screen the resumes
when we interview in our past experience we have interviewed hundreds of
candidates we are interviewing people even right
now so from interviewer standpoint what we look for in the resume we have
discussed that your resume should be single page it
should use star methodology for project
description and so on you will be able to download a resume
checklist again check video description and all
you do is whenever you have your resume let's say
your template is simple it is friendly you just check
you use this check marks to make your resume
proper so when you have checked all these marks your resume will be in a
better shape now folks resumes are not dead
yet but they are dying because resumes cannot show
your live work in order to show live work you need to build something called
portfolio website or a project portfolio website
for this you can use variety of tools such as novi pro
a link tree you can post your project on github also
uh for code basics bootcamp students we have this portfolio website
let me show you that here in this website
you can give your your background you can also showcase all your project for
example this particular project is business
insights 360 where you can see the screenshot
description and so on not only that you can interact with a
live dashboard see this is a live dashboard i can click on it
i can click on different visuals different insights
so if an interviewer is looking at this particular website they will get
a better understanding of your work when you are in the interview maybe
interview can be conducted based on this
and this will give you a lot of benefit not only in getting the interview call
but during the interview also in uh cracking the interview
these website will become very useful in terms of
assignment you need to participate in sql resume
project challenge so on our website codebase.io
we conduct this free resume project challenge
where we give a data set problem statement
you work on the project and then you write a linkedin post you build a
presentation and you showcase your work as if you are
presenting against the business stakeholders the
insight at this point is that only 30 among 100
aspirants will continue further and you definitely want to become
one of those 30 people week 9 and 10 is all about python and pandas
now folks there are some data analyst jobs where they
don't require python and pandas but then there are other jobs where they need
this so you can keep this optional but if
you have time and if you learn this it's not gonna
hurt in python you need to learn all these
basic concepts for which we have a youtube playlist along with
the exercises so if you look at these exercises
they are having solutions nice problem statement solution
so you learn from youtube video you practice on exercises
that way you can make your python fundamentals stronger
in terms of pandas you need to learn only these many topics
panda is a vast library there is so much to learn
if you go and start learning everything it will take you a long time
therefore just focus on the things which are required by a
data analyst role for pandas playlist we have a youtube
playlist for pandas in which you need to go through
only first nine videos talking about project management
the world is using agile project management methodology
in which there are two popular techniques called scrum and kanban
and we have free learning resources for them as well
you can also leverage chat gpt to handle various areas of your data
analytics projects such as data collection data cleaning and so on
and for all of these areas we have given
videos we have given different prompts that you can use
so go through these prompts and learn how you can use
ai how you can use chat gpt to make yourself
more productive how you can become ai enabled data professionals now domain
knowledge is super important for a data analyst career role
and for that we have given 15 different learning resources the links are here
go and watch them for assignment you need to make a linkedin project post
for example aryan sharma participated in our resume project challenge
then he made this linkedin post where he talked about the insights that he
generated with the power bi dashboard that he had
built now when you are building this
presentation and making a video post on linkedin
you're not only improving your presentation skills
but you're getting attention of a potential recruiters
for example this post got 764 engagement
and if let's say this particular person clicked on the like button
that person might have five other people and let's say if one of those people
is a hiring manager your post will show up in their feed
so you are getting attention you are getting visibility
in this linkedin market where many recruiters are also active
by the way aryan sharma got a job because of his resume project
participation you can go through his profile and read
the post that he made okay so i think in this post he has mentioned
how he got a job at this particular company
resume project challenge is something that we conduct every month so if you go
to port basic.io click on resume projects
you will be able to participate in these challenges for free there is no charge
we give a problem statement then you make a
data analytics project and then in the end you make a
nice linkedin post just like how aryan did it
the insight at this point is that you are among 20
out of those 100 aspirants if you have come this far
all right you are done with your studies and week 11 and 12
is for interview preparation for a school interview there is a website
called data lemur again free website where you
see questions which are asked in different
companies for example this question was asked in twitter here you can read
the question practice it and you can run the code to see the results
you can then compare your results with the solution
so you need to create a login here and when you click on solution and discussion
you will be able to verify your solution tech tfq
channel is also another good resource for sql interviews
and for power bi interviews learn with gigs
is another good youtube channel here i have given
you a link of all unguided projects and these projects are nothing but
different resume project challenges that we have been conducting so you can
go through these projects and practice them so as you
practice more and more your skills will become
more stronger for job application also i have given some resources such as how do
you use cold emailing for applying for jobs
how do you ask for reference and so on so the assignment for week
11 and 12 is you participate in more resume project challenges
and then you make linkedin post for that okay
and you will also work on all these assignments now if
if you are at this stage you are among five or ten among those hundred people
who started so there are many people who will start
learning data analyst new year is starting they will take a
resolution that i want to become a data analyst but
majority of the people give up because nowadays people don't have
patience they can't continue with the committed
effort but let's say if you come this far
then that means you are one of those five person or one of the rare people who
are committed and you should be proud about yourself
so far we have talked about using different internet resources
for your learning but let's say if you're a person who doesn't want to go
through different resources and who want to
learn through a single resource in a step-by-step
manner then we have a bootcamp so on code basics you will see
uh the data analyst bootcamp which is highly rated
you can read all the reviews here if you click on view all
you will see the reviews you can click on the linkedin
profile of this particular person of course see if if it is my bootcamp
obviously it's hard to believe uh that okay whatever i'm saying is
true but you can talk to one of these learners
who have taken these courses and they will give you
the the honest review about the bootcamp now i want to give some tips for
effective learning whenever you are consuming these videos
or reading articles that is one small portion the
portion where you need to focus more is in digesting implementing and sharing
so let's say i watched a video on sql joins
that is just a small portion after you have watched this video
with a focused mind try to think about it what did you learn you know
close your eyes take note and pen and write down
what did you learn and try to digest that information
then implement it so try to practice some sql queries which is using
joins so by implementing also your understanding will become
solid and also try to share so if you have made a group with your friends
for studying data analytics then share your learning with your friends
maybe try to help them try to help people on our discord server
talking about discord server uh we have this partner and group finder channel
where see this person is saying i want to learn data science
um can someone help can someone join me and there are a couple of people who are
showing the interest so this way you can make a group and we
want to go back to our gym example if you go to gym alone
you're not going to like it but if you go there with bunch of friends
you will love it so use the same method here
for your learning i recently published a video on how to land a job as a fresher
in 2024 and in this video we have shown a job
funnel where i have shown how people get filtered
at each stage uh in that job funnel so watch this video
and we wish you all the best both me and haman and
we wish you all the best for your learning journey
this pdf checklist folks everything is available for free in the video
description all you need is download it and learn
with commitment okay commitment is very important
if you have any question post in the comment box below
me and haman and will try to answer as many questions as possible
bye bye

