8 Skills to get a data analyst job | Skills to become successful data analyst - YouTube

Hello everyone in this video

We will be discussing top eight skills that you need in order to become successful data analyst

these are the skills that they'll be asking during the

Interview as well as once you become a data analyst if you have these skills

you can really become successful in your career skill number one is

excel

Believe it or not microsoft excel is still widely used in the industry for doing data analysis

And it is perfect for the small data set and if you have knowledge of excel formulas the vba formulas charting

Pivot table different transpose techniques, etc

You will

Have an age compared to your peers skill number two is sql

It is called structure query language now sql you can do in

Mysql microsoft sql server oracle, there are different databases

on which you can run structure query language

To fetch the data to do different operations with that data and as a data analyst you are often involved in a data exploration

Data collection and all those operations. So having sql skills will be

extremely useful

skill number three is

You should know at least one visualization tool such as power bi or tableau

These are the two most popular ones, but there are many out there in the industry. And if you have learnt at least one tool

You can easily learn some other tools

So if you are asking for me for my choice, I would go for other either power bi or tableau

But once you have learned one tool, you can learn other tools easily

these tools allow you to connect with the data sources and you can

Pull that data into this visualization

Tools and you can build a lot of useful dashboards. I have done one sales insight project using a power bi and

If you look at that project series you will

Figure out how how useful that tool is in terms of building

Interactive dashboards. So once you build the dashboard, it will look more like an application

you can also uh

Export that dashboard as a mobile app. So when someone is looking at the mobile app, they can

interact

and they can

Use various ui controls to fetch the data to fetch different reports and different

Visualizations dashboards. So visualization till tool nowadays is extremely

important

Number four is communication and presentation skills

When you are becoming a data analyst you are often talking with your business manager your engineering groups and different stakeholders

and your job is to communicate the requirements or let's say gather the requirements in

effective way and offer creative solutions

you also need presentation skills because data as a data analyst you are telling your data story when you are building a

Dashboard, let's say for sales insights. You are building a story around

Sales are declining less a particular region, or they're increasing in

Other region and what is the reason behind this?

uh decline or behind the growth so

telling that data story is important and

Presentation skills is something uh that you need to master i'm gonna link some of video

For how to master the presentation skills. It's called death by presentation. So if you are preparing any

presentation make sure you watch that video and

The idea is you should not

Get your audience too much bored with your presentation and you should have an effective

And engaging presentation. So that's very important skill number five is domain knowledge

Often if you're looking at our data analyst job position

They will say financial data analyst or retail data analyst

what it means is if you have a degree in finance or let's say if you have

done masters

Or specialization in retail that domain knowledge is going to be extremely useful many times people ask me that

I have to have a computer science degree in

In order to become data analyst

No

You do not need computer science degree. In fact

If you have specialization, let's say if you're done bachelor of commerce, and or or if you have a degree in

finance

Or let's say in retail or some industry

Then that domain knowledge will be extremely useful because as a data analyst you are solving problems in particular domain

And having that no

Knowledge helps you do data analysis in an effective way

the next skill which is

Not very much required. There are many companies which do not ask for this skill is

Programming. So nowadays python and r are two very popular programming languages

I personally prefer python if you're just starting out just go with python

Having programming knowledge will give you an edge over the computation. So if i'm hiring a data analyst I have two resumes

exist same skills

But let's say if one of the resumes have python, I would just go with that person or any other programming knowledge

Because programming knowledge is not a must for a data analyst but it is a plus

So if you have that it will definitely help you

I have a nice tutorial playlist on python even a fifth grade student can learn from this tutorial playlist. So I have linked

Again, that tutorial playlist in the video description below. You can check it out. You need to watch just first 15 or 16 videos and

Python programming is so easy. And it's so convenient to learn that anyone can learn it. So if you have time, especially during lockdown

Please learn python because it will be very very helpful. But as I said before

Some of the companies do not ask for it

So even if you don't have programming knowledge as a data analyst you might end up doing just okay

the next skill is

mathematics and statistics

So when you're doing data analysis you are let's say looking at your data distribution

You need to know what is normal distribution standard deviation to standard deviation how to remove outliers. So you need to have

Basic math and statistics knowledge. You should know uh

basics about inferential statistics and descriptive statistics

You don't need to be super genius in math and statistics

Okay, so just have basic knowledge

And as you work on solving real life problems, you should try to enhance your knowledge in mathematics and statistics

The last skill is problem solving now. This is a common sense approach

It's a general skill where you need to be street smart and you need to be offering

Different solution for a given problem. So there is no like one silver bullet that I can tell you or no?

No, one magic trick that I can tell you to

Improve your problem solving skill, but it's a general smartness that you need to have

So I hope you like this video. All these eight skills are super important if you want to

Get a data analyst job or if you want to become successful in your data analyst career

I have another video where I have shown

How you can learn data analysis skills for free where I have linked all the online resources

and all of these resources are for free, so if you have enough motivation

One computer and internet you can learn all these skills for free sitting at your home

in this lockdown, so if you are thinking of

Uh changing your career to data analysis. It's definitely a good idea

There are so many jobs being open, uh for data analyst and I see many people

Transitioning from let's say mechanical engineering or bcom or different

Backgrounds to a data analyst career if that is something that excites you you should definitely consider this as an option

I have a couple of videos on my channel where?

A couple of mechanical engineers and become graduates

Made a transition transition and they became a successful data analyst right now. They're working for some big companies

So go watch those videos as well if you want to get some tips. I hope you like this. Thank you very much. Bye