馃攳
Complete Data Analyst Roadmap | How to become a Data Analyst | Data Analytics Career Job and Course - YouTube
Channel: Anuj Bhaiya
[0]
Lrt's consider one scenario
[1]
on last year's Diwali
[3]
Urban Company noticed that they have high demand
[5]
in the beauty category, but
[6]
they are short of partners
[8]
because of which they are unable to fulfill the demands
[11]
because of which the business is suffering loss
[12]
so they didn't want to repeat the same mistake this Diwali
[16]
so they want to onboard many partners
[18]
but how many should they partner with?
[19]
they want to make some technical features but
[22]
what features should they create?
[23]
which technical features will improve the metrics
[26]
in the direction they want
[28]
which business decisions to take
[30]
to figure all this out, they have to analyze the data of the previous year
[34]
and there comes in the data analyst
[36]
the job of a data analyst is to basically
[37]
to convert a raw data into something meaningful, so that
[41]
the business person
[43]
who can be managers or CFOs
[45]
up to the higher positions
[46]
they can make a decision
[48]
they can make out that ok, these things are required in the company
[51]
so that product managers can work on it
[54]
or whichever the category manager is
[56]
or the operation manager
[58]
they are able to work with that data, so that
[60]
so that the quota/ result of this year or this quarter can be fruitful
[67]
so the job of the data analyst is to basically help
[69]
nowadays all the companies has a lot of data
[71]
so with the help of the data
[73]
how you can beat the competition
[76]
how you can draw meaningful insight from it
[79]
how you can convert or interpret it
[81]
in terms that people who don't know what is data can also easily understand it
[85]
who do not understand data at all
[87]
to explain to them as well
[88]
is the job of a data analyst
[89]
ok
[90]
so we understood what is the job of a data analyst
[92]
today we will understand about the road map of a data analyst
[95]
it is a very important field
[96]
it is a very demanding field
[97]
nowadays almost all companies require a data analyst
[102]
how can you become a data analyst
[104]
what are the pre requisites, what are the requirements
[106]
what skills are needed
[108]
how you have to make your resume
[109]
which companies are providing jobs
[111]
and how you can ace the interview
[114]
this video is around that
[115]
and the actual reality
[118]
the reality in India around data analyst
[120]
we will talk about it
[121]
there will be some harsh reality as well in this video
[123]
so don't mind that
[124]
we will be talking authentically about
[126]
what is the current scenario in India
[128]
around data analyst
[130]
apart from that the future scope
[132]
we will be talking of that as well
[133]
so the entire road map of data analyst
[135]
which was in demand since few days
[136]
we will be talking about it today
[138]
before moving forward, I would like to thank Crio for sponsoring today's video
[141]
Crio is world's leading work experience based learning platform
[144]
with the help of which you can learn new skills in software development
[147]
to land top development jobs
[149]
compared to other courses
[151]
in Crio you can get fullon hands on experience on learning
[154]
you have two programs here
[157]
Full Stack & Backend development program for 6 months
[160]
where you can make work like projects
[163]
in real development enviroment
[165]
for example, here you can learn how zerodha & zomato's backend programs work
[169]
or how Airbnb & Netflix's frontend programs work
[172]
and you will be learning technologies around it
[175]
and you can grow just like you would
[177]
on a real job
[178]
after 6 months of program, you will have projects in your resume
[182]
you will have skills in your resume
[184]
which can easily impress any recruiter
[186]
you will be learning multiple skills
[188]
like AWS, Docker, React, Node, MongoDB and much more
[192]
apart from this, in Crio
[193]
you will get personalised career assistance
[195]
to land your dream job in software development
[198]
so what are you waiting for
[199]
use the link in the description box
[201]
to get additional 10% scholarship
[203]
to their signature programs
[204]
and unlock free resources now
[206]
on that note let's continue with the video
[208]
let's talk about responsibilities
[210]
that what do data analysts do?
[211]
so I already told you that
[213]
basically their job is to analyze the data
[215]
to analyze the data they are doing multiple things
[218]
they have to classify the data
[219]
that which data we have to pick up
[221]
because data comes from multiple resources to the companies nowadays
[225]
to assemble them in one place
[226]
they have to clean the data
[228]
means to remove the redundancy
[229]
to remove irrelevant data from it
[231]
all that work
[232]
then they have to interpret it
[234]
to analyze it
[234]
to interpret means
[235]
to change it in such a form so that
[238]
managers can understand it
[239]
basically create a graph around it
[241]
to draw estimations from it
[244]
to predict the future
[246]
this is the job of a data analyst
[248]
ok
[249]
it is a highly demanding field
[250]
let's talk of pre requisites
[252]
if you want to be a data analyst
[253]
so what will be the requirements
[255]
so you should know aboout mathematics & statistics
[258]
this is must
[259]
you should have good knowledge of mathematics & statistics
[263]
you should have a bachelor's degree
[264]
it is recommended that
[266]
if you have bachelor's degree in mathematics or cs
[270]
then you would be preferred
[271]
but it doesn't matter
[273]
I have seen many people who
[274]
are in marketing
[275]
even people from arts
[277]
if their knowledge of maths & statistics
[280]
then they can also become data analyst in a company
[283]
so what matters the most is your skills in
[285]
mathematics & statistics
[287]
in some companies, colleges also matter a lot
[290]
so I have seen this alot around data analyst
[292]
that there is a lot of bias here
[295]
there is alot of discrimination in the field of data analyst
[297]
the more reputated college you are from
[298]
that much easier it would be for you to get a job
[301]
then what can be the job profiles?
[303]
so data analyst is obviously a job profile
[305]
but in the same umbrella we have multiple things as well
[307]
one is marketing analyst
[308]
business analyst
[309]
research analyst
[310]
risk analyst
[311]
operation analyst
[312]
so with this skill set you can apply for any of this job profiles
[317]
before moving forward, there is a small request for you
[319]
if you are still watching this video till here
[321]
then do like the video
[322]
also subscribe to the channel
[323]
if you haven't
[324]
lets continue
[325]
now let's talk about skills
[326]
which skills you should have?
[328]
first is excel
[329]
and not just basic excel, you should know advanced level of excel
[333]
basically the thing is
[335]
that in data analyst
[336]
are you qualified or over qualified?
[338]
over qualified has an edge here
[340]
because competition is very high
[342]
this is the harsh reality
[343]
of becoming a data analyst in India
[346]
in Excel, you must know advanced excel
[348]
you must know functions, VLOOKUP, macros, charts
[351]
you must know all this
[353]
then SQL
[355]
you must know structured query language properly
[358]
not just basic or intermediate but you should know advanced level of SQL
[363]
which are like
[364]
ofcourse basic things like aggregate functions, joints, etc
[368]
views you should know
[370]
generalized views, but apart from that
[372]
how you can optimize the query, that also you must know
[374]
triggers and transactions
[376]
all these things are in advanced SQL
[379]
how can you learn all this?
[380]
so I will give the link in the description
[381]
there are some courses
[382]
if you will follow them,
[384]
then you can easily learn this in a few months
[388]
if you want you can learn both the things parallely in a month
[391]
you can easily learn advanced level of Excel & SQL
[395]
then we will talk about the programming language
[397]
so programming language is not much require from a data analyst
[400]
but considering the competition nowadays
[401]
the more knowledge you have, the more are your chances of getting hired
[407]
so in programming language,
[408]
we have python, R and SAS
[409]
if you know python well
[411]
there are also some libraries in python
[413]
data manipulation libraries are present
[416]
like pandas, num pi
[417]
if you know these things then
[419]
you will have an edge
[420]
then if you know R then
[422]
basically it depends on the companies
[423]
there are some companies that work in python,
[426]
some work in R
[427]
mostly banking companies like city bank uses SAS
[433]
so these are your programming languages basically
[435]
which you can learn
[437]
here you don't have to know advanced stuff
[439]
here you don't have to learn proper oops
[442]
or learn proper algorithm
[444]
like machine learning algorithms
[446]
it is not much required from a data analyst
[448]
but if you know more things,
[450]
then it will be beneficial for you
[452]
from which you will make projects
[454]
which you can highlist in your resume
[455]
that also we will be discussing later
[457]
so this will be your programming language
[459]
if you know any one language, then it is good enough
[461]
I would prefer python because
[463]
if you know python,
[464]
it will be helpful if you want to be data scientist
[468]
then visualisation tools
[470]
so basically there are data visualisation tools
[472]
power bi is in microsoft
[475]
tableau is from sales force
[477]
so these are your tools
[479]
with which you can visualize data
[480]
you can gather data from multiple sources and
[483]
you can condense it in one
[485]
and you can perform all these things using these tools
[488]
so you should know how to use the tools, how to visualize with it
[493]
then soft skills also plays a big role
[496]
in your interview selection
[498]
also in your salary negotiation
[500]
soft skills play a big role
[502]
it also depends on the company
[503]
whether they are preferring technical skills or
[506]
soft skills
[507]
management & analytics companies will prefer soft skills
[511]
soft skills like
[512]
your communication skills
[514]
your time management skills
[515]
your problem solving skills
[517]
and analytic skills
[518]
these things will matter
[520]
in such companies but
[521]
start ups & fast moving companies
[524]
there your technical skills are considered
[526]
they think that if you know the technical skills
[528]
then business skills they can teach you
[531]
so that is the thing here
[532]
they dont expect you to know how to run the business
[536]
but your common sense
[539]
like some regular questions in analytics
[541]
quantitative questions & aptitude related questions
[543]
if these are strong
[544]
then you will definitely learn business after joining the company
[548]
there are some rounds in the interviews like logical round
[549]
technical round & HR round
[551]
so in technical round mostly you are asked about SQL
[554]
so we should know advanced level of SQL
[556]
if we are serious to get a job in that company
[558]
because mostly technical interview means SQL
[562]
mostly I have seen they ask SQL in technical interviews
[565]
so that we covered
[567]
then they will ask basic questions in programming
[570]
they might ask about terminal commands
[573]
but they would be asking just basic surface level questions
[574]
and it won't matter much
[576]
in your selection
[577]
what matters is SQL,
[579]
then they can ask multiple questions of Excel
[582]
which I told you, you should know the advanced concepts
[584]
like macros
[586]
other than that, in logical interviews
[588]
you have that regular aptitude round
[590]
in aptitude round they can ask that suppose
[592]
how many footballs can fit into this room?
[594]
questions like this, or rapid fire questions
[595]
they judge how good is your critical thinking
[599]
the stronger your communication skills will be
[601]
the more edge you will have
[602]
because what is the meaning of a data analytics?
[605]
what is the job of a data analyst
[606]
basically their job is to help others
[608]
to help the managers & other staff
[609]
so how can they help?
[611]
when they will be presenting properly
[612]
when they can communicate properly
[614]
like visual communication
[616]
means how well you make the documentation
[618]
how well you present the data
[620]
that matters
[621]
and how well you are conveying your point
[623]
that matters a lot
[625]
then in the HR round,
[628]
it could be a mix of the two
[630]
sometimes you are asked questions to compare your values with the company's
[635]
if you are a good fit for the company or not
[636]
and generally the salary negotiation is also done in this round
[639]
the better your technical interview went
[642]
the more knowledge you have
[644]
the better your experience
[645]
and so you will get an edge
[647]
and on that basis you can negotiate better in the HR round
[650]
about your offer
[651]
now let's talk about the resume
[653]
how you have to make your resume
[655]
plus this is a very important part
[657]
your resume represents you in multiple companies
[661]
if your resume is not good enough,
[662]
then all these things does not matter
[664]
so please make a good resume
[665]
it is a very crucual part
[667]
so lets see how to make a resume
[669]
so we have to make a resume with the help of JD & keywords
[672]
JD means job description
[673]
so if you apply for multiple companies,
[675]
then they have mentioned what are their requirements
[679]
you should know these skills
[680]
so mostly you should definitely know Excel & SQL
[683]
these two are required in all the companies
[685]
then in visualisation tools, you should know one of these two
[689]
ok
[690]
both are similar
[691]
apart from that, they add programming language
[693]
it depends from company to company
[694]
some company may emphasise more on programming language
[697]
some want more technical skills
[698]
some do not emphasise at all
[700]
so this is flexible
[702]
it is not like you must know all of these skills to become a data analyst
[705]
it is not so,
[706]
every company has different requirements
[707]
then second point comes that
[709]
that you have to modify your resume based on the company's requirements
[713]
whenever you are applying in a company
[715]
if you are serious about going into that company
[717]
then you have to modify your resume accordingly
[720]
you have to add the your skills that
[722]
matches the requirements of the job description
[726]
so that way you have to make your resume
[729]
you can't send one resume to all the companies
[731]
then you have to add your projects in it
[733]
now what projects can we make?
[735]
so basically if you know some python
[738]
then you can gather some data set & make a project
[743]
you can make a recommender system
[745]
you can do machine learning as well
[747]
you might think, machine learning is not required for a data analyst
[751]
so basically the thing is
[752]
that there is cut throat competition
[755]
so if you are not over qualified
[758]
if you are not an over achiever
[759]
then it will be tough for you
[761]
ok
[761]
many people apply in such companies
[764]
there are many applicants
[765]
then how can you set yourself apart
[768]
that matters the most
[769]
so how many papers you have published
[772]
that is important
[773]
where have you done your internships is also considered
[775]
so basically you have to set yourself apart
[778]
you can make multiple projects
[779]
then certifications are also very important
[781]
which certificates do you have
[784]
do add the certifications available on Linkedin
[788]
Linkedin certifications has one more benefit
[790]
when Linkedin shows the candidates to the recruiters
[795]
so they show those candidates higher, who have passed the assesment of linkedin
[799]
ok
[799]
so you should complete the assesments related to python & data analyst on Linkedin
[806]
there are only 10-15 questions that if you answered correctly
[808]
then you will be ranked higher
[810]
there are also free certifications on Google
[813]
you should get those certificates, so that
[814]
your skills will also improve
[816]
and you also have certificates on your resume
[819]
then your work experience matters the most
[822]
but assuming if you are a fresher, you won't have much experience
[826]
which is okay
[827]
but there if you set yourself apart
[830]
then it's very good
[832]
then you have some chance
[833]
what are the ways to set yourself apart?
[835]
so make amazing projects
[837]
add those things that are required by the company
[839]
you should have those key words
[841]
your resume should be ats friendly
[843]
because they have a lot of resumes
[845]
so we have to make an ats friendly resume
[847]
how to make a resume
[849]
I have already made a separate video on that
[851]
there is also a technique of making ats friendly resume
[853]
you can check out that video as well
[854]
now let's talk about jobs & salary
[856]
first let's talk about how & from where you can apply
[859]
later on we will talk about salary
[860]
so if you want to get a job then,
[862]
then we have some websites to apply like shine.com
[864]
where there are jobs for data analyst
[866]
also with zero experience
[868]
so if you dont have experience
[870]
so there are many jobs on this platform so you can apply there
[873]
then we have Linkedin.com
[874]
where we have all type of jobs
[876]
multiple companies posts job opportunities there
[877]
there are also some hacks on Linkedin
[879]
if you want to improve your chances
[882]
so you can do certain things
[884]
like first obviously you will apply for the job
[885]
but apart from that you can
[887]
directly mail your resume to the recruiter
[893]
you should try to get the email id of the recruiter
[896]
also you can ask for referral to the employes already working in the company
[900]
you can give the job id & your resume
[902]
and you can ask them to refer you
[904]
because the employes also have benefit in this
[906]
if the employes successfully refers someone,
[908]
and they are recruited, then they also get some amount of money
[911]
so if your resume is strong, then they will definetly refer you
[914]
if you can request them properly
[917]
next I have written down some companies
[919]
Mc kinsey, Bain, BCG, Delloitte & there are multiple others
[922]
the arrow describes the preference of the candidates for the companies
[926]
so Mc Kinsey is preffered the most
[927]
in terms of salary and the
[929]
level of work they get to do
[931]
and the growth in their career
[933]
so based on that there is the arrow
[934]
there are some companies that I did not mention here like
[936]
Gartner,KPMG, Smart cube, Tiger Analytics, EXL, Accenture
[941]
there are other several companies that
[942]
are hiring data analyst
[944]
and there are multiple package band in the companies
[947]
as you can see, you can get 3L to 12L per anum salary band
[951]
if you are a fresher
[952]
and you can see it is a broad range
[956]
so I have noticed that in this field there is high descrimination regarding salary
[962]
salary depends on how well your resume is,
[967]
your background, your performance in the interview
[970]
and how well you could negotiate
[972]
all this matters a lot
[973]
I have seen like if there are two people from the same team
[976]
one is earning 4L per anum, other one is earning 11L per anum
[979]
both are doing the same work, but
[980]
there is some difference in background, negotiation skills
[983]
there is difference in their skills & how well they proved themselves in the interview
[988]
if you prove yourself in the interview
[991]
in technical as well as logical interviews
[993]
so they give feedback to the HR that we want this candidate
[996]
so you can offer such package to hire them
[998]
ok
[999]
so the more over achiever you are in this field
[1001]
the more easier it will be for you
[1004]
because again, I will repeat there is huge cut throat competition.
[1007]
in this field
[1008]
getting a job as a data analyst for a fresher is not an easy task
[1012]
it is very tough, you have to apply at multiple places
[1015]
daily you have to apply at 20-30 companies
[1018]
and also apply through multiple sources
[1020]
I already told you,
[1021]
there are many other sources like
[1022]
Naukri.com and other multiple websites
[1025]
from where you can apply
[1027]
get referrals from wherever you can
[1029]
so that you can get a job
[1030]
you must know all these skills
[1032]
and if you know some programming & have made some projects on that,
[1036]
then it will be a plus point for you
[1038]
if you have published some papers,
[1040]
that will be a plus point
[1041]
basically you have to make sure that your resume stands out
[1044]
so the better you will be able to do so,
[1046]
the more are your chances of getting selected &
[1049]
and the more salary you can get
[1052]
this was the data analyst road map
[1054]
I will add all the links of the resources in the description
[1057]
I will add multiple links & you can check them out
[1059]
if you have watched until now means you love the video,
[1062]
then definitely like the video
[1063]
also subscribe to the channel
[1065]
see you in the next video
[1067]
there will be more such videos
[1068]
until then, Bye Bye.
Most Recent Videos:
You can go back to the homepage right here: Homepage