Talents and skills of a data analyst
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.
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.