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
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.
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
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
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!
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.
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 !
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 ?
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
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.
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.
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.
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.
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!
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)
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 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.
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.
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.
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. :-)
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 ✨✨
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?
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, thanks for this video! I was wondering, do you have any resources/info with respect to data analysis interacting with spatial analysis, specifically GIS?
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
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.
Check out this video on things most colleges don't teach. You'll have a good advantage if you take time to learn them: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZniKbPz8eJs.html
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! 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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nDFNIvj9MCI.html
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.
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.
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?
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
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. 🌺🙏
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...
That’s the way you see it. I see it as a career thats gonna be easy and satisfying. Also it pays well so I can enjoy my life good. I hope to become a statistician when I grow up
this is the reason why you don't pick a job for the money. you pick a job because it's fun. and many people find data analysis a fun and rewarding career.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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
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?
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
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
Nate Horne you can work on that... being an introvert doesn't necessarily mean you can't function in a company but getting their problems down is key, so ideally being an introvert would not entirely affect your job unless it gets to the point where you can't even socialize then maybe its not the job for you. based on the video she said meetings and talking to people is key
Data analyst is a great career choice for introverts. You'll still spend some time interacting with others and understanding what the business needs. You'll also spend a lot of time working alone though. You might also find that you like having some interaction and are ok with being more extroverted at work or for parts of work. I'm also an introvert, but have a more outgoing style when it comes to getting things done at work.
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.
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 👩💻
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?
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.
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?
