Switching Careers to Become a Data Analyst | How I Made the Switch

[@AlexTheAnalyst]

Thanks for watching! If you want to see how to create your Data Analyst Resume be sure to check out this video --> kzbin.info/www/bejne/hKSQaX2plpige68

[@canadachat6046]

Hi Alex, I am planning to switch my career to become a data analyst . Can you suggest on what tools i should work.. SQL or R or Python for data visualization Tableau or other.

[@AlexTheAnalyst]

That's awesome! I would start with SQL and at least learn the basics well. I personally would then go onto Python. I think that combo is amazing to start with. After that I would learn Tableau. Hope that helps!

[@thecalgarians4597]

Alex, do you work from home nowadays ??

[@comelon3]

Thank you for your suggestions, I am glad your career took off!.God Bless your family

[@AlexTheAnalyst]

Thank you so much for watching and supporting the channel!

[@alisiayoung5796]

Wow, thank you for this video! I did a bachelor's of science and then did more specialized training in naturopathy, but it was more of a passion than what I saw for myself as a career. Throughout school I worked in fitness, clerical, and teaching. Currently working as a Data administrator and thinking about what my next steps are to achieve my career and lifestyle goals. At this stage of my life I'm considering things I hadn't thought about in my 20's, like salary projections, career outlook and demand, level of challenge, and portability. So far I was considering doing a Diploma in Health Information Management or Business Administration, yet a school I spoke with suggested looking into Data Analytics. And here your channel is. I'm so excited to watch and learn from you, thank you!!!!

[@AlexTheAnalyst]

Alisia Young that’s super cool Alisia! You definitely have a lot of options before you, but I’m a big fan of Analytics myself 😁 if you liked this video I actually do a weekly show where I go really in depth on a topic. Episode 2 was “How I Switched careers...” and goes very in depth on it. Good luck!

[@user20517]

Hello, thanks for sharing this inspiring story. I am glad that you have landed the job. I am considering a career change to data science as well. Wish you all the best.

[@AlexTheAnalyst]

Ahmad Hasweh Hey Ahmad, thanks for watching! Good luck on your career switch!

[@rr2308]

Really good video! Im trying to Switch from nursing to healthcare analytics so I'm hoping for the best.

[@ericjaysonlorena9283]

Jalapeños!!!! Thank you Alex! Your video is very inspiring.

[@davidphan2944]

Great video on your experience to your career change! I was in your exact situation from transitioning to analytical roles. Prior to that I was an engineer. While the problem solving traits was an advantage, the key is really embracing the tools that analysts use from research and self-learning. Keep up the content!

[@mahmoud332]

Thanks for your honesty 😊

[@davidevans1537]

Thanks

[@omodolapoadesanya3532]

Hi Alex, thanks for leaving this here. I’m transitioning into becoming a data analyst, started out with Google Data analytics course on Coursera.

[@Yemisi.Owoade]

4 years after and this post is still quite relatable. Finished my Masters Degree in December’23 and this is March ‘24 and I’m still searching for a job. Currently located in Dallas too.

[@chickthedinosaur]

Hi Alex. Thanks a lot for sharing. Here in China the competition is really fierce. For most of the time companies just look for someone who is single, better not to be woman and 100% bg fit is required. I am thirty now. I graduated with my software degree and have eight years experience dealing with business and data in telecommunications, e-commerce and fintech. I used SQL and power BI in my previous project, I also learn machine learning by practicing in python. I gained my certificate in quan, and I also have three months work experience in one of the biggest internet companies. My previous job is not analyst in title, i worked as consultant and internal auditors. it feels so suffocating, i got none interview during the past. One of the job hunters told me they prefer some one will possibly not take maternity leave, someone who worked in internet all the time. This is weird that people would get married and give birth to a baby at any time, not only a 30 year old woman but could also be a 25, 40 woman. It seems like there not to do but to leave the work. I This makes even want to leave my country, sorry for saying that. China is a great to live and not a good place to work in. so disappointing.

[@AlexTheAnalyst]

Hey Lizzy, I'm super sorry to hear that. That sounds very frustrating and I can see why you would be upset. Have you looked into moving anywhere for work outside of China? I hate that that sounds like the only option. I do hope things turn around for you!

[@mathiewsc.zavala1067]

You got me, I subscribe. I have seen some of your videos, and I am now in a transition stage, in my current job I have had to analyze a large amount of data, polish and clean it, and I realy loved it but it is not one of my functions, the company was recently in the need to generate a large amount of data related to machines (I am a process engineer), but thanks to that and also while talking with a friend who is a web developer I discover about Data Science and Data Analitycs. Your videos are realy useful, and thanks for sharing you experience.

[@AlexTheAnalyst]

I'm so glad to hear! Super happy to hear my videos have been helpful! If you liked this video you should check out my most recent one I did called "How I changed careers to become a data analyst". Goes much more in-depth into what I talked about in this video. Have a good one!

[@mathiewsc.zavala1067]

Thanks again ​ @Alex The Analyst , I had seen a short version I did not know that there was an Episode 2. I really enjoyed it!

[@tnatdanai]

Thank you for the video. I am experiencing all you mention; a lot of call interviews, work with recruiters, and most of the offers are contracts. It's like l am not alone that having this experience.

[@CPerezsh]

Hi Alex! I think that I really needed to see this channel, because actually I feel stock in what I'm doing right now, I've been working as a facilities manager for so long time and just tired of it :( I came to this channel to convince myself to search new knowledge and opportunities and I want to believe that analytics might be the way

[@AlexTheAnalyst]

Hey Carlos! That's great - I hope you can make the change and I hope my channel helps! Good luck!

[@phichau90]

Thank u dude. Im actually in tranisitioning into data analyst

[@AlexTheAnalyst]

That's awesome! Good luck!

[@zyrrre]

Hi khin, please share your story.. What was your previous profession?

[@glorialin964]

I can relate so much to everything you said!!

[@beyondtriggered4145]

I'm currently transitioning into becoming a Data Analyst. I was already doing a lot of analyst work through Excel. Last month I put in my resignation but offered part-time so I could study more to get those certifications and learn SQL. My company offered me a part-time role in my current position the last month and starting today a part-time role starting today as a Data Analyst that will transition to full-time in January. I passed the DA-100 and the 70-778/779 last month. I have a lot of industry knowledge with my company including the processes of multiple departments, but I don't feel confident yet in my SQL and Python abilities (still learning those for sure). About how long did it take you to feel more confident in your skillset? I study for about 6-10 hours a day on days I work and 12 hours on weekends. I feel incredibly lucky and don't want to mess up this great opportunity.

[@AlexTheAnalyst]

Wow, that's quite the leap! I wish you the best of luck in your transition! I started to feel pretty confident after about 3-4 months. I was studying about 3-4 hours a day though so you may have faster results :)

[@beyondtriggered4145]

@@AlexTheAnalyst Thank you so much for this response almost a month ago. I am feeling a lot more confident now. My boss has been very understanding of any gaps that I have and has given me projects to help me focus on the areas I struggle with most. I'm already finding and solving issues in data governance, providing some visualizations that are management friendly for drilling down into the main issues, and start my first huge project on Thursday.

[@SuperRymus]

i have a dream... i want to be a Data Analyst in malaysia ( i'm from Algeria). i'm working really hard to achieve that dream, i'm learning programming with python, C#, i'm learning descriptive and analytical statistics using RStudio, i hope that i'm going to succeed , and your videos are really helpfull :D thank you so much :D

[@AlexTheAnalyst]

Do it! I'm so glad my channel has been helpful. I wish you the best of luck and hope to hear of your success in the months to come! :D

[@zackla8348]

Very inspiring good luck sir , we want a videos so you can tell us the obstacles you faced and what we've to do to stay motivated and keep going during a data analytics career , and also we wanna know the difference between BI analyst and data analyst , thanks again

[@AlexTheAnalyst]

Thanks so much for watching! Those are great suggestions. I will add those to my list!

[@muhammadaminullah5367]

good stuff!

[@coolvideos9773]

I studied CS for a career change and graduated last year in 2:1. Now I’m struggling a lot to find the job as my CV shows no experience in CS but the pharmacy:(( I’m starting data analysis skills now as I think this is something can get me into the IT if I have good skills

[@shekhargowda3050]

Great video

[@AlexTheAnalyst]

Thank you! And thanks for watching!

[@areynol]

I just found your channel & started to binge watch. These video are amazing! I'm currently a nurse, and want to put in the work to switch careers for data analyst. I just don't know how to look attractive to employers without a Bachelor's in CS, and only a AAS in Nursing. I plan on getting a SQL cert, and making a website showcasing future projects like you suggested in the comments to someone else. Not gonna lie though, it's very discouraging not having that piece of paper.

[@AlexTheAnalyst]

areynol that’s awesome! If you liked this video you should check out my extended version of this which I just recently uploaded. It goes over my whole journey and how I switched careers. It’s definitely can be tough, but I think nursing combined with tech skills is super valuable! Good luck and you got it!

[@bane2256]

You don’t need the paper

[@bislari124]

I'm also going to subscribe you. I have also interested in Data analysis. I'm working in E-commerce domain as an Application Engineer. Before that, i was working for Healthcare domain upto 5 years and during that period i was able to understand data analysis. And it turns out to be my passion. So really want to connect you. Thank you for motivated us.

[@AlexTheAnalyst]

Very cool! I'm sure your subscription will be well worth it :D Good luck to you!

[@nimrodbecerro5849]

Thank you for this video I am ang electronics engineer and starting a career shift to data analytics.

[@AlexTheAnalyst]

That's awesome! Good luck on your career change!

[@puneetpandit706]

Hello Trader. Same is the case with me. Can you please suggest any social media where we can connect? I really need any kind of guidance on how to approach this career shift of mine.

[@Syntaxstic]

So you just learned sql? What resources did you use ?

[@foodrainbow1789]

Hi Alex, Thanks for the video. It was inspiring. Actually i also want to switch to data analyst profile from a different background. I already started learning SQL, python and has already done number of codes in both. But i don't understand how to start the demo projects for data analysis. Could you please guide me where to do the data analysis projects and what else do i need to practice before i start applying for data analyst jobs?

[@AlexTheAnalyst]

Food Rainbow I’ll definitely be doing videos on this is in the future, but the basic premise is to sow each part of DA work. A project could be taking a dataset and importing it not SQL, cleaning up the data, creating views, connecting a visualization tool to your view and creating the visualization for your data.

[@craigcole9486]

Is building a portfolio (Git Hub or Kaggle) necessary to begin a Data Analyst career??

[@AlexTheAnalyst]

I think at the beginning it is extremely helpful because it shows employers your skill level.

[@JTProductions3]

What were you doing before? I am an English teacher applying to study a masters in data science. How did your previous job affect your ability to get/keep your current job?

[@AlexTheAnalyst]

I was a therapist at a behavioral health hospital. I mostly did group therapies for people who had schizophrenia, were bipolar, were suicidal, and had other mental illnesses. It was quite an interesting job! I don't think it really had any skills other than people skills that I really used for being a Data Analyst. In my mind it was a complete 180 on my career at the time. I did get a job as a "Data collection specialist and Analyst" job kind of randomly which was what caused the huge flip. I was working at a non-profit and they just needed someone to work in excel spreadsheets and they didn't have any other applicants so I got the job. I only worked in Excel, but at that time I heard about something called "SQL". That was the big turning point where I started pushing really hard to learn the skills to become a real Data Analyst. So I don't have a background in Analytics, but I've worked hard to learn the skills on my own and in the previous jobs I've had once I actually got a Data Analyst job.

[@JTProductions3]

@@AlexTheAnalyst cool good to know! Due to covid my industry and the ones i was looking to get into (film and events) are untenable at the moment and so first a grad certificate (first 6 months of a masters) and then master of Data Science is where my head is at at the moment. Good to know it can be done from a completely different industry

[@AlexTheAnalyst]

JTProductions3 sounds like a good plan to me! Yeah, everyone’s journey is different for sure.

[@harrisliao2509]

I can see that you have great experiences in your role, can I ask what the next step is for data analyst as people always want to climb up the ladder, for example, a data analyst in sales team for analytics, how do they go to management, what is the long term goal for them?

[@AlexTheAnalyst]

harris liao hey, I actually just released a video today that’s called “Data Analyst Career Path” and talks about what to do after you become a Data Analyst. Hope that helps!

[@alaeddinhinnawi6674]

it might be hard for the employers to make a solid assessment of the candidates when it come to data analytics skills during the interview, and if candidate claimed that he has all or the majority of the technical skills needed, employer would feel doubtful about it.

[@albertsetiabudi9700]

I am on the process of switching careers to become a Data Analyst, how long you spend time learning it?

[@AlexTheAnalyst]

It took me about 4 months to learn everything from scratch. I normally was spending about 3-4 hours a day studying. Hope that helps!

[@nidoom]

Hello Alex, would it be a good idea for a person who is over 41 years old to change his career to data analyst?

[@RaulCPena]

I am 45 and trying to change my career into data science.

[@Rubberglass]

I’m 42 and considering M.S. or bootcamp to switch careers as well.

[@helovesdata8483]

I'm 43 and going into Python development

[@brianscarlett7771]

I'm 51 and working to Become a Data Analysis while currently working a full time job.

[@ssboxer]

I’m 42 years young making the switch.

[@anshumandcjoshi6424]

Hey, Alex. I'd like to ask how much time did it actually take you to prep for becoming a Data Analyst? Did you have to leave your previous job? If yes, were the recruiters apprehensive about the break in your employment? Full disclosure, I'm a CS graduate who finished college last year and was working for one year as a junior tech writer. I had to leave this job due to complications caused by COVID and now find myself at an impasse at my career. While I have started working as sports writer just to get an income, I am really looking to get into the Data Analyst profile but I'm worried about having little to no experience, and even though I've started to read up on the latest technologies in the said field, I realise that I'll need a few months to get the hang of it before I actually feel like I can work as an analyst in a corporate environment. So it's making me really anxious as to how badly the lack of work ex would affect me. So effectively, how many months can I give myself here before I make things complicated for myself? Any response you could provide would be very, very helpful for me. Please and thank you.

[@AlexTheAnalyst]

Hey, it took me about 4 months of prep. I didn't quit my full-time job. I just studied about 4-5 hours at night after work each day. That's a tough situation and I'm sorry to hear that. If you're dedicating your whole day to studying I think it's possible to do it in as little as 2 months, but maybe 3 if you're taking your time.

[@anshumandcjoshi6424]

@@AlexTheAnalyst Ah. So did you have to learn any other technologies like R, Python, Tableau that are usually associated with analysts? Also, when you were searching for jobs, did you specifically had to apply for jobs which required 0 years of experience and were considering freshers, or do companies consider exceptions as well given that they feel you have the right skills?

[@AlexTheAnalyst]

@@anshumandcjoshi6424 I was really focused on learning SQL at the very beginning. I eventually picked up Python as well. They mostly were helping me with finding 0-2 years of experience where if I was a good fit, even without the experience, that would be an option.

[@donnelly5757]

Big question. Would working as a medical billing and coder be a good way to get my foot in the door in this career field? Can it lead anywhere into the data analytics field? I ask this because my VA VR&R counselor is trying to sway me to go this route since the medical billing and coding program that my counselor would hook me up with also helps with job placement. At least from here I figure I would be working and would have a budget to pursue a masters in data science.

[@AlexTheAnalyst]

I think it would - if you know ICD9/10, claims data, CPT codes, etc that can be great domain knowledge to get a job as a Healthcare Analyst/Data Analyst at a healthcare company.

[@sunilveerendravattikuti3848]

Hi Alex, I need your suggestion to switch my career into data science. I'm a Python developer with 2 years of experience, basically into health care domain. I'm more interested in data analysis. Could you help me out with suggestion how to change my career? Should I have to apply for Entry level data analyst?

[@AlexTheAnalyst]

If you have extensive Python skills I would learn SQL and then try to apply to a mid-level DA position. That type of job usually can change fairly easily to a DA.

[@sunilveerendravattikuti3848]

@@AlexTheAnalyst Thanks Alex

[@kmart014]

Hi i just discovered your channel. Thanks for the helpful content. I want to break into the data analyst field but I have some reservations. I’ve never had a professional job. Just a few customer service call center jobs. I currently work in the public sector in a clerical LA County position. I want to break into the data analytics field but I am discouraged. I only have an associates degree and some university units towards a sociology degree. I have considered data analytics bootcamps. But I think it’ll be a waste of time if I still have no degree. Is it difficult to break into the industry with no bachelors?

[@salesforcedean3590]

Hi Alex, what do you do about letting people know on LinkedIn you’re seeking a data analyst job if you’re already employed and your company doesn’t know you’re looking to leave?

[@AlexTheAnalyst]

I probably wouldn't unless you're okay with being let go. If you make a public post anyone can see it potentially. I would air on the side of caution and maybe just direct message people for help instead of making a public post.

[@salesforcedean3590]

@@AlexTheAnalyst so a DM to recruiters then?

[@chuckt8246]

If you look at your profile in LinkedIn there is a box right under your title that says "Show recruiters you're open to work - you control who sees this." That link will walk you through a few questions so you can market yourself a bit without putting anything in your public profile. I would also suggest creating an account on sites like Indeed.com & Glassdoor.com. I climbed the ladder for years and just kept those accounts active. Every time I updated my resume on those sites I would get a bunch of emails from recruiters. There was a lot of junk to sift through, but I did find 3-4 good local recruiters that way.

[@victornguyen6261]

Hi Alex, what are some sites to practice sql and python for data analytics and what are some projects a beginner can do?

[@Andrew-rw6ye]

leetcode

[@monojitpal4643]

What should I learn to start my career as a data analyst... What is the basic requirements for this

[@AlexTheAnalyst]

You should check out my Data Analyst Skills Path and Data Analyst Career Path videos. I think those will answer all of your questions.

[@ABeardedDad]

Great video Alex, loved hearing you describe the interview process, and that it can take a long time. Very realistic, but also reassuring. When you said you studied lots online to pick SQL skills, what did you eventually put on your resume? Did you do any projects that you could use to show your actual skills? How did you decide that you had learned 'enough' SQL to start applying for jobs?

[@AlexTheAnalyst]

Geoff English all great questions! And I’m glad this video was helpful! I actually just made a video on this same subject except I went a lot more in-depth. If you check out my most recent video it should answer all of your questions! Hope that helps

[@cryptocovered4729]

What is the odds of me getting work/contracts without a degree? Just considering heading down this path now... Am coming from hospitality, (was self-employed up until the outbreak. Am business minded) so my background won’t do me any favours either. Thanks for your thoughts

[@AlexTheAnalyst]

I think right now it's low just due to the job market because of covid. It's absolutely possible, it'll just take that much more work put into finding that job you're looking for.

[@ipsna2758]

Hi Alex, I am trying to change my career into this field by self-learn.But on ground level I have been struggling with it for past two years,till now, I have struggled a lot to get proper SQL with data analysis tutorial. I am currently into database programming mainly with SQL but with Analytical SQL , it is different . I can learn the basics of analytical SQL but I am finding it quite hard to get HANDS-ON with Analytic SQL like windows func,etc. There is this one course in UDEMY where I have found the best course for SQL along with business Real use case for a data analyst - "Advanced SQL + MySQL for Analytics and Business Intelligence" BUT UNFORTUNATELY NOT ENOUGH TO USE OTHER FEATURES OF ANALYTICAL SQL IN TERMS OF BUSINESS USE CASE. Hope, you feel free to give me some insight on this. Thank you very much!

[@AlexTheAnalyst]

I've taken that course and I think it's great! I would also try to work through a project from start to finish. I have an outline of how to do this in my Data Analyst Career Path video which may help. I think that's a tough thing to do, but very important to take your skills to the next level. Good luck!

[@nolackin3801]

I'm currently studying economics and accounting at university. How could i get into data analysis?

[@AlexTheAnalyst]

Economics and analytics go hand in hand in many industries. Take finance for example. If you’re an economics major and can combine that with analytics you can be a financial or Data Analyst at a Financial institution. I recommend trying to take classes while you’re in school on analytics and databases. I also have a few videos on courses I recommend taking to self-teach Data Analytics. Hope that helps!

[@monicaosessaurit667]

Hi Alex. I watched this video because I am a recent biology graduate that wants to get into data analytics. I am currently working in my masters degree in data analytics but I have never had a job in this field before. Do you think that with a masters I will be able to land one easily? Thank you for your videos!

[@AlexTheAnalyst]

Well it definitely won't hurt! I think the market is still strong for Data Analysts even in this time. A Master's will get your resume will definitely be a plus, but landing the job will be determined a lot by your experience and skills. Congratulations on your education! I hope to go back and get my Masters soon. Hope that helps!

[@mukherjee22]

Hi Alex, I did my engineering in Electronics and then pursued my MBA in Marketing, and have been working in an Indian MNC as a Team Manager, now the job that I do is redundant and straight-off boring as there are no technical skills involved, except for a bit of Excel! Also, the money is really less. Anyhow, I have decided to switch over to Analytics as my career path because of my recent affinity towards numbers/data/Statistics, now because I have Zero knowledge in programming at the moment, I am focusing heavily on brushing up my Statistical knowledge post which I will be taking courses to learn SQL, Python, Tableau etc. to land a job as a Junior Data/Marketing Analyst, and then progress slowly in the coming years towards becoming a Data Scientist, obviously that's a little far-fetched for now. So, what would be your suggestion for me to secure my career transition? Any advice would be highly appreciated, Thanks in advance, Alex! God bless you and your family, Much love and support from India.

[@benjamin4206]

i can tell you are a great guy...i subscribed. i am a math teacher. should i consider data analysis or software development?

[@AlexTheAnalyst]

Thanks for subscribing! I think you can try either and see which one you like better. With a math background Data Analysis/Science would probably be a more natural transition as this field is math heavy sometimes.

[@naumanshafique1745]

Hi. First of all I wanna say you my thanks for bringing us so informative videos, I found your channel couple of days before and I see you are also new on KZbin as I am on SQL, so it really motivated me . Secondly I wanna know that how could one feel that what knowledge of SQL he has would be just enough to get a job as a junior level data analyst . Thanks

[@AlexTheAnalyst]

Hey Nauman, that’s awesome that you’re getting started and especially with SQL! I think that’s one of the most important things to start out with. In my opinion for a Junior Data Analyst position you don’t need a ton of experience with SQL. If you know the basics and can speak knowledgeably on the subject you should be good. To be more specific I have a “SQL basics for data Analyst” series on my channel that goes into the things I think you should know. Practicing those things and becoming familiar with them should be enough. If you want to know even more than that I also have an “intermediate SQL tutorial” that shows a little higher level of SQL. I hope that’s helpful! If you have any other questions feel free to reach out to me on LinkedIn or my email at [e-mail]

[@shivanityagi6646]

Hi Alex, I am a software developer for about 7 years currently want to transition to data analytics or Business intelligence profile. Currently I am pursuing MSc Business Analytics, wherever I am sending resume for BI or data analyst they are getting rejected. I seriously don't understand what is the problem. Could you please give me some advice.

[@pearlcharles4934]

Thanks for the video Alex. How can I transition to a career in data analysis as a communications and PR specialist although I have an ample knowledge of power bi but planning to take courses in Sql.

[@AlexTheAnalyst]

I think you really just need to get the right skills and push hard to get your foot in the door. SQL, Excel, and Power BI/Tableau is really all you need for an entry level job. Once you get your foot in the door you can always pick up new skills and progress. I have a few videos on what skills you need, how to write your data analyst resume, and what courses to take to get your skills. Hope that helps!

[@samrizvi92]

Hey man! Great videos. One question though which course to start from? Is google data analytics course on coursera good to start from?

[@gulshanpatleofficial9018]

Hello Alex I am Gulshan I finished 6 months data analytics course from Springboard.Worked on some projects using python ,SQL, Excel ,power bi and now I am looking to get job.I domain is marketing.and looking for entry level job in data analytics.please help me what should I do because I lost my job in this pandemic

[@AlexTheAnalyst]

Gulshan Patle Official honestly it sounds like you are ready to start applying and get a job. I would reach out to recruiters and see how the market in your area is and try to get some interviews!

[@gulshanpatleofficial9018]

Alex Sir how kind you are I thank you for your kind words and reply.you reach out to everyone.please guide me Sir [e-mail]

[@obianujuikechukwu7939]

Hi Alex , I have being watch lots of your videos , thank you for all you do. Pls can you provide the list of recruiters to work with. I have being applying for a data analyst role but nothing is coming forth . It’s depressing . I need your help with this

[@sumitloomba6825]

Hi , I am in the same position, I just finished my online sql course and ideally looking for a first job in data analyst. I have worked as database administrators (not technical) just admin jobs like keeping data clean etc. I would be great ful if you help me with some tips what I should do next, should I learn something else as well to 8mprove my chance of getting job. I am happy to work volunteers to gain some more experience if required. Another question: I want to keep practicing sql so if you can give me an idea on what platform should I use to practice so I can get better day by day.

[@AlexTheAnalyst]

Very cool, Sumit. I think you're on the right track. I would continue to learn SQL and try to pick up some data visualization tool. I would look into Python, Power BI, or Tableau. These are all great places to start. For learning SQL you can try Khan Academy which is free. I found courses like Udemy to have some great classes that are pretty affordable and provide a good road map to learning SQL and improving steadily.

[@sumitloomba6825]

Thanks Alex, I used an online course from udemy to learn SQL. My next question is how much SQL knowledge is good enough to apply for data analyst role. Tbh I am struggling with variables and stored procedures. is that a must? I have decent understanding of queries using aggregate functions, join, subqueries, create,update and insert statements. I appreciate more I know the better but thinking I want to distribute my time wisely instead of just focusing on SQL.

[@judypingmccormick3904]

Hi Alex, if you think getting the first Data analyst job is very hard, then I think I have no chance. Should I save the heart ache, but I am already proficient in Python, SQL and Tableau, and 25% completing 'Google Data analytics Professional Certification'. My family does not rely on my income, work becomes hobby, so the pressure is off. Maybe you should set up a DA career coaching club. cheers, Judy from Melbourne, Home to Australian Open Tennis

[@sergioramos3437]

Holy shit you're in Dallas!? I'm in Fort Worth! Currently taking an IBM data science course .. had previously taken a course on Google sheets and fell in love with it so I thought I'd take a shot at being a data analyst as I'm between jobs right now.. I'm also an artist, and was thinking the domain knowledge would make me a good fit for something in entertainment... Any advice on how to land something like that out here?

[@AlexTheAnalyst]

Hey Sergio, super cool! My advice would be to really work on your resume and work with a recruiter.

[@sergioramos3437]

@@AlexTheAnalyst thank you!do you have any ideas of what sort of job titles or companies would be at the intersection of entertainment and data? Or is that a question better suited for the recruiter?

[@keshshakya4228]

Hi Alex,, i graduate from college back in 1998. however i have never worked on same field , I have been working in Retail store for last 2 decades, recently i took class of Sql and BI, i am just not sure about how to land a job and have a good Resume ,, if you can help i will really appreciate it thanks

[@AlexTheAnalyst]

Hey that’s super cool that you’re learning those skills! I have several videos on creating resumes, building skills, and interview prep that I think may help 👍

[@puneetpandit706]

Hello, Alex. I am Punit Pandit. I thinking of making a career switch from Electrical Engineer to Data Analyst. I have just started up by taking Pyhton for dummies book as a course. I greatly appreciate the online courses you shared in the description. So I am an Electrical Engineering major from the beginning with no professional work experience whatsoever and by seeing the requirements for Data Analyst jobs, I am getting a feeling that I do need to get enrolled in a Master in Data Science program. What do you suggest?

[@AlexTheAnalyst]

I would try to get an internship or an entry level job before going and getting a Masters. It will be difficult, but not impossible. Experience is your best asset!

[@AngelMartinez-jl5hv]

Hello, I recently graduated with a major in finance and a minor in accounting and I’m wondering what steps I should take to become a data analyst? Thank you.

[@arnoldgarcia2379]

I'm a computer systems engineering student and I'm ready to be a data analyst intern however I cant find any intern position as of now. I can only find internships for software developement. Do you think that if I take the software developement internship it could be easy for me to transition to data analysis? I've seen a lot of similarities in the requirements for both positions

[@AlexTheAnalyst]

I would say yes since there are some things that overlap, but also because SD work is very technical and that helps show your skill level when trying to transition.

[@Oceanbluewhale]

What is difference between SQL and Rapid SQL?

[@dilipghuge7226]

Hello Alex, How connect with OR follow you through linkedin?

[@AlexTheAnalyst]

Linkedin works great!

[@rialumba5474]

@@AlexTheAnalyst what should I put in my resume to attract recruiters on linkedin?

[@HBCertified]

Do you know the software MicroStrategy ? Is it data visualization? In my current job I got access to it where I can pull data and use it to analyze . Maybe this might help me transition to a data analyst role as I’m currently an engineering analyst role

[@unknownperson-fl7lx]

Hello Alex, I have experience in Mainframes Technology and I had worked in a few projects where SQL was used, but now I have 5 years of gap in my career due to some personal problem and I am exploring the new tech which I can learn to start my career again. Here is my question, I am not good in programming so it is fine to make career in Data Analyst? And how long does it take to learn all the required skills to crack interviews to get the job?

[@AlexTheAnalyst]

You can become a Data Analyst, but your jobs may be slightly more limiting if you don't know any programming. Again, it's possible. I would estimate it would take someone 2-4 months to get up to speed to be job ready. Some have more time to devote than others and some learn faster than others. Hope that helps!

[@mercantilism954]

This might not be an important question, how many jobs did you apply to land the first job? I’ve applied few but I feel like I should apply more

[@AlexTheAnalyst]

When I was just applying on job sites like LinkedIn and Glassdoor I probably applied to several hundred without much success. With recruiters I applied to maybe 20 and got several interviews.

[@mercantilism954]

Wow, that’s a lot. Thank you for answering my questions. I’ll apply more internships

[@AljIsHere128]

Hey Alex. What was your first video in your channel so I can try to watch in order? I am curious about Data Analyst and I actually like SQL but not brushed up proficient yet. I am also the weirdo that likes Excel and refreshing skills in that for starters before jumping into say a Tableau or Power BI. I know the struggler will be real with Statistics but I am willing to push through with it (LOL). Any help is appreciated.

[@abdimohamed9178]

What is the difference between data analyst and big data?

[@EnlightenmentThroughDivya]

Hi Alex, I have been following you since long time I really like your videos and you content helps. I have been trying to switch my career to data analyst for more than 1 year now I have reached on very low moral of only I am not going to make it. I have learn SQL, Tableau power BI basics of python.. Still while applying for jobs I feels skills are less and that lower my confidence. Please help and guide

[@JGTB95]

Hi there Alex. I'm PhD student focused on basic research on the biomedical field (rodent models). I'm used to process data about my research purposes and have a considerable knowledge about medicine(mainly epidemiology, pharmacology, statistics). I'm interested in the heath data field once it has many jobs opportunities. I'm starting to training my skills on SQL, and already i have a good bases of excel and data visualization. Do you think that my background as basic researcher is a considerable feature compared to someone that is starting from the beggining?

[@AlexTheAnalyst]

It can definitely be a great selling point! I work with a few former medical researchers and their experience and knowledge of healthcare is why they're so good at what they do.

[@kostasvalanidis7560]

Hi Alex, Iam a nurse. I want to switch my career to health care data analysis. Is it possible without previous experience?

[@falguniverma3024]

Hi, i have been working as Business Analyst now i am looking for transition in Data analyst. I have applied in quite a few companies but didn't getting any calls. I am learning SQL, Python , EDA visualization. Can you help me with resume building

[@AlexTheAnalyst]

Hey Falguni! I do have a few videos on resumes and one specifically on how to create a Data Analyst Resume if you haven't seen that already! :)

[@falguniverma3024]

@@AlexTheAnalyst thanks for replying Alex! :) I will go through them ..and update my LinkedIn and resume accordingly..and share with you for review.

[@romeorel1679]

Thanks for the video. It's really inspiring! I wanna ask what kind of advices would you give to someone who is willing to be a data analyst. How long will it take to learn? I want to mention that I am just getting started with Python, hence i don't that much about programming. Thanks!!!

[@AlexTheAnalyst]

Well thank you for watching! To be okay at SQL with really knowing the basics it took me about 2-3 months. To get to where I am now which is intermediate to advanced I would say it took me about 2 years of using it in an actual job setting. Once I started using it for work everything became easier. Learning Python took a little bit longer for me because I had never done any type of programming either. It took me about 4 months to really get the basics and about 6 months to start building applications and using it in a work environment. If I’m being really realistic about the timeframe of how quickly someone can become a Data Analyst I would say someone who is really determined and willing to put a lot of time in could do it in 4-5 months. That includes learning the basics of SQL and Python, applying for jobs, and accepting a job. My big advice is watch my videos! 😁 I’m just kidding. The big advice is make a really good resume. Get SQL on your resume when you’ve learned the basics. Work with a recruiter to find your first entry level job. Once you have your first job it makes it so much easier to find other jobs because now you have experience. Getting the first job is by far the hardest. Hope that helps!

[@mohammedmahgoob390]

Greetings Alex, I'm 33 and I have passion to shif my career to data analyst. I have bachelor degree in nutrition and food technology and I'm not interested anymore, so kindly advice would it work... 😞

[@haritaharish478]

Hi, TQ for this video. Really it gave lot of inputs for similar kind of profiles....can share anything abt. certifications for data analyst jobs.....

[@AlexTheAnalyst]

I actually have an entire video dedicated to certifications!

[@jimmyjee1984]

Hey Alex. Thank you so much for all your crystal clear information. I have done the weirdest academic accomplishments. My Bachelors degree is in Geography. And I did MBA concentrated in MIS. And now I want to become a data analyst, so taking some online courses to get familiar with SQL and Pandas. I’m so sorry to ask you, but do you see any hope that a company find me as a good candidate of entry level data analyst. And I’m 34 years old...

[@AlexTheAnalyst]

I definitely could see someone hiring you. It sounds like you're smart and motivated. If someone picked you up as an entry level data analyst I'm sure they would get quite a good employee! Your experience in the workforce as well as education should help you out a lot!

[@jimmyjee1984]

Alex The Analyst Thank you so much for kind words. I was actually discouraged by the fact that there is zero connection between my BS and MA. I will try my best to become a knowledgeable analyst like you!! I just like your channel so much!!

[@AlexTheAnalyst]

Jimmy Jee so glad to hear it! Good luck!

[@phelipecarmo2608]

Thank you so much for this video, I am looking to get into a data analyst career and I do not have any experience, I do have a degree in Business, I am thinking about doing a 10 weeks course in Data Analytics, do you think it would help me to get a job ? thank you so much

[@AlexTheAnalyst]

I think a course may catch you up to speed on some of the skills needed. I don't know if that alone would be able to get you a job. It is possible given your degree, but you need to be able to show a potential employer that you are worth hiring. Once you feel that you're ready for a DA job I recommend watching my video on my DA resume. It provides some good information on what I sent with my resume to employers to get jobs. You can also create a website to display dashboards, code, etc. Hope that helps!

[@celestinechike3048]

Good evening sir, please can you state the course you studied in college? I studied physics & I’m trying to change my career path but I have zero knowledge or experience about this courses (accounting & finance, data analyst or business analyst)

[@1Love-4-ever]

Can I get a job as a data analyst without experience

[@aadityasingh3381]

Hi Alex. I'm currently transitioning into becoming a Data Analyst. But I'm working in a different field. I have completed my degree in Business Administration. However, I have huge gap in my studies because of personal reasons and so I'm trying to study via the resources provided by you and fill the gap and for which I'm really grateful to you. But I still don't feel confident in what I have learnt and seeing other people with better degrees/knowledge makes me wonder do I need to go for a full time degree in order to get a proper job?

[@Tajrin1290]

I am in the same situation as you and need advice on this

[@bipanatiwari9516]

Hi Alex i have completed my bachelors degree on nursing science but i am really interested to work as data analyst in future.. can you please suggest me any pathway from where i can start learning...

[@AlexTheAnalyst]

Very cool! I would focus on learning the skills first and then later when applying you can try to leverage your degree to potentially get into some type of healthcare domain focused on data. I have several videos talking about my favorite courses as well as videos talking about Data Analyst Career Paths and Data Analyst Skills Path. Hope that helps!

[@bipanatiwari9516]

@@AlexTheAnalyst okay thank you soo much for your suggestion..

[@alexalanis1510]

Hello Alex, I recently graduated in the career Industrial Engineering and Management in Mexico, I’m really interested in data analytics, so what’s your opinion about this area in Mexico? and what can I do to be a data analytics?

[@nikhithasagarreddy]

Hii Are Seaborn and matplotlib enough for visualization?

[@AlexTheAnalyst]

Those are great tools and are often used in the actual workplace! I would also suggest learning Pandas if you haven't already as they have visualizations also and also learning ggplot and plotly. Some other good options to expand into later on.

[@mri5445]

What salary does this field max out at? And also is the long term outlook for this job good? Thanks in advance

[@AlexTheAnalyst]

Hard to say what the max is - maybe around 200k at certain large companies for an actual analyst job. After that you can go into management and make more. Those are rare jobs and are most likely in Silicon Valley for those salaries. The long term outlook is definitely good - I don't see Data Analysts declining in value and demand in the next 10 years.

[@miguelalvarez6450]

Hi Alex. Looking to get into this field. I am coming from the hotel/hospitality sector and wondering if Data analytics is worth the career change?

[@AlexTheAnalyst]

It is if you can get the right skills. With your domain knowledge you may be able to find something in an analyst role in the same domain.

[@miguelalvarez6450]

@@AlexTheAnalyst I really need help being pointed in the right direction. I truly do not want to waste time and $$$.

[@fardaddanaeefard8247]

Hi Alex! Hope you're dowing well I'm a student at human Genetics and I'm very passionate about learning and getting into DS and DA, but all i have basic knowledge of R and python What can i do to become and expert in this field?

[@AlexTheAnalyst]

Hey Fardad, I recommend watching my Data Analyst Career Path video - I think it’ll answer a lot of your questions 👍

[@P-p-w9w]

Hello Alex, Thank you for this insightful video, I am a pharmacist with some experience in pharma sales and marketing. I started learning Python and SQL 4 months ago with Datacamp, udemy and youtube to become a data analyst. Am through with the Datacamp data analyst with python course but I feel I am not job ready. This is because I don't have any major data analytics project in my portfolio and most job i see require an educational qualification in computer science, or statistics . Please what advise would you give me and can my previous pharma job experience play any role in getting my first data analyst job. Thank you for your anticipated response.

[@AlexTheAnalyst]

Hey Kikeme! Let me start by saying you're already doing awesome. Learning SQL and Python are a fantastic first step to making the career change. As you saw in this video I didn't have any experience either and no direction. If I were to go back and do it all over again I would have done things differently - this advice I will give to you. Your knowledge in the healthcare/pharmaceutical industry is worth a lot. You just need to know where to look to utilize that. I work at a pharmaceutical company now and we just want people who know the industry and have the right skills. Domain knowledge is very important. If I were in your shoes I would continue to learn SQL and Python - at least learn the basics. Try to get an entry level job at something healthcare related (if you are still wanting to be in this field) since it will be the easiest to get since you already have healthcare knowledge. There you will learn a ton in a production environment. In order to get that entry level job be sure to write a great resume and really highlight your skills and pharma experience and try to quantify it and make it more data analyst related. You're right, projects help a lot. I recommend doing a project where you take prescription data and perform analysis on it and make visualizations. Nothing crazy fancy or hard, but something that shows you have domain knowledge and the right skills. Once you have that set up a website or a GitHub (which is free) and add that to your resume. You can also send sample scripts of your SQL and Python with your resume (this helped me land my first 2 jobs as a DA and they loved it) - this will show them what they can get with you. Even if you don't have the experience they may see that you have the right skills and hire you. Hope that helps!

[@P-p-w9w]

@@AlexTheAnalyst thank you so much Alex, your response was really helpful. Please will keep you updated about my progress and how you were very instrumental in landing my first job as a data analyst.

[@parthjoshi687]

Is graduation required in computer field for applying data analytics course?

[@AlexTheAnalyst]

Not at all, there are lots of different degrees that you can use to get into this field.

[@carmencurca8494]

Hey Alex, I cannot believe I found your videos on KZbin!!! I was having such a hard time finding some real and relevant information on this subject as most of the people talk about data science. Since you've been enough to offer you expertise in helping data analyst newbies, I wanted to ask your opinion regarding my case. I have been my whole life a travel specialist (airfares and ticketing specialist) and have no other experience whatsoever in data analysis. Since the whole world changed during the past few months, I am now looking for a second career, and I have always wanted to work in this field, but since I don't any education (my bachelor degree is in philology) or experience I always hesitated to try. However, I have already started learning Python a month ago and will focus on SQL also. Given your knowledge and experience in this field, do you think I have any chance of getting a job after taking all the learning steps you recommended? I have many communication and customer relations skills, as well as working with many software related to my job. Thanks a lot for proving all this extremely helpful information!

[@AlexTheAnalyst]

It would be a tough career shift, but it's definitely possible. I think the biggest thing is being able to show you are competent as a Data Analyst . If you've spent many years as a travel specialist it can be hard to show the switch. A big thing for you will be a portfolio that will highlight your skills that prove you know what you're doing.

[@carmencurca8494]

Thank you for your advice, very much appreciated. I know it will be very challenging for me, but I do like challenges 🙂so if there’s even a small chance to succeed, I’ll give it a go and try it. Thanks again, you’re doing a great job here posting all these videos.

[@AlexTheAnalyst]

Carmen Curca you got it! And thank you!

[@alejandroj5249]

maaaan, if only was that easy, to learn a skill + putting it in your cv and apply to job and being visible to recruiters. I have applied to nearly 80 internships and only got 4 interviews with 0 rate of success since they mainly look for engineers or technical studies

[@karrimomer]

Hey man really glad I found your videos, I just graduated college last month with an information systems major and have been applying to a bunch of junior data analyst positions, I haven't had an internship or any experience in the field so sometimes i feel under qualified. Would you have any advice you have for a recent graduate trying to find a job?

[@ramiriman3051]

Hello alex! I am currently a last economics student and started taking an introductory course after my university opened a minor in data analytics. Starting learning python online, what do you recommend me doing to make my resume more attractive when starting to search for jobs?

[@AlexTheAnalyst]

Very cool! Since you're just starting out you can look into a Certification (I have a video on this with some recommendations). I would also build out some projects. That is even more important than certifications in my mind.

[@Genojurzedd]

Hello Alex, I am an Engineer from Aviation industry (Singapore) and recently really interested to switch my career into Data Analyst. I have no basics of any analysis tool, or maybe only Excel for basic daily use. May I know what will be the first skill you suggest to develop in order to switch into this career path and get an entry/junior level Data Analyst job maybe in future few months time? Thanks for your video and it's truly inspiring and motivating me in doing this.

[@AlexTheAnalyst]

Hey ZK, I think that SQL is the biggest skill to learn to get started quickly. I think that this is the best skill to be able to get an entry level job. I have a lot of free resources in this video to help learn SQL: kzbin.info/www/bejne/l6HTgHmme5ejfMk If you're wanting a paid course there are lots of great videos on Udemy and Coursera that I've taken and loved. I think these will help you learn a lot faster and be more proficient in it. Here is a video of my recommendations: kzbin.info/www/bejne/eGO2gXZpjN9kiJo Both are great options, but you just need to know your learning style and how quickly you want to advance your skills. Hope that helps!

[@Genojurzedd]

@@AlexTheAnalyst Great! I will try them out. Thanks again Alex, cheers!

[@alecstuckeyguitar]

How long did it take to get the grasp on SQL?

[@AlexTheAnalyst]

I think it took me a lot longer because I had no direction. It took me about 3 months and even then I look back and realize I didn't know much. To be job ready I think you can learn it in 1-2 months if you know what you need to learn.

[@alecstuckeyguitar]

@@AlexTheAnalyst Thanks! I have a quick question. I want to possibly work as a financial analyst. I have a Bachelor's in business, and no analytical experience. I have the opportunity to go back to school for an MBA w/ Data Analytics focus. It does have those core classes in analytics, but I might also have to teach myself some stuff on my own. But I have 4 years banking and financial sales experience. Do you think I could go back to school, get that degree, and transition to a financial analyst position and somehow leverage my finance background, even though I am going to be newer to the analytical stuff?

[@AlexTheAnalyst]

@@alecstuckeyguitar I absolutely think so. That's actually a really good degree to get for you situation! I do think the courses you take as part of the data analytics focus will by very helpful. I've looked into that myself and I think it's a great idea!

[@alecstuckeyguitar]

@@AlexTheAnalyst thanks, that makes me feel better lol. The one thing that worries me is the MBA has about 5 classes I'll take on analytics. I am worried that's not a lot, without any prior analytical experience. Do you think I'll have to try to add in a bunch of my own learning, on like Coursera or something, to supplement the degree? I just really want to get away from sales (I'm a financial advisor in training) and make a career change. I'd rather work with the numbers and stuff and not have just a straight sales job, if that makes sense.

[@AlexTheAnalyst]

@@alecstuckeyguitar You definitely will, but hopefully the courses that you do take will give you a good foundation.

[@MrMelvinmoore]

Hi Alex. I wanna switch to become a Data Analyst. Would you advise against getting a diploma got it vs being self taught. Does not having the certificate/diploma/degree for it hamper your chances?

[@AlexTheAnalyst]

Not having a bachelors can hurt you since a lot are of jobs minimum requirements are having that. I think in the long run having a bachelors is best practice and will be more lucrative in the long run if you're able to get a good degree and land a job. It can be hard to get started with out it, not impossible, but difficult.

[@ewajarmoszuk8823]

What if my BA is not related like arts?

[@sanjukta93]

Hi Alex, I have been following your channel for quite sometime and you are doing an amazing job 😊. I am from India and I have 6+ years of experience in data analytics(sas, sql and a little of tableau). I have been trying to get a job in europe but I dont get call backs. Can you help please.

[@johna9245]

Hello Alex , ty for sharing your knowledge and exprience, im without a degree and thinking about learning to be a data analyst , im 37 years old, i spend hours on the computer from home working customer service but im not great with computers but i getting better, would like your opinion about going into the data field in my age(37) and also is it possible to work from home as data analyst. thanks :)

[@AlexTheAnalyst]

Hey Jony, there is a huge market for remote Data Analysts right now (for obvious reasons). So if you want to work from home as a Data Analyst now is one of the best times. I don't think age is as important as relevant skills. With you being a little older you may have a lot of domain/industry knowledge in a specific area that might be very valuable. If you learn the right skills and combine that with your domain knowledge it's very likely you could be a successful analyst.

[@johna9245]

@@AlexTheAnalyst Thank you so much, i have seen an add from a compony that works with Yandex that offers a course that you pay for it only when finding job and making x money, do you think its legit? or should i learn by myself with the free stuff online? little embarrassing to share but at the moment i struggle with working even with excel but i know its mostley from lazyines and i didnt need it to much in the past. so should i learn the Excel good first or it dont matter? i appreciate you taking the time to answer questions. be blessed :)

[@AlexTheAnalyst]

jony flony if you add a link below I can take a look at it, but as a general rule of thumb those types of things are not worth doing and are mostly scams. I would start with learning online for free. I have a whole video with resources for free courses and websites that you can learn from! I think starting with Excel and SQL is the best way to go.

[@jasonstorm5726]

Alex new subscriber. I have a question. So I am 38. I went to school for graphic design years ago. But I am currently a painter at a school I just started and after a year I will get free tuition to any 12 state schools here in MD. I really want to be a full stack developer but heard that it is much easier to get your foot in the door thru data. So I guess I am asking for any advice. I want to take advantage of free college a year from now. But I am slowly teaching myself to code now. I was learning HTML and CSS but just recently switched to SQL. So yea any advice??

[@AlexTheAnalyst]

Johnny Storm I would agree that full stack developers can have a tough time getting started because the skill cap can be very high even for entry level. If your wanting to go the Data Analyst route I recommend SQL, then Tableau, and then Python. I would take courses on Data Analysis/science as well as taking courses on databases and data structure.

[@jasonstorm5726]

Alex The Analyst hey thanks Alex. Hey so I read different things about the job market for full stack and analytics. In a couple of years is there going to be a bigger demand for these positions or no? What do you think?

[@dikshavikas873]

Hi Alex I am working in telecom company as network engineer. How should I manipulate or get the recruiters attention towards my resume? If I do get interview opportunity then should I mention about my last domain or should mention something like using excel,SQL in my last company?

[@AlexTheAnalyst]

All of the above. Structure your resume to highlight your skills that are relevant to analytics. SQL and Excel are a great way to start! Then in your interviews really highlight those skills and talk about how you work with them.

[@mehmetoz886]

what kind of data analyst are you ?

[@AlexTheAnalyst]

I work in Healthcare. I work with clients to get their data into our warehouses, ETL, and create reports. I work a lot in SQL and Azure. Let me know if that answered your question or if you were looking for something else. Thanks for watching!