Can you give me any advice on how to get into this field? I have an MBA and my most recent job was being a program administrator in a university. I'm taking some courses on UDemy to learn more about Cognos and I have a bit of coding experience. I'm going to learn Python soon for analytics. on Udemy. Any suggestions would be great.
@@dec23 Sure... you can start with some statistics, which I'm sure you know about. There are other mathematical concepts you need to know how to apply, such as regression analysis, interpolation, extrapolation... etc. Those can come in handy when dealing with quantitative data. Dealing with qualitative data is different, it can be a lot simpler when using categorized data, but when the data you need is imbedded in a free text, or open questions, it can be more complicated. In Python, Pandas, Numpy and Matplotlib are the standard libraries for data analysis. You can also use geopandas if you like to work with geographic data. The hardest part of the job is explaining what you do to some managers who have absolutely no idea what data analysis is or its basics.
One thing people fail to tell aspiring Data Analysts is that you might not even use the tools as much as you expect. Take my job for example. We primarily use SQL, Tableau and Excel. But the SQL codes we regularly use are already documented. All you need is the SQL knowledge to be able to tweek the already existing code. And with Tableau guess what? The tables have already been created by a guy on the DBA team so all i do is go to Data Tab - Extract - Refresh and then just convert the table to Excel sheet and submit. I don't create anything in tableau. I just need a working knowledge to update and print tables. Some jobs might be different from mine though. What i though I'd be doing is waaaaayyyyyy different from what i am doing. I was expecting to get raw data, clean it (with any tool i want) and visualize it in Tableau. Or use SSRS to create reports. But i do none of that. But on the flip side it's still essential to know the tools through and through because you never know when a shake up will occur that will require you to build the tableau reports/tables, SSRS reports/write you SQL codes from the ground up.
Thank you for all the information regarding data analysts. I'm starting a training program after Thanksgiving. I'm really looking forward to getting into this field as I can use my mind rather than my body like I have as a construction worker. This coronavirus has changed the whole occupation landscape and it's time for me to reinvent myself. Also if you did a visual representation of what a data analyst does that would be immensely helpful as a template as one can see what the actual workday looks like visually
I really appreciate this!! I got considered for a large acquisition company and I'm freaking out because they manage so many assets. I don't want to mess up!
I sent my curriculum vitae in a company and I'm going to apply as data analyst, this vid helps a lot and gave me an idea bc honestly I dont have any idea what the data analyst job is
as a data analyst, I think the hardest part is knowing the problem that you want to solve and how to solve it with data. Because sometimes, the business person doesn't know the problem, and then you'll be asked to search in the data to find those problems.
That's definitely a challenging part! And one that many people aren't really taught how to do. It can really seperate ok analysts from really good analysts.
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
Thank you so much for this video. I've found it extremely helpful and informative. Watching this has made me realize I definitely want to pursue a career as a data analyst.
Analytics is a BLAST to work in! Learn more about building the right skills and finding a data analyst job that's a great fit for you: bit.ly/TCFDataAnalyst If you're applying for analytics jobs check out my course on building the perfect analytics resume: bit.ly/TCFPerfectResume
I am working as a data analyst for the past 4 years. I love the job since it's not monotonous in the long run and provides new challenges that can't be solved using established rules . It needs lot of patience , curiosity and hard work. The journey is somewhat similar to doing a PhD
I love the variety as well! There's so much learning that takes place and much to learn on the job regardless of education level. The practical implementation takes most people time to adjust to - I've seen PhDs that struggled and people with bachelors / no degree that thrived.
@@TheCareerForce definitely true .. I have worked with people have doctorate who are really smart but some of them aren't as good in the job since they lack few qualities .. nonetheless I need to also add that the job can be quite frustrating sometimes when we put in so much effort but aren't able to find the issue or if the issue was due to minor error
Naveen Bali hi naveen, could you please let me know skills or technologies required for data analyst, i know python , excel , what more I need , I am confused please help me
i have a B.A. in Philosophy , and i used to be a really big math person, just not so much anymore. i went into philosophy because logic and extracting the meaning of things came naturally to me. this video has proven really helpful in making my decision. thank you!
Thank you so much for the awsome video! I really want to become an Analyst and the content of this video really help me understand that most of the job is just being able to solve problems. And more then this i finally understood that math is not the main thing but also important. I though that high lvl of math is really important and it a reliefe to hear that it not have to do with the most of the analysis. Thank you so much for this content !
Hi, this video helped me a lot. My part of data analysis is more towards the data and less towards math. Please help me to understand the data and improve my problem understandings skill
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
I feel like I have just been gathering and cleaning data but never getting a chance to really analyze it because it is eating up so much of my time. I am doing more of sales support than anything else.
I think so it's the ability to use statistics to actually solve business problems. The fact that you can quantify an ambiguous process and gain insight is what attracts me. Or I assume. Still researching about this field tbh. Great video!
I agree! I've always enjoyed solving practical problems and analytical skills help create a structure to make it possible. Are you thinking of moving into a data analytics career?
@@TheCareerForce I am actually researching about careers in Data analysis, project management and supply chain management. Though from a background in Mech. Eng, math hasn't been a "natural" proficiency for me. But analytics is a field that looks interesting to me. Some of the stuff I'm doing right now: 1) Prepare masters applications for industrial engineering, with a specialization in optimization/operations research. 2) Develop skills in python, VBA and SQL for a possible internship. 3) Learn more about the field (that's how I found your channel)
The Career Force what skills do I need to become a data analyst? I will be graduating from university with a BS in computer science. Thank you for your help!
@carysa227 Your BS in Computer Science is a great foundation for the programming, problem solving, and data visualization that most roles require! You'll also need math (statistics) skills and communication skills. Here are 2 videos that explain in more detail: How to become a data analyst (ruclips.net/video/W1DFw-fmO0A/видео.html) Top 5 Data Analyst Skills (ruclips.net/video/Dxy7dGhy62s/видео.html).
Are there data jobs that involve more of the math/logic side? I like the idea of acquiring and cleaning the data, and then quantifying it to make informative visuals or summations. I feel like if all the parts of the data analyst role, that these are the most interesting to me, but unsure if that translates to a different role I should consider.
I'm not very good with Math. But as far as I can tell about SQL language and some ETL stuff, it usually goes around : SUM/AVG/COUNT.. lol. Don't worry too much about data cleaning, there are very good Extract/Transform/Load program nowadays, I like PENTAHO, it's free and very easy to use (regexp helps a lot). The hard part is to understand your Data and what you can tell (stories) with them. You didn't mention in the video that you have to master DBA knowledge : a star schema is useful ... and you will have to build one from scratch.
You're definitely right that understanding your data is critical. Data cleaning tools are helpful and knowing the data itself will make you much better at data cleaning. It's interesting that you mention DBA knowledge. My first reaction was to disagree (I think of this more for data scientist than data analyst), but then I realized I approach the same thing from a math instead of a programming perspective. The DBA knowledge that's important for analysts could also be referenced as set theory knowledge - how different sets of data connect and interact with each other. I'm glad you mentioned it!
@@TheCareerForce I though data analyst and data scientist was the same job ... I think I understand a little bit the difference between the two : analyst is more like "what you can do with data already in place" compare to data scientist that covers the ETL part. Am I right ?
I'd like to model some productivity and revenue numbers to actually see the Pereto Principle that is in effect, and from that find the optimum revenue and productivity. I also think it's an IT issue to move from manual productivity tracking to automated productivity tracking. I've seen administrative tasks increase to points where less field work is able to be performed because the field staff are not able to use the manual tracking applications such as where to look for information on a project, filling in their timesheet with work, travel time, mileage, and report prep, and finally their service orders with attached reports. The human-err factor is multiplied per interaction per iteration along with skill gap issues. Most of the time, admin staff are correcting errors in the tracking, but staff continue to make the same errors. I'd like to learn how to prepare data that can be presented to management to be able to address these kinds of issues and more.
You raise many good points here. There's a lot of benefit to tracking and adding data to many aspects of business. ("What gets measured gets managed" is a quote I've heard in many businesses). What many people don't acknowledge is that this can often lead to a temporary decrease in performance because there's so much time spent manually tracking activities. That's fine when management recognizes this as a step on the growth curve, but it's often treated as "do this on top of what you're already doing". This is a great place for apps and other intelligent technology to come in - for people that are traveling to job site - apps that automatically record their time / mileage based on geofencing, etc. Sampling may be a good approach here so that it gives the data needed to take action without overburdening everyone to collect it constantly. In parallel, work on identifying / creating the IT tools needed to automate these activities to provide a longer term solution.
Very concise description. May I please know how much finance knowledge does it involve? I just completed my CPA, we have a micro-credential course for data analytics open here, not sure whether I need to study it if it has too much finance involved (I'm not good at Finance). Thank you.
hi, i love writing algorithms and finding solutions to problems, I've heard about data analytics and it sounds interesting. But is there a field that just deals with finding solutions without the the data acquisition part
Data analytics is focused on finding solutions. If by data acquisition you mean setting up the backend to source the data and get it structured into a system, this isn't something that's usually found in a data analyst job (though sometimes in data scientist roles - or at least skills expected). There are times you'll need to seek out the data you need to accomplish the task you have if it isn't already loaded into one of the systems you're using.
How fid you learn to write algorithms. I did it for a job and I just made something up but I thought I should know morr sbout it so I googled ways to make unique algorithms but I didn't get anywhere.
I suck at math and have a year of college behind me where I ultimately failed out of a coding class. It's been a few years and I think I have a better grasp on things, and I manage a lot of projects at my current job that revolves around managing data and understanding it. It was such a relief to learn math isn't a huge part of the job, but I think it's something I've just gotta get better at! My question is if being a Data Analyst requires a lot of coding? (I did Ruby and Python)
Hello, I am currently pursing my MBA, and I have to choose a specialisation in my final year. I have an option to choose “Information systems “ which includes the following subjects; 1. Information systems challenges in Management 2. Business System Analysis 3.Business Process Management My concern is that I don’t have any IT background , and I am afraid I might not do well on this subject. I would be grateful if you could suggest or guide me. Thank you
This could be a good specialization if you want to go into Data Analysis or Business Analysis. In many cases, these types of specializations aren't very IT heavy. They are usually more focused on how the topics apply to management and business. Even if you could get better grades on another specialization, the skills for this area will help in Business or Data Analysis. These classes might be a little harder for you, but that doesn't mean they are a bad choice!
Hi Jen, This video was really clear and great Thank You!!!! I would like to start data analysis. I’m 50 and throughout my career I have been involved from Marketing to finance arenas. I have a background in analytical chemistry. In all my functions I have realised I enjoy looking at trends, data processing in order to improve processed and solving problems. However even though I enjoy it, I need to do a course, to be able to enter this portfolio in the market. Which online courses would you recommend. I’m in South Africa.
Doordash is offering to pay for this class. And I only pay for it if I land a 40k+ job so it sounds good to me even if I get a decent job. To be able to pay the bills. Should I do it? I work at Starbucks right now and I don’t know if I want to promote. To shift lead because I feel like I’ll get stuck there. I want to try something else besides Starbucks.
I have a question: How many analysts would a company hire for the same office/building/floor? Also, is there such a thing as one analyst doing each of the things separately and then a couple of you coming together to solve the problem as a team?
Small companies might just have one analyst while some large companies have dozens of analysts working in the same office. Complex problems can involve teams of people working on different aspects of the problem.
I'm a triple major in finance,banking, and accounting. I'll be graduating this semester. One of my undergrad courses is a advance excel class, and we did a lot of macros/VBS. Being able to code really excited me! I've been learning python on weekends (throughout the semester), so now I'm looking into graduate programs in business analytics or data analytics. What's you're advice in preparing for these graduate programs? Thanks!
I took the Google certificate and got stuck on course 3 out of 8. I just couldn't continue. Imagining spending my days cleaning data was a real motivation killer. I'm glad it's not for me.
Thanks for the video. Trying to get better at cyber investigations. Big part is understanding the data. Do you have recommendations on courses of study
Wow this was very insightful, I'm glad I saw this right now . See I thought Data Analysts at work dwell a lot more on Probabilistic and Statistical Mathematics, reason why I decided to study applied maths next semester but it seems Computer science is the degree to tackle.? Is it?
Thanks for the info. I have no experience in this field but I'm interested in learning. I have a B.S.in Management and currently work in Sales. Do think it's a good field for someone transitioning careers at 40?
This might be a difficult transition for you to make, but it's possible. Without knowing more about your work experience, it seems like you'll need to build most of the analytics skills from scratch so the transition may take some time. One angle you could take is to look specifically for sales analytics positions so you can leverage your past sales knowledge and experience.
It might be better to look for Data Analytics or more specifically Business analytics certificates and then Masters programs before you try to transition to it as a career. There are quite a few online courses that can give you an idea, but more importantly, there’s a lot of Business/Data analytics masters degrees too.
Hi, I have a Bachelor's degree in Business System which I completed a couple of years ago. I want to get into the Data Analyst but have a slight knowledge of SQL and stats but not in-depth. Would you be able to suggest me what should be my next step? I am in my mid-30s. Am I too late for this career? Thanks in advance.
Never too late - I went into data analysis in my early 30’s and never looked back :-) it’s a great field to be in and really sharpens your maths skills :-). Learn sql, excel (vlookups, pivot tables, charts) and power bi. :-)
I'm not a math-oriented person (never took pre-cal and even algebra 2 was a slog ) and have more of an academic writing background, but I do have strong analytical, research and reasoning skills. Basically, numbers and formulas flummox me but logic problems make sense. In your view, are there areas of the data analysis field in which my math deficiencies and knowledge gaps wouldn't be a deal-breaker?
I can't think of any areas of data analysis that wouldn't involve math. Even the less math-heavy positions (such as a reporting analyst) still rely on algebra and basic statistics since the base of any data-related position is going to involve a lot of numbers. If you want to try building up your math skills, one way to approach it would be to treat math as learning a foreign language written in shorthand. A lot of math really is a logical problem that has defined logic tied to each symbol. This isn't going to suddenly make math a breeze to learn, but the approach might make it more relatable and comfortable.
So for a data analyst coding is important but vital is understanding of the data I guess....I have a statistics and math background and I was thinking to go for data analytics.I have understanding of terms such as sample,population,distribution but I don't have much coding background...so to implement my knowledge to build models with those data I need to learn programming right? Correct me if I am wrong cuz this is what insight I am getting.
Hi, thanks for this video! I was wondering, do you have any resources/info with respect to data analysis interacting with spatial analysis, specifically GIS?
Check out this video on things most colleges don't teach. You'll have a good advantage if you take time to learn them: ruclips.net/video/ZniKbPz8eJs/видео.html
Hi, Thank you for your good vid. I am a XRD analyst with more than 10 years lab working experience. I would like to change my career. I searched a lot about data analyst and it looks like interesting. I have some questions about how to get into this field as there are lots of program and certificate. I don’t want to wast my time and money. I appreciate any advice. 🌺🙏
Hi! Thank you for your video, there's a online course that can guide non-programming/analytical profiles like myself? Again, thank you for sharing. Best.
I have an ebook that covers the skills you need and how to build them. You can find it here: bit.ly/TCFDataAnalyst Also check out this video which has more resources for data analysts: ruclips.net/video/nDFNIvj9MCI/видео.html
Hi , I have been working as sales coordinator running weekly KPI reports using excel and dynamics 365, creating reports and dashboards, I have some experience in power BI, I want my next job to be data analysts so I have self taught SQL. How much of SQL knowledge is good enough for analyst role.what should I learn next? Should I focus on creating visuals from sql to power bi/tableau or is it something else I should learn first?
Hi, after twenty years as a mathematics teacher (11yrs old to 16 years old), I’m looking for a career change. Is data analysis something you would recommend?
Your background in math would be a good fit for analytics. With your teaching experience, I suspect you're good at explaining things which will suit you well in understanding analysis and explaining it to others. You might need to brush up on some stats (especially around regression analysis, etc) and also supplement with programming or analytics tools if you're not already familiar with them. This guide goes into more detail on the skills needed in different areas: bit.ly/TCFDataAnalyst I also offer career coaching if you'd like to work 1-1 to make a career transition plan specific to your experience. You can contact me here: bit.ly/TCFCoaching
Hey, great info 😅❤ I'm not changing careers per se, I just dropped out of college and would like to pursue a career in digital marketing. I found data analysis more interesting compared to the others e.g. content marketing because I want to help companies make decisions based on facts. I will need a lot of coaching as I'm studying this by myself, do you offer such coaching or know someone else who does ? Thanks a lot ✨✨
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
Can anyone tell me in order to be a data analyst what part of maths is required knowing statistics, probability, linear algebra,linear equipment will be sufficient or not and till which standard plz assist someone.
Shailesh Yadav Statistics, Probability Theory, linear algebra. There’s also some calculus but it depends on where you want to situate yourself in data analytics. More important than that, which I do not think she touched on, is the ability to think logically and critically. Critical thinking and Logic formulation is often bypassed in schools and universities because it seems apparent but most people don’t know it’s salience or how to develop logic process flow.
Recently graduated with a bachelors in Management Information Systems. What is the first step to getting into a data analyst role. If it helps, I have a Microsoft SQL cert.
Check out this video: ruclips.net/video/W1DFw-fmO0A/видео.html I also go into much more depth in my book on the skills you need, how to get them, and how to find a data analyst job: bit.ly/TCFDataAnalyst
What if you suck at math but want to do data analysis work? 😂I have a BS in Biology and MS in Coastal Zone Management (both STEM) but I'm horrendously bad at math... I can do statistics though!
If you can do statistics then you don't suck at ALL math 😂 You'll probably find some aspects very challenging if you're really bad at math other than stats though...
What average salaries can we expect in this profession. Also I just completed my 1st year of undergraduation and I've learnt plenty of competitve programming, and that's all ik. Could you pls guide me and tell me what should I learn right now to get a headstart when I enter in this field
Hey im considering reskilling due to covid and data analysis is offered as a cheap course at uni (part of Australia's getting people back into jobs policy). I am an English Langiage Teacher with a degree in arts and business. It seems to me that my background would be useful in a job such as this. Am I mistaken?
Hi, I am about to finish my Bachelor’s degree in Criminal Justice and believe I could be great as a Data Analyst. I recently took an information systems class and statistical analysis as well. How might I go about getting a job in this career field with my background fresh out of college?
Hello. Great video! I am looking at the Data Analyst/Science field but not sure if its a good fit for me. I have been a QA tester in the Logistics and Manufacturing Industry for the past 2 years. I don't have a technical background, but am pretty decent with SQL. I have a BA in Elementary Education. They offer an Intro to Data Science course at the local community college for around $900. I've also been looking at Full Stack Development bootcamps at UNC Charlotte that 3 or 6 months for $10,500. Big decisions. Any advice?
The intro to data science course could be a starting point to see how interested you are in the field. It's likely that's all it be good for though... Without knowing specifics, those courses rarely go into enough depth to learn what you need to learn. If you're in NC (assuming UNC Charlotte is local-ish for you), you're in a great hotspot for SAS jobs. Their headquarters are over in Cary. Your experience with SQL will make SAS fairly easy for you to learn and there are a lot of manufacturers that use SAS so that part of your background could be handy. If it's a transition you're seriously considering, I do analytics career coaching and could work with you to put together a detailed plan for building skills and experience. Shoot me an email at jennifer @ thecareerforce.com
Hi, I have a bachelor's degree in Instrumentation and Electronics Engineering. I don't have any experience in IT field. Initially I did couple Software testing courses and couldn't land on any job. In 2020 I got my Tableau certification as Tableau desktop specialist exam to try my luck as a data analyst and I have intermediate knowledge on SQL and Excel. With 0yrs of experience how can I get a job? I am fine even if I don't get paid I am ready to work for free to gain some experience. Or is there anyway I can volunteer for companies to work as data or reporting analyst or as a Tableau developer. I would appreciate any help.
Im doing a bachelor's in Computer engineering and im also interested in data analytics. How did you learn the skills for data analyst after you graduated?
I passed as a Data Analyst in Accenture Philippines and today is my (training) start I graduated BS Psychology and I hate Maths quite knows nothing how to use an MS Excel, do you think I might fuck up? Pleaze help.
Yes, it can be especially if you take a slightly more technical focus. Then you'll tend to not be as involved in as many business discussions and spend more time just you and your computer 👩💻
Most of the work is possible to do remotely but not every company is open to people working remotely. It really just depends on the company. There are many more people working on site in data analyst roles than working in remote data analyst roles.
@@Hilaire_Balrog Yup! Covid19 certainly has changed the way employers think or SHOULD THINK. I've been saying this forever, companies are so behind offering remote work. Technology is booming, and companies should take advantage of that. Interestingly enough covid19 forced companies to offer remote wk in order for them to keep their business' afloat.
Nothing bro, you don't need any particularized qualifications. You can market yourself with as a junior analyst just saying you've got excel skills. You can build most your skills that way with trying to get different gigs. Most business problems are common ones, so you'll be able to build a gamut of skills to apply across different applications
💡 Get the complete guide to becoming a data analyst: bit.ly/TCFDataAnalyst
Consider yourself lucky to have options.
Same
still trying to figure out what to do with my life so I’m here LOL
im with you bro...
with u
@@meganamachani6381 ok lets do it together guys. 😂
Do what'ever you like
Same bro same
Well... I've been a data analyst for several UN agencies for years and my job there was 1% math, 4% Data processing and 95% dealing with idiots.
hahahaha!
Can you give me any advice on how to get into this field? I have an MBA and my most recent job was being a program administrator in a university. I'm taking some courses on UDemy to learn more about Cognos and I have a bit of coding experience. I'm going to learn Python soon for analytics. on Udemy. Any suggestions would be great.
@@dec23 Sure... you can start with some statistics, which I'm sure you know about. There are other mathematical concepts you need to know how to apply, such as regression analysis, interpolation, extrapolation... etc. Those can come in handy when dealing with quantitative data.
Dealing with qualitative data is different, it can be a lot simpler when using categorized data, but when the data you need is imbedded in a free text, or open questions, it can be more complicated.
In Python, Pandas, Numpy and Matplotlib are the standard libraries for data analysis. You can also use geopandas if you like to work with geographic data.
The hardest part of the job is explaining what you do to some managers who have absolutely no idea what data analysis is or its basics.
@@abbddos Thanks! I'll look into those things!
@@abbddos you've got some great tips! I'm also a university graduates and studies statistics, thank you for your suggestions!
One thing people fail to tell aspiring Data Analysts is that you might not even use the tools as much as you expect. Take my job for example. We primarily use SQL, Tableau and Excel. But the SQL codes we regularly use are already documented. All you need is the SQL knowledge to be able to tweek the already existing code. And with Tableau guess what? The tables have already been created by a guy on the DBA team so all i do is go to Data Tab - Extract - Refresh and then just convert the table to Excel sheet and submit. I don't create anything in tableau. I just need a working knowledge to update and print tables. Some jobs might be different from mine though. What i though I'd be doing is waaaaayyyyyy different from what i am doing. I was expecting to get raw data, clean it (with any tool i want) and visualize it in Tableau. Or use SSRS to create reports. But i do none of that. But on the flip side it's still essential to know the tools through and through because you never know when a shake up will occur that will require you to build the tableau reports/tables, SSRS reports/write you SQL codes from the ground up.
Thank you for all the information regarding data analysts. I'm starting a training program after Thanksgiving. I'm really looking forward to getting into this field as I can use my mind rather than my body like I have as a construction worker. This coronavirus has changed the whole occupation landscape and it's time for me to reinvent myself. Also if you did a visual representation of what a data analyst does that would be immensely helpful as a template as one can see what the actual workday looks like visually
I’m in the same boat. Reinventing myself so I can work smarter not harder. I work in the elements, and I’m gone all the time.
I really appreciate this!! I got considered for a large acquisition company and I'm freaking out because they manage so many assets. I don't want to mess up!
I sent my curriculum vitae in a company and I'm going to apply as data analyst, this vid helps a lot and gave me an idea bc honestly I dont have any idea what the data analyst job is
Feel u. It's very broad
as a data analyst, I think the hardest part is knowing the problem that you want to solve and how to solve it with data. Because sometimes, the business person doesn't know the problem, and then you'll be asked to search in the data to find those problems.
That's definitely a challenging part! And one that many people aren't really taught how to do. It can really seperate ok analysts from really good analysts.
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
Thank you so much for this video. I've found it extremely helpful and informative. Watching this has made me realize I definitely want to pursue a career as a data analyst.
This makes me want to do data analysis so bad 😭😭
Analytics is a BLAST to work in!
Learn more about building the right skills and finding a data analyst job that's a great fit for you: bit.ly/TCFDataAnalyst
If you're applying for analytics jobs check out my course on building the perfect analytics resume: bit.ly/TCFPerfectResume
I am a Business/ Data Analyst. I do not use mathematics that much!
I am working as a data analyst for the past 4 years. I love the job since it's not monotonous in the long run and provides new challenges that can't be solved using established rules . It needs lot of patience , curiosity and hard work. The journey is somewhat similar to doing a PhD
I love the variety as well! There's so much learning that takes place and much to learn on the job regardless of education level. The practical implementation takes most people time to adjust to - I've seen PhDs that struggled and people with bachelors / no degree that thrived.
@@TheCareerForce definitely true .. I have worked with people have doctorate who are really smart but some of them aren't as good in the job since they lack few qualities .. nonetheless I need to also add that the job can be quite frustrating sometimes when we put in so much effort but aren't able to find the issue or if the issue was due to minor error
Naveen Bali hi naveen, could you please let me know skills or technologies required for data analyst, i know python , excel , what more I need , I am confused please help me
This video really cleared up a lot of questions i had, Thank you!
I'm glad it helped! Are you thinking of becoming a data analyst?
i have a B.A. in Philosophy , and i used to be a really big math person, just not so much anymore. i went into philosophy because logic and extracting the meaning of things came naturally to me. this video has proven really helpful in making my decision. thank you!
Thank you for this video. It really helped me learn about the topic. Thanks
You're welcome! I'm glad it helped.
to the point information! thank you!
I have one question, in which scenario do data analysts use sql, and when do they use python?
Thank you so much for the awsome video!
I really want to become an Analyst and the content of this video really help me understand that most of the job
is just being able to solve problems.
And more then this i finally understood that math is not the main thing but also important.
I though that high lvl of math is really important and it a reliefe to hear that it not have to do with the most of the analysis.
Thank you so much for this content !
Very well explained, thank you for sharing.
Thank you for the insight! This is great! ✨✨✨✨
Hi, this video helped me a lot. My part of data analysis is more towards the data and less towards math. Please help me to understand the data and improve my problem understandings skill
I have videos coming up over July and August that will cover some of this!
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
Thanks! This is the channel just for me! 🤓
Thank you so much for sharing your insights. I'm excited to learn more about data analysis and data science!
I feel like I have just been gathering and cleaning data but never getting a chance to really analyze it because it is eating up so much of my time. I am doing more of sales support than anything else.
even with a B.S. in statistics and actuarial science I still didn't know what the hell I would be doing. Thanks for the video.
Watching in 2019, almost 2020. Thank you!
What interests you the most about being a data analyst?
I think so it's the ability to use statistics to actually solve business problems. The fact that you can quantify an ambiguous process and gain insight is what attracts me. Or I assume. Still researching about this field tbh. Great video!
I agree! I've always enjoyed solving practical problems and analytical skills help create a structure to make it possible.
Are you thinking of moving into a data analytics career?
@@TheCareerForce I am actually researching about careers in Data analysis, project management and supply chain management. Though from a background in Mech. Eng, math hasn't been a "natural" proficiency for me. But analytics is a field that looks interesting to me.
Some of the stuff I'm doing right now:
1) Prepare masters applications for industrial engineering, with a specialization in optimization/operations research.
2) Develop skills in python, VBA and SQL for a possible internship.
3) Learn more about the field (that's how I found your channel)
The Career Force what skills do I need to become a data analyst? I will be graduating from university with a BS in computer science. Thank you for your help!
@carysa227 Your BS in Computer Science is a great foundation for the programming, problem solving, and data visualization that most roles require! You'll also need math (statistics) skills and communication skills.
Here are 2 videos that explain in more detail:
How to become a data analyst (ruclips.net/video/W1DFw-fmO0A/видео.html)
Top 5 Data Analyst Skills (ruclips.net/video/Dxy7dGhy62s/видео.html).
Are there data jobs that involve more of the math/logic side?
I like the idea of acquiring and cleaning the data, and then quantifying it to make informative visuals or summations. I feel like if all the parts of the data analyst role, that these are the most interesting to me, but unsure if that translates to a different role I should consider.
Did you find your answer? I was thinking the same thing too
I'm not very good with Math. But as far as I can tell about SQL language and some ETL stuff, it usually goes around : SUM/AVG/COUNT.. lol.
Don't worry too much about data cleaning, there are very good Extract/Transform/Load program nowadays, I like PENTAHO, it's free and very easy to use (regexp helps a lot). The hard part is to understand your Data and what you can tell (stories) with them. You didn't mention in the video that you have to master DBA knowledge : a star schema is useful ... and you will have to build one from scratch.
You're definitely right that understanding your data is critical. Data cleaning tools are helpful and knowing the data itself will make you much better at data cleaning.
It's interesting that you mention DBA knowledge. My first reaction was to disagree (I think of this more for data scientist than data analyst), but then I realized I approach the same thing from a math instead of a programming perspective. The DBA knowledge that's important for analysts could also be referenced as set theory knowledge - how different sets of data connect and interact with each other. I'm glad you mentioned it!
@@TheCareerForce I though data analyst and data scientist was the same job ...
I think I understand a little bit the difference between the two : analyst is more like "what you can do with data already in place" compare to data scientist that covers the ETL part. Am I right ?
I'd like to model some productivity and revenue numbers to actually see the Pereto Principle that is in effect, and from that find the optimum revenue and productivity.
I also think it's an IT issue to move from manual productivity tracking to automated productivity tracking. I've seen administrative tasks increase to points where less field work is able to be performed because the field staff are not able to use the manual tracking applications such as where to look for information on a project, filling in their timesheet with work, travel time, mileage, and report prep, and finally their service orders with attached reports. The human-err factor is multiplied per interaction per iteration along with skill gap issues.
Most of the time, admin staff are correcting errors in the tracking, but staff continue to make the same errors.
I'd like to learn how to prepare data that can be presented to management to be able to address these kinds of issues and more.
You raise many good points here. There's a lot of benefit to tracking and adding data to many aspects of business. ("What gets measured gets managed" is a quote I've heard in many businesses). What many people don't acknowledge is that this can often lead to a temporary decrease in performance because there's so much time spent manually tracking activities. That's fine when management recognizes this as a step on the growth curve, but it's often treated as "do this on top of what you're already doing". This is a great place for apps and other intelligent technology to come in - for people that are traveling to job site - apps that automatically record their time / mileage based on geofencing, etc.
Sampling may be a good approach here so that it gives the data needed to take action without overburdening everyone to collect it constantly. In parallel, work on identifying / creating the IT tools needed to automate these activities to provide a longer term solution.
Very concise description. May I please know how much finance knowledge does it involve? I just completed my CPA, we have a micro-credential course for data analytics open here, not sure whether I need to study it if it has too much finance involved (I'm not good at Finance). Thank you.
hi, i love writing algorithms and finding solutions to problems, I've heard about data analytics and it sounds interesting. But is there a field that just deals with finding solutions without the the data acquisition part
That's interesting. I'm strong in data acquisition, but weak in writing algorithms.
Data analytics is focused on finding solutions. If by data acquisition you mean setting up the backend to source the data and get it structured into a system, this isn't something that's usually found in a data analyst job (though sometimes in data scientist roles - or at least skills expected). There are times you'll need to seek out the data you need to accomplish the task you have if it isn't already loaded into one of the systems you're using.
How fid you learn to write algorithms. I did it for a job and I just made something up but I thought I should know morr sbout it so I googled ways to make unique algorithms but I didn't get anywhere.
This video is the best JUST NEED AN EXAMPLE for understanding the 3 parts... Thanks for the video....
I suck at math and have a year of college behind me where I ultimately failed out of a coding class. It's been a few years and I think I have a better grasp on things, and I manage a lot of projects at my current job that revolves around managing data and understanding it. It was such a relief to learn math isn't a huge part of the job, but I think it's something I've just gotta get better at! My question is if being a Data Analyst requires a lot of coding? (I did Ruby and Python)
for the modern data analyst, yes, coding (SQL) is the majority of the job. basic stats is all you need when it comes to math.
@@barclayangus when you say coding SQL you mean being able to use SQL QUERIES?? Thx.
Love this! Thank you for sharing.
Hello,
I am currently pursing my MBA, and I have to choose a specialisation in my final year. I have an option to choose “Information systems “ which includes the following subjects;
1. Information systems challenges in Management
2. Business System Analysis
3.Business Process Management
My concern is that I don’t have any IT background , and I am afraid I might not do well on this subject.
I would be grateful if you could suggest or guide me.
Thank you
This could be a good specialization if you want to go into Data Analysis or Business Analysis. In many cases, these types of specializations aren't very IT heavy. They are usually more focused on how the topics apply to management and business. Even if you could get better grades on another specialization, the skills for this area will help in Business or Data Analysis. These classes might be a little harder for you, but that doesn't mean they are a bad choice!
The Career Force thank you
So I sux at math but love to gather info, analyze, and solve problems...would this be a problem for me to do this kind of job?
Good question
Same with me
The programs do the math for you! And there will always be people to double check your work.
Hi Jen,
This video was really clear and great Thank You!!!!
I would like to start data analysis. I’m 50 and throughout my career I have been involved from Marketing to finance arenas. I have a background in analytical chemistry. In all my functions I have realised I enjoy looking at trends, data processing in order to improve processed and solving problems. However even though I enjoy it, I need to do a course, to be able to enter this portfolio in the market. Which online courses would you recommend. I’m in South Africa.
Hi Michelle! On The Career Force website we have some training options that could help!
thecareerforce.com/products
Doordash is offering to pay for this class. And I only pay for it if I land a 40k+ job so it sounds good to me even if I get a decent job. To be able to pay the bills. Should I do it? I work at Starbucks right now and I don’t know if I want to promote. To shift lead because I feel like I’ll get stuck there. I want to try something else besides Starbucks.
I have a question: How many analysts would a company hire for the same office/building/floor? Also, is there such a thing as one analyst doing each of the things separately and then a couple of you coming together to solve the problem as a team?
Small companies might just have one analyst while some large companies have dozens of analysts working in the same office. Complex problems can involve teams of people working on different aspects of the problem.
I'm a triple major in finance,banking, and accounting. I'll be graduating this semester. One of my undergrad courses is a advance excel class, and we did a lot of macros/VBS. Being able to code really excited me! I've been learning python on weekends (throughout the semester), so now I'm looking into graduate programs in business analytics or data analytics. What's you're advice in preparing for these graduate programs? Thanks!
hi I am just curious if you ended up doing your graduate program in data analytics and how did it go?
Your hair color is so cute 😍
I took the Google certificate and got stuck on course 3 out of 8. I just couldn't continue. Imagining spending my days cleaning data was a real motivation killer. I'm glad it's not for me.
Thanks for the video. Trying to get better at cyber investigations. Big part is understanding the data. Do you have recommendations on courses of study
Wow this was very insightful, I'm glad I saw this right now . See I thought Data Analysts at work dwell a lot more on Probabilistic and Statistical Mathematics, reason why I decided to study applied maths next semester but it seems Computer science is the degree to tackle.? Is it?
C.K.O- SAMA you need a mix of computer science and statistics/probability.
Thanks for the info. I have no experience in this field but I'm interested in learning. I have a B.S.in Management and currently work in Sales. Do think it's a good field for someone transitioning careers at 40?
This might be a difficult transition for you to make, but it's possible. Without knowing more about your work experience, it seems like you'll need to build most of the analytics skills from scratch so the transition may take some time. One angle you could take is to look specifically for sales analytics positions so you can leverage your past sales knowledge and experience.
It might be better to look for Data Analytics or more specifically Business analytics certificates and then Masters programs before you try to transition to it as a career. There are quite a few online courses that can give you an idea, but more importantly, there’s a lot of Business/Data analytics masters degrees too.
Go to a data science boot camp
Very good explanations and guidance!
Hi, I have a Bachelor's degree in Business System which I completed a couple of years ago. I want to get into the Data Analyst but have a slight knowledge of SQL and stats but not in-depth. Would you be able to suggest me what should be my next step? I am in my mid-30s. Am I too late for this career? Thanks in advance.
Never too late - I went into data analysis in my early 30’s and never looked back :-) it’s a great field to be in and really sharpens your maths skills :-). Learn sql, excel (vlookups, pivot tables, charts) and power bi. :-)
I'm not a math-oriented person (never took pre-cal and even algebra 2 was a slog ) and have more of an academic writing background, but I do have strong analytical, research and reasoning skills. Basically, numbers and formulas flummox me but logic problems make sense. In your view, are there areas of the data analysis field in which my math deficiencies and knowledge gaps wouldn't be a deal-breaker?
Same here, would really like hearing others' opinions.
I can't think of any areas of data analysis that wouldn't involve math. Even the less math-heavy positions (such as a reporting analyst) still rely on algebra and basic statistics since the base of any data-related position is going to involve a lot of numbers. If you want to try building up your math skills, one way to approach it would be to treat math as learning a foreign language written in shorthand. A lot of math really is a logical problem that has defined logic tied to each symbol. This isn't going to suddenly make math a breeze to learn, but the approach might make it more relatable and comfortable.
if you can do basic stats, that's all you need in terms of math to be an effective data analyst.
So for a data analyst coding is important but vital is understanding of the data I guess....I have a statistics and math background and I was thinking to go for data analytics.I have understanding of terms such as sample,population,distribution but I don't have much coding background...so to implement my knowledge to build models with those data I need to learn programming right? Correct me if I am wrong cuz this is what insight I am getting.
thank you, great video!
Hi, thanks for this video! I was wondering, do you have any resources/info with respect to data analysis interacting with spatial analysis, specifically GIS?
Thank you for the information!
Thank you for this video, working as Data Analyst are stakeholders the same thing as a client?
Thank you! Subscribed!
Thank you for the video! It's useful
I’m a first year Data Mining student! Do you have any advice or tips for me please?
Check out this video on things most colleges don't teach. You'll have a good advantage if you take time to learn them: ruclips.net/video/ZniKbPz8eJs/видео.html
Can you do this with just a plain masters degree in pure math?
Thank you, you explained very well.
guaranteed no actual data analyst watches this video.... probably just people aspiring to be one
Hi,
Thank you for your good vid. I am a XRD analyst with more than 10 years lab working experience. I would like to change my career. I searched a lot about data analyst and it looks like interesting. I have some questions about how to get into this field as there are lots of program and certificate. I don’t want to wast my time and money. I appreciate any advice. 🌺🙏
Hi, thank you for sharing your knowledge about data analyst. May I know if can I start to apply as a data analyst with my knowledge in excel?
Hi! Thank you for your video, there's a online course that can guide non-programming/analytical profiles like myself? Again, thank you for sharing. Best.
I have an ebook that covers the skills you need and how to build them. You can find it here: bit.ly/TCFDataAnalyst
Also check out this video which has more resources for data analysts: ruclips.net/video/nDFNIvj9MCI/видео.html
@@TheCareerForce Great! Thanks a lot
Can you send me the link about this online course. Thanks
Hi , I have been working as sales coordinator running weekly KPI reports using excel and dynamics 365, creating reports and dashboards, I have some experience in power BI, I want my next job to be data analysts so I have self taught SQL. How much of SQL knowledge is good enough for analyst role.what should I learn next? Should I focus on creating visuals from sql to power bi/tableau or is it something else I should learn first?
Definitely didn’t mention the applications
Hi, after twenty years as a mathematics teacher (11yrs old to 16 years old), I’m looking for a career change. Is data analysis something you would recommend?
Your background in math would be a good fit for analytics. With your teaching experience, I suspect you're good at explaining things which will suit you well in understanding analysis and explaining it to others. You might need to brush up on some stats (especially around regression analysis, etc) and also supplement with programming or analytics tools if you're not already familiar with them.
This guide goes into more detail on the skills needed in different areas: bit.ly/TCFDataAnalyst
I also offer career coaching if you'd like to work 1-1 to make a career transition plan specific to your experience. You can contact me here: bit.ly/TCFCoaching
Hey, great info 😅❤ I'm not changing careers per se, I just dropped out of college and would like to pursue a career in digital marketing. I found data analysis more interesting compared to the others e.g. content marketing because I want to help companies make decisions based on facts. I will need a lot of coaching as I'm studying this by myself, do you offer such coaching or know someone else who does ? Thanks a lot ✨✨
let me know, is there any need to have a science background to learn data science or it can be learned if one who graduate in bachelor in arts
?
I also want to know this
Hi, i saw google course for data analyst, do you think google certification is worth it? Thank you
I'm currently an incoming freshman and im considering taking the course "BSBA Major in Business Intelligence and Analytics" that degree is meant for thos who want to be a data scientist. But fckk im scared as hell to grab that couse cause im not good at math. ANY THOUGHTS? AND PLEASE GOVE ADVISE THANK YOU
Jen...you rock!
Can anyone tell me in order to be a data analyst what part of maths is required knowing statistics, probability, linear algebra,linear equipment will be sufficient or not and till which standard plz assist someone.
Is it worth my time to pursue a 6 month certification to get in entry level?
Great Video. Well put and explained. Thank you.
Is mysql sufficient for data analysis...or should i learn Oracle ( sql) as well
Hello , may i ask what course in college or 2nd course better to take to become a data analyst? Thank u
Hi Jen, could you please elaborate on the kind of mathematical principles that are put to use in Data Analysis? THANKS IN ADVANCE!!!!
From what I've seen, it's mostly statistics. Things like central tendency, dispersion, regression, time-series, etc
What kind of math do we need?
hello mam
How can i get a job as frehsers a data analyst with skills like Advanced excel,Sql,python and some visualization Tools(Tableau,PowerBI)
Thank you for the post.
What kind of maths ?
Like permutations and combinations...etc ?
Shailesh Yadav Statistics, Probability Theory, linear algebra. There’s also some calculus but it depends on where you want to situate yourself in data analytics. More important than that, which I do not think she touched on, is the ability to think logically and critically. Critical thinking and Logic formulation is often bypassed in schools and universities because it seems apparent but most people don’t know it’s salience or how to develop logic process flow.
Recently graduated with a bachelors in Management Information Systems. What is the first step to getting into a data analyst role. If it helps, I have a Microsoft SQL cert.
Check out this video: ruclips.net/video/W1DFw-fmO0A/видео.html
I also go into much more depth in my book on the skills you need, how to get them, and how to find a data analyst job: bit.ly/TCFDataAnalyst
m in the same spot, i took a internship as a web analyst and I'm working with Data Studio, Tableau, and Google Analytics.
how is labor analysis job different?
What if you suck at math but want to do data analysis work? 😂I have a BS in Biology and MS in Coastal Zone Management (both STEM) but I'm horrendously bad at math... I can do statistics though!
If you can do statistics then you don't suck at ALL math 😂
You'll probably find some aspects very challenging if you're really bad at math other than stats though...
What is the difference between accounting and data analysis? Why don’t accountants just do what data analysts do?
What average salaries can we expect in this profession.
Also I just completed my 1st year of undergraduation and I've learnt plenty of competitve programming, and that's all ik.
Could you pls guide me and tell me what should I learn right now to get a headstart when I enter in this field
$60,000
$60,000 per year
Here's a video on salaries for data analyst (focused on US): ruclips.net/video/WwpqQuSb_mU/видео.html
Hey im considering reskilling due to covid and data analysis is offered as a cheap course at uni (part of Australia's getting people back into jobs policy). I am an English Langiage Teacher with a degree in arts and business. It seems to me that my background would be useful in a job such as this. Am I mistaken?
I don't get it
Very helpful!
Hi, I am about to finish my Bachelor’s degree in Criminal Justice and believe I could be great as a Data Analyst. I recently took an information systems class and statistical analysis as well. How might I go about getting a job in this career field with my background fresh out of college?
learn SQL. figure out how to get an entry level job with exposure to analytics, then leverage that resume experience to get the next job.
I like your energy
Thank you 💯
Hello. Great video! I am looking at the Data Analyst/Science field but not sure if its a good fit for me. I have been a QA tester in the Logistics and Manufacturing Industry for the past 2 years. I don't have a technical background, but am pretty decent with SQL. I have a BA in Elementary Education. They offer an Intro to Data Science course at the local community college for around $900. I've also been looking at Full Stack Development bootcamps at UNC Charlotte that 3 or 6 months for $10,500. Big decisions. Any advice?
The intro to data science course could be a starting point to see how interested you are in the field. It's likely that's all it be good for though... Without knowing specifics, those courses rarely go into enough depth to learn what you need to learn. If you're in NC (assuming UNC Charlotte is local-ish for you), you're in a great hotspot for SAS jobs. Their headquarters are over in Cary. Your experience with SQL will make SAS fairly easy for you to learn and there are a lot of manufacturers that use SAS so that part of your background could be handy. If it's a transition you're seriously considering, I do analytics career coaching and could work with you to put together a detailed plan for building skills and experience. Shoot me an email at jennifer @ thecareerforce.com
Thanks Jennifer! I will email you this morning.@@TheCareerForce
Hi, I have a bachelor's degree in Instrumentation and Electronics Engineering. I don't have any experience in IT field. Initially I did couple Software testing courses and couldn't land on any job. In 2020 I got my Tableau certification as Tableau desktop specialist exam to try my luck as a data analyst and I have intermediate knowledge on SQL and Excel. With 0yrs of experience how can I get a job? I am fine even if I don't get paid I am ready to work for free to gain some experience. Or is there anyway I can volunteer for companies to work as data or reporting analyst or as a Tableau developer. I would appreciate any help.
Im doing a bachelor's in Computer engineering and im also interested in data analytics. How did you learn the skills for data analyst after you graduated?
Can i study Economics and Computer science and get this job
Studying statistic is a good idea ?
I passed as a Data Analyst in Accenture Philippines and today is my (training) start I graduated BS Psychology and I hate Maths quite knows nothing how to use an MS Excel, do you think I might fuck up? Pleaze help.
Batman Justice how are you holding up?
Bravo!
Hi, would this be a good career choice for an introvert? I would like as little interaction with people as possible.
Yes, it can be especially if you take a slightly more technical focus. Then you'll tend to not be as involved in as many business discussions and spend more time just you and your computer 👩💻
The Career Force Awesome. Thanks for responding!
Is it true most data analyst jobs can allow you to work remotely
Most of the work is possible to do remotely but not every company is open to people working remotely. It really just depends on the company. There are many more people working on site in data analyst roles than working in remote data analyst roles.
The Career Force they are now lol
@@Hilaire_Balrog Yup! Covid19 certainly has changed the way employers think or SHOULD THINK. I've been saying this forever, companies are so behind offering remote work. Technology is booming, and companies should take advantage of that. Interestingly enough covid19 forced companies to offer remote wk in order for them to keep their business' afloat.
What are the required subjects for a data analyst ??
Nothing bro, you don't need any particularized qualifications. You can market yourself with as a junior analyst just saying you've got excel skills. You can build most your skills that way with trying to get different gigs. Most business problems are common ones, so you'll be able to build a gamut of skills to apply across different applications