Learn more about the key analytics skills and tools needed to become a data analyst. I've written an extensive guide to building the right skills and finding a data analyst job that's a great fit for you: bit.ly/TCFDataAnalyst Ready to build your perfect analytics resume? Find out more here: bit.ly/TCFPerfectResume
Top 5 Skills for Data Analyst: 1 - Math/Statistics (descriptive statistics, regression analysis, etc) 2 - Programming (SQL, Python, R, SAS) 3 - Problem Solving (90% of analytics is knowing the questions to ask) 4 - Data Visualization (Excel, Tableau, PowerBI) 5 - Communication (talk with nontechnical people, good for moving up to managerial roles) Bonus Skill: 6 - Know the industry (you want to standout in your interview/position)!
Which area do you need to focus on to continue to grow in your career? Leave it in the comments below. I’m really curious which of these areas stand out to you.
Great! I have an Econ bs with a minor in math, and have been looking into breaking into the field. This is great, thank you so much. I feel very competent in Excel, but have been teaching myself python and SQL as well. I just like learning, which is probably why I like stats/analysis in the first place. This has been very helpful, thank you. It gives me hope that someone will want to take a chance on me.
I'm glad it helped! I have a math BS with a minor in econ. Your background would lend itself especially well towards positions that have a financial component such as warranty, insurance, or purchasing.
The Career Force thank you! Sounds like a great place to begin. I don’t think I’ll really start feeling confident in my self taught skills like python/SQL until I have an opportunity to really use them in the work force, and not just exercises in a course. This is my biggest hurdle when it comes to interviewing I think. Thank you again for all your great videos.
I am on the way of switching from Business Analyst to Business Analyst and this video really inspired me. I can’t agree more when you mentioned about the importance of asking effective questions and communication skills.
Thank you for such a informative and concise video! I'm trying to build strong foundation before jumping on to this career path and so far your videos are my favorite to watch on the topic. Looking forward to watching more! 😊😊
"Problem Solving" -> definitly the most important skill of all ! Nothings beat a genius co-worker that tells you in less than 5 seconds what you were searching for hours. IMHO, this Problem Solving skill is very rare to have ! By the way, I'm wondering if it is something that only very talented people has :/
Problem solving does seem surprisingly rare and it's a huge advantage if it comes naturally. The genius coworker is great (after you have a few minutes of being annoyed how quickly they solved your problem when it took you hours 🤦🏽)
Thank you so much for this video. I am trying to transition from Digital Media to Data Analytics career path, while still staying within the industry. I really trying to break down my transition into steps and find the right platform to learn from. I think I have great communication and problem solving, and feel confident in learning software. I learn SQL and Python in codeacademy and really like the hands-on approach. is there a platform or the website you will recommend to learn statistics and math for data analytics with a similar approach or just a great website to learn from? And thank you again. Great content!
I need to focus on widening my programming range. I am proficient in SQL and Python but feel like I really need to add SAS and R to be truly competitive in the Data Analysis field. What do you think Jen? Should I learn these as a preemptive measure? would love to hear your feedback! Thanks for these videos I've found them all insightful and helpful please keep em coming=]
Glad you're finding them useful! Learning new skills is always a plus. What kind of career goals do you have? If you'd like to eventually work for a consulting company, in medical areas, or at many of the large companies, then SAS is something you should definitely learn. More than just learning them, try to apply those skills (regardless of which language you learn it even with the SQL and Python you already know) to some sort of practical problem. This will really help you when you get into interviews. When I'm interviewing someone and they can't tell me what things they've done with a programming language, I'm always a bit hesitant whether they really know how to apply it.
I just finished my mechanical engineering in june 2020. I want to pursue my career as a data scientist but since I know I can't just jump in into this field, so I have decided to opt for data analytics and then pave my way into data scientist. Can u plz guide me how is springboard since I have decided to opt data analytics from springboard ?
Can I ask one thing? How did you decide to go for the spring board Data Analytics curricullum? I myself am on the verge deciding between 'UPGRAD' and 'GreyMatter'. I want to know what to look for when deciding where to start.
This video should help: ruclips.net/video/sdW3LsW2kNU/видео.html Neither role requires a masters degree. In cases where someone does have a masters, it would be typical for a business analyst to have an MBA and a data analyst to have a math/statistics/analytics/computer science degree.
Thank you for the incisive response. I prefer less programming skills . Just SQL, tableau and excel. I have a background in accounting? What do you suggest.
Look for data reporting analyst jobs or data analyst jobs that don't mention programming. There will be plenty of them, but they're a little more difficult to find because they often share the "data analyst" title. With a background in account, you may also find business analyst or financial analyst jobs that fit very well with your skills. Many of these won't require programming skills.
Is it possible to learn on the job while getting paid as a Data Analyst? I currently don't have any experience using Tableau, Python , SQL, Power BI, etc but would like to get foot in the door and get paid while learning.
Thanks for the tips. I am an event marketing professional looking to change careers into data analytics. What are your opinions on online data analytics bootcamps offered by General Assembly, CareerFoundry, and Springboard? Are they worth paying almost $6000US?
Thank you for the video. I've been a developer primarily in C++ for 20 years now and have BSc and MSc in CS. Since I have development experience, do you think MSc in Data Science or Data Analytics will be valuable by employers ? Will they see such a programme as enhancement to my development experience and as a good start for the DS field ? Or will they say that it's too late at my age and therefore compare me to much younger graduates in the DS field in which case they will expect me to take a pay cut ?
Yes, you do need to be good at math. You're right that computers can do a lot of the number crunching itself. The critical thing is to know what to ask the computer to do though. And knowing math also helps give a check on the results that you get and whether you gave good inputs and got a reasonable output. That's where being very knowledgeable at math is extremely important.
There's some writing, but I wouldn't say it's a massive amount. Most companies either are heavy on PowerPoint slides or favor reports. Either way, written communications skills are certainly important but the overall volume of writing isn't much different than most other office jobs.
Hi! I am currently studying Actuarial Science and planning to get a masters degree related to Data Science. Would you say that these are qualifications that employers take into consideration? Thanks! (ps: sorry for the delay, i've been searching info about data analytics lately and the google algorithm is clearly working)
Great question! It depends on the type of data analyst job that you want. Some will not require programming, but many jobs do require some programming skill (like SAS). The jobs that don't require programming skills may be called "reporting analyst" or "data reporting analyst". This video will help explain things more: ruclips.net/video/W1DFw-fmO0A/видео.html
Hi Jen, Thanks for the detail information, I want to know how do I learn or get admission for these courses such as, Big data scientist, python etc. lease do let me know. Thanks
Hi - I talk about how to learn skills in this video: ruclips.net/video/nDFNIvj9MCI/видео.html I cover it in a much more detail in my book: bit.ly/TCFDataAnalyst
There was a time when SAS appeared invincible but now it's suffering the same fate like Dinasour. I mean it's enormous size and costs are gradually declining it's market share. Even IBM's Cognos no longer makes its presence heard. Whereas R and python are racing at much faster velocity and command 70% market share. With this speed one can easily anticipate what's in store for them.
Definitely not required! While there are some data scientists who work with machine learning, most data analyst and data scientist roles don't require it.
Nope, but seems like it is the future for big data world when quite a few of the CIT, CTO, and CIO that I know introduced machine learning into the company
Hello I m mathematics teacher since 2009 with qualification like bachelor of mathematics physics and masters of physics I want to change carreer at age of 35. Is this data analst is good according to my background. What should be first step
It really depends on the industry. Mostly it's all about looking for ways to improve company's KPIs, forecasting, hypothesis testing, market analysis. And also there's a lot of reporting. That's why you have to learn programming to automate it.
Learn more about the key analytics skills and tools needed to become a data analyst. I've written an extensive guide to building the right skills and finding a data analyst job that's a great fit for you: bit.ly/TCFDataAnalyst
Ready to build your perfect analytics resume? Find out more here: bit.ly/TCFPerfectResume
You are very pretty :)
a tip: you can watch series on Kaldrostream. Me and my gf have been using them for watching all kinds of movies recently.
@Tatum Deshawn Yea, I have been watching on kaldrostream for years myself :D
Top 5 Skills for Data Analyst:
1 - Math/Statistics (descriptive statistics, regression analysis, etc)
2 - Programming (SQL, Python, R, SAS)
3 - Problem Solving (90% of analytics is knowing the questions to ask)
4 - Data Visualization (Excel, Tableau, PowerBI)
5 - Communication (talk with nontechnical people, good for moving up to managerial roles)
Bonus Skill:
6 - Know the industry (you want to standout in your interview/position)!
@Nelson If you watched the video, she actually says that if you have the ability to do it in Python then you can probably just do it that way.
Thank You. Very thoughtful of you.
Sure
#6 is a game changer you are right
Thats what you did, you analyzed it and then came to a beautiful solution that everybody understand.
I loved it a lot when you talked about your mom with a beaming smile. I love my mom so much so once 'mom' is mentioned I smile.
Which area do you need to focus on to continue to grow in your career? Leave it in the comments below. I’m really curious which of these areas stand out to you.
Great! I have an Econ bs with a minor in math, and have been looking into breaking into the field. This is great, thank you so much. I feel very competent in Excel, but have been teaching myself python and SQL as well. I just like learning, which is probably why I like stats/analysis in the first place. This has been very helpful, thank you. It gives me hope that someone will want to take a chance on me.
I'm glad it helped! I have a math BS with a minor in econ. Your background would lend itself especially well towards positions that have a financial component such as warranty, insurance, or purchasing.
The Career Force thank you! Sounds like a great place to begin. I don’t think I’ll really start feeling confident in my self taught skills like python/SQL until I have an opportunity to really use them in the work force, and not just exercises in a course. This is my biggest hurdle when it comes to interviewing I think. Thank you again for all your great videos.
I am on the way of switching from Business Analyst to Business Analyst and this video really inspired me. I can’t agree more when you mentioned about the importance of asking effective questions and communication skills.
Thank you for such a informative and concise video! I'm trying to build strong foundation before jumping on to this career path and so far your videos are my favorite to watch on the topic. Looking forward to watching more! 😊😊
Thanks Jane for making data analyst skills are easy to understand .
I'll focus on storytelling skill, that's so much helpful for me by giving information/presentation.
Communicating, visualization, stats, python.
"Problem Solving" -> definitly the most important skill of all ! Nothings beat a genius co-worker that tells you in less than 5 seconds what you were searching for hours. IMHO, this Problem Solving skill is very rare to have ! By the way, I'm wondering if it is something that only very talented people has :/
Problem solving does seem surprisingly rare and it's a huge advantage if it comes naturally. The genius coworker is great (after you have a few minutes of being annoyed how quickly they solved your problem when it took you hours 🤦🏽)
Jane, You such an amazing trainer. You demystified the skills with utmost dexterity. Please, how do I connect with you on Linkedin?
Love your smile, and to the point presentation.
Great video. Thanks!
Thank you for the details and you’ve been really helpful!
Thank you so much for this video. I am trying to transition from Digital Media to Data Analytics career path, while still staying within the industry. I really trying to break down my transition into steps and find the right platform to learn from. I think I have great communication and problem solving, and feel confident in learning software. I learn SQL and Python in codeacademy and really like the hands-on approach. is there a platform or the website you will recommend to learn statistics and math for data analytics with a similar approach or just a great website to learn from?
And thank you again. Great content!
This video is Great! Thank you!
Very informative. Thank you!
A very interesting explanation,I learn a lot.Thanks
I need to focus on widening my programming range. I am proficient in SQL and Python but feel like I really need to add SAS and R to be truly competitive in the Data Analysis field. What do you think Jen? Should I learn these as a preemptive measure? would love to hear your feedback! Thanks for these videos I've found them all insightful and helpful please keep em coming=]
Glad you're finding them useful!
Learning new skills is always a plus. What kind of career goals do you have? If you'd like to eventually work for a consulting company, in medical areas, or at many of the large companies, then SAS is something you should definitely learn. More than just learning them, try to apply those skills (regardless of which language you learn it even with the SQL and Python you already know) to some sort of practical problem. This will really help you when you get into interviews. When I'm interviewing someone and they can't tell me what things they've done with a programming language, I'm always a bit hesitant whether they really know how to apply it.
I'm good in math and statistics, excel and communication. I still need to learn more in Excel.and where can I learn programming
I just finished my mechanical engineering in june 2020. I want to pursue my career as a data scientist but since I know I can't just jump in into this field, so I have decided to opt for data analytics and then pave my way into data scientist. Can u plz guide me how is springboard since I have decided to opt data analytics from springboard ?
Can I ask one thing? How did you decide to go for the spring board Data Analytics curricullum? I myself am on the verge deciding between 'UPGRAD' and 'GreyMatter'. I want to know what to look for when deciding where to start.
Great content.
Good info, thanks
Thanks
Could you help me understand the difference between a Data Analyst and a Business Analyst when it comes to a masters degree?
This video should help: ruclips.net/video/sdW3LsW2kNU/видео.html
Neither role requires a masters degree. In cases where someone does have a masters, it would be typical for a business analyst to have an MBA and a data analyst to have a math/statistics/analytics/computer science degree.
I need to focus on communication but I’m lost . What are the steps do you think I need to take?
I'll vouch to GOD to put you in Heaven. Thank you for this video. You are amazing..
Thank you for the incisive response. I prefer less programming skills . Just SQL, tableau and excel. I have a background in accounting? What do you suggest.
Look for data reporting analyst jobs or data analyst jobs that don't mention programming. There will be plenty of them, but they're a little more difficult to find because they often share the "data analyst" title. With a background in account, you may also find business analyst or financial analyst jobs that fit very well with your skills. Many of these won't require programming skills.
Great video! Grettings from Argentina!!
Is it possible to learn on the job while getting paid as a Data Analyst? I currently don't have any experience using Tableau, Python , SQL, Power BI, etc but would like to get foot in the door and get paid while learning.
Thanks for the tips.
I am an event marketing professional looking to change careers into data analytics.
What are your opinions on online data analytics bootcamps offered by General Assembly, CareerFoundry, and Springboard?
Are they worth paying almost $6000US?
Thank you for the video.
I've been a developer primarily in C++ for 20 years now and have BSc and MSc in CS.
Since I have development experience, do you think MSc in Data Science or Data Analytics will be valuable by employers ? Will they see such a programme as enhancement to my development experience and as a good start for the DS field ?
Or will they say
that it's too late at my age and therefore compare me to much younger graduates in the DS field in which case they will expect me to take a pay cut ?
how will be career for a data analyst 10 years down the line?
Is a degree in information systems a good major to land you a job in data analyst?
Do you think you have to be very good at math for this career? Computers do most of the work these days.
Yes, you do need to be good at math. You're right that computers can do a lot of the number crunching itself. The critical thing is to know what to ask the computer to do though. And knowing math also helps give a check on the results that you get and whether you gave good inputs and got a reasonable output. That's where being very knowledgeable at math is extremely important.
@@TheCareerForce May i know what are the imp topic of Maths in Data Analyst
@@PRODRANE +1
Thanks♥️
In business Analytics, do you do a lot of writing?
There's some writing, but I wouldn't say it's a massive amount. Most companies either are heavy on PowerPoint slides or favor reports. Either way, written communications skills are certainly important but the overall volume of writing isn't much different than most other office jobs.
I want to be a data analyst
@thecareerforce, Why does healthcare industry uses SAS?
That's a crazy heavy duty sofa!
This is really good to know that medical orgs use R ....
How is SQL?
Hi! I am currently studying Actuarial Science and planning to get a masters degree related to Data Science. Would you say that these are qualifications that employers take into consideration? Thanks! (ps: sorry for the delay, i've been searching info about data analytics lately and the google algorithm is clearly working)
I love when you smile ☺ so cute!
Can i be a data analyst if i suck at math?
I am good with maths! Can I just add tableau and SQL to be proficient as data analytics. While SAS in addition?
Great question! It depends on the type of data analyst job that you want. Some will not require programming, but many jobs do require some programming skill (like SAS). The jobs that don't require programming skills may be called "reporting analyst" or "data reporting analyst". This video will help explain things more: ruclips.net/video/W1DFw-fmO0A/видео.html
What can you say about master in health informatics. Guess it's related to data and what about it's demand
It is good but they don't make a ton of money like that. A data analyst or certain tech skills can go to other industries.
Hi Jen, Thanks for the detail information, I want to know how do I learn or get admission for these courses such as, Big data scientist, python etc. lease do let me know. Thanks
Hi - I talk about how to learn skills in this video: ruclips.net/video/nDFNIvj9MCI/видео.html I cover it in a much more detail in my book: bit.ly/TCFDataAnalyst
Communication
There was a time when SAS appeared invincible but now it's suffering the same fate like Dinasour. I mean it's enormous size and costs are gradually declining it's market share. Even IBM's Cognos no longer makes its presence heard.
Whereas R and python are racing at much faster velocity and command 70% market share. With this speed one can easily anticipate what's in store for them.
I can think of 6!! 😂😂😂😂😂😂
Is a machine learning necessary for a data analyst?
Definitely not required! While there are some data scientists who work with machine learning, most data analyst and data scientist roles don't require it.
Nope, but seems like it is the future for big data world when quite a few of the CIT, CTO, and CIO that I know introduced machine learning into the company
Number 4, for sure lol
Hello
I m mathematics teacher since 2009 with qualification like bachelor of mathematics physics and masters of physics
I want to change carreer at age of 35.
Is this data analst is good according to my background.
What should be first step
I left a note on your other comment as well. Start with improving your computer skills since you'll need those to get an analytics job.
Moksh Arora p
maam i ma freshly economics hons(masters).. if i only learning python will it be enough for me to get a good
job..
R and Python is necessary for long term career stability and advantage
I need to learn programming 😂
What are the most common problem do the analys solve?
It really depends on the industry. Mostly it's all about looking for ways to improve company's KPIs, forecasting, hypothesis testing, market analysis. And also there's a lot of reporting. That's why you have to learn programming to automate it.
@@MadSKWIREL Thanks Very Much Boris. Peace frm Malaysia.
But if I take a really simple topic and make it complicated. Is that a skill. Lol
Such a lovely lady you are.
Communication