You need to be good at statistics math machine learning etc
If you want to become data scientist
But if you feel that you are not very expert in these areas. Then data analyst is a career that you can pursue if
if Working with data really excites you.
in this video, I'm going to show you how you can acquire data analyst skills using some online free resources
Acquiring these skills will help you become data analyst
Data analyst and data scientists are two lucrative positions available in the field of data science nowadays
The goal of both of these roles is to draw insights from data
The only difference between data analyst and data scientist field is that
data scientist has all the skills that data analyst has
plus he has some additional skills such as
Statistics the scientists are usually strong in statistics math
Machine learning deep learning etcetera so that they can build machine learning model. They can do predictive analysis
This is something that data analysts usually don't do but the good thing is becoming a data analyst
can create a path for you to become a data scientist because once you are data analyst
You know how to use visualization tools, you know how to deal with data
You know how to clean data and then you can transition to data
Scientist position by acquiring those additional skills here is a quick summary on the skills
You need to have as a data analyst the first most important skill is of course Excel. You also need to know SQL
knowing one of the programming languages out of SAS Python and R is gonna be
Extremely beneficial there was a time where data analyst job didn't require any programming knowledge, but nowadays
If you have programming knowledge is gonna be super useful
Knowing one of the visualization and BI tools such as tableau clay core power bi is also very very useful
the most important skill is
Communication and storytelling because as a data analyst you are
Dealing with data and drawing the insights and passing this insights to your business counterparts in terms of storytelling
So communication scale is extreme be important now we will go over each of these skills one by one
First one is Excel here. You need to know all the six topics
in order to acquire Excel skills
We have this great EDX course from Microsoft
if you have not used EDX before all you need to do is go to this website create a log in and
You can access this course for free. You need to pay money only if you want to get a certificate you see add a
certificate for $99 but that that money you need to pay only if you get want to get a certificate or graded assignment otherwise
The videos and the lab assignments are free. So it's very interactive course, you have all the lab and everything
So you will learn a lot another great resource for Excel is this website called chandoo.org
Which has a lot of tutorials forums and lots of good information
Or which will help you become expert in excel. The second most important skill is
SQL as a data analyst you will be running SQL queries a lot in SQL
You need to know the basics of relational database how to query in a plate data. Of course select where set a Clause
joins, etc for learning SQL
you can use this khanacademy course it has lot of good video content as well as
exercises
another great resources is
This kudvenkat YouTube tutorial playlist
You can go up to 12 tutorials because the list is pretty long
but just go till 12 and
Then after based on your interests
You can cover more but these twelve tutorials will cover the basics that will help you work on
Any data analysis type of project
Now I'm going to provide the links of all these resources in the video description below
So don't forget to check that out
Then comes programming language knowing either Python, R or SAS is going to be extremely beneficial
big companies still use SAS
although SAS is a commercial software which cost lots of money or the big companies are using it and
nowadays
If you look at India many of the job posting for data analyst requires knowledge in SAS
Now SAS University Edition is free
To download from their website so you can download and play with it
If you are confused between what to pick up whether R or Python
I would definitely go with Python if you decide to go with Python in Python, you need to learn only these topics
Ok, you can of course learn advanced topics
but if you are just starting out then
Go through all this topics and that will enable you to work on any data analysis type of project for learning Python
I have a YouTube tutorial list you can go up til 16 tutorials that will give you a very good
understanding of
Python I have designed this tutorial in a way that even a high school student can learn it
You know
I have used a very simple language so you should be able to understand Python really well by following these tutorials.
For SAS There is this tutorial from great online training. It is 9 hour long
I know it's too long, but you can go and cover the topics that you are interested in
for R I have this EDX course, there are two courses in addicts that I recommend for our
one is by Howard University
R basics and
Let's look at the content of this course so here
You can see this is the content it is a short course
Another course is from Microsoft
These courses are free, by the way
all you need to do is create an account and you will get an access of discourses video and exercises
then comes visualization in BI tools
Tableau is an industry standard, but then there are
Organizations using power bi and Qike as well if you want to learn tableau
For that we have this
tutorial playlist by BharatiDWConsultancy
which you can follow
Another playlist we have is by abhishek aggarwal
This is also a very good
playlist which will help you clear the understanding of how tableau works and you can create different reports and if
visualization with the help of these tutorials at this point
I want to take a moment to thank you
sumit Kumar Jain who is a senior data analyst working in Excel service in India is a friend of mine and also
Subscriber of this channel, he helped with some of these online resources, which he himself has gone through
so thank you so much another soft skill you need to have as a data analyst is a
storytelling and communication skill to acquire these skills we have
EDX course by Microsoft which will tell you how we can use
analytic storytelling for an impact
this course will go over different use cases and some real-life business scenarios and it will train you on how you can be an
effective communicator and how you can present your story in a better way because if you have just
technical skills and if you create some data insights if you are unable to pass that on to your business stakeholders
They will not buy into your idea and they will not make the business
Decision that you want them to make so then there will be no point
So having this communication skill is equally important now here are some optional skills. That will help
You become even a more stronger in the field of data analysis so
Data Cleaning and exploration using numpy and pandas is important
you can use these python libraries to explore your data to clean it and
To prepare it for further analysis in pandas. You can go over these five topics for pandas
I have a tutorial playlist in this you need to go till 10 tutorial and that will give you a good understanding
Of how pond has work pandas will help you basically clean your data
so your data is very messy in real life and your job as a data analyst could be to clean this data and
Prepare it for the analysis
Once it is prepared for the analysis doing then an analysis might be easier
Most of the time the data analyst and data scientist spend is in data cleaning pandas will help you with that
while you are working on all these
Tools and languages you need to use code editor or IDE for that?
I usually use Jupiter not book all the time
Then one of these tools such as Visual Studio code or Python
You can use Matt plot or seaborn for visualization as well
These are Python packages in that you need to learn all this topics. Okay for matplotlib
I have a tutorial playlist. It's only seven tutorials so you can just go over all of that now
Let's look at some of the job posting to see what skills they are asking for we have this position open in Amazon
Bangalore office for a data analysis where they are asking for a degree in computer science or engineering
This is of course an experienced role so they have two plus experience requirement
They want you to be expert in Microsoft Office see SQL. You will find everywhere. Ok,
and advanced SQL
R or Python now Amazon is a Tier one company. So the requirements will be little bit higher or little bit stronger
there's another position from
Flipkart here. Also you can see they are asking for tableau power bi etc
Excel SAS they don't have a programming requirement here. But if you have it of course is gonna be very very useful
There is this third position from Trell where SQL and Excel is something you will see everywhere. They are asking about
for basics and statistics
so statistics is also something which I kind of missed but you need to have basic understanding of statistics and
For that also. We have a course from Khan Academy. So if you look at Khan Academy
Statistics course this course. This course is very very good. It's it is for an absolute beginner
So as a data analyst get some understanding on statistics as well
If you have any question related to pursuing a career as a data analyst
Please post in the comment below. I try to read as many comments as possible and try to answer them. So any career
question that you have please post
also if you have
Query
Regarding the difference between data analyst data scientist and data engineer. Then I have a separate video. I'm going to link that video
So that will clarify you the difference between these three roles
Thank you