That’s what happens when TH-cam wants more watch time for more adds but then you get thousands of youtubers who stretch out a easy ass 4 minute video into some stupid shit
@@AlexTheAnalyst you you have an extra one 😅. Biii😅 😅😅hi Thank yea yea yea using your your under my order for for the the time thank thank love for my 😅😅u I’m u😅 love love 😅unjani I’m so 😅b I up for my my. Uiiiiiiiiii😅😅😅😅uI I’m us I o miss it and 😅😅buy hi hi iiiibi I hope you have you have you have 😅ui uuiu uiuubui I hope you’re unjani too iiiibad iiiito I’ll just have have you and uiiu u but Iii bI’ll ui the whole whole thing I I guess guess guess Uyaphila iI’m I’m sorry but you you are not unot not really sure 😅😅juice uiiand uyou uiuuiyou you iubneed do that that uh I miss my uui and 😅uuiu uiiiunjani uiiii. Bb the whole whole uunjani uuiuuuiiiand uiiiu😅 uiuiiuiiii hi I hug building uiia huiiiiuuuii is my umy iii huny u iiiiiiiiui oh uuuuuuiiuhurry iii bbbuibbiiiu iuiiiiiiuiuuuiI’m I iuuiuiiuiiihuuiiiu Uii😅bbibuuiuiiuiuiuuiiiiiuiuiiuuiiuiiiiuuii😅uuuuiu I’m huiiuuuiii go get a haircut 💇♀️💇♀️ I’m I’m not at uiat at work work I’m I’m uuui😅 I have A A A uuii in u uuiu uiiiii in a good 👍 but I’m sure sure sure will uiwill have have it it will help help uiiiiiiiiiiiiiiiiiiiiuiuuuiiiiiiuiiiuuuuuiiiiiiiuiiiiiii uuiuuuuiuiiiiiuuuiuuiiiii in case I use the the car 🚗🚗 I’m using uthe uiiiiiuiiiiiiiiiiiiiiuiuuuiiiiiiuiiiuuuuuiiiiiiiuiiiiiiiiiuuuuuiiiuuuiuiiuiiiiiiiiiuiuuiiuuuiiiuuiiiiuiuiiiuuuuiiiiiiiiuuiiiiuuiiiiiiiiiuiiiuiiiiiiiiiiiiuiiiiuiiiiiiiiiiiuuiiiuiiiuiiuuuiiuuuiiiiuiiiiiiiiiuuuuuiiiuiiuiiiuiuiiiiiuuuiiiuuiiuiuuiuiiiiiuiiiuuuuuuiuiiiiiiuuvbn in
hey alex, im 28 now since i saw your video, i realize its never too late to switch career into data analyst field, and your video guide me to my goal in future, thanks alex, keep goin'!
Thanks a lot for this Alex. It will be also helpful to add programming languages and tools needed in each job description. For example for data setups and visualization one could learn Tableau, I am not sure I know what to learn for other descriptions. This video is very useful.
Thank you so much for the Data Analysis job description. I'm currently taking Data Analysis course through Coursera. There are 8 courses total, and I'm currently on course 4.
@@stlouie88I’m still on course 4. I had to pause for a bit because I was dealing with some health issues. After I finish all 8 courses, I plan to brush up my resume and start applying for a Data Analytics job.
@@maddiermah5875 I hope you are fully recovered. Can you please let me know if you are able to complete the course and obtain a job of your choice. I am curious as I am looking into different prospects of Data Analytics.
Keep in mind not all companies have programmers to do the ETL work. I'm a Sr. Data Analyst and I'm responsible for the entire process from start to finish. Sometimes Data Analyst also perform the workloads of Data Engineers, Data Scientists, etc.
For the role of the programmers mentioned in the video and this comment, what is their job description? Are they data engineers? Database engineers? Do they design the company websites to collect the data? Any and all expansion on this would be very helpful.
Glad I saw your comment. Just about to start a job and from the interview process, they want me to cover all these roles! I will see where it takes me anyways. Hope it's all going well at your end x
Funny story - I have a bachelor degree in Computer Engineering and I am specializing myself in Big Data. I went on an interview for a traineeship related to something completely different (more of the programming type). The interview went very well but they noticed a passion and predisposition to data in the way I talked. So now they want another interview with me next week directly for a data analyst junior position. That's why I am here. I didn't request the interview, it was offered. So, now I am trying to understand a little bit better the job and requirements.
i am at a point where I am no longer paying for more college... between this and coding, I should be able to pull it off without. Udemy seems amazing... I have been doin that for about 2 weeks... LOVE IT... seriously see myself being a lifetime member.
Hi Alex. Thanks so much for taking the time to do this. It's super helpful to us aspiring Data Analysts. And like your random jokes, comments, intro of your dog, etc. These all keep things light and interesting 👊🏽
Hi Alex, I'm happy to see you respond to viewers regularly. I recently graduated with a BS in International Business and would like to pursue a career in data analytics, probably in the fields of business, marketing, or economics. Because of the way the programs at my university's business school are laid out, I could go back and do 2 part-time semesters, while continuing to work my current job, to receive a BS in Information Systems with a focus in Business Analytics. This would be cheaper than most of the boot camps I've seen, and seemingly from a more legitimate institution. Is this something you would recommend? I'm not sure if the same knowledge/experience could be achieved/demonstrated through a cheaper or easier channel. Much love from North Cack, and keep up the good work.
I think in your case both options are viable. I think preferably you would get a BS in IS, but if that time is not available a bootcamp may be a good way to go!
Maths and statistics!!!! What level of competency is required. What area should a none maths savvy person focus on in maths and statistics.. this will save me a lot of time
Hey Alex a few of my seniors who used to watch ur vedios in college are now working as data analysts in Tata Consultancy Services Deloitte Wipro and Cognizant. Im in my final year of Bachelors in Computer Science with AI & ML. I want to become a data analyst too i stumbled across your channel starting my journey im just not that good at math but i will grasp all of basic stats and stuff. I have been learning ML and Python I love python. Let's see where I land in few months as companies come on campus to recruit me for jobs. Good Content.
Love the videos Alex! I have my first interview for a Data Analyst position tomorrow, I've been utilising your videos to help prepare myself and they've moved me from a position of terror to relative ease. Thanks again!
I just watched this video today, I gotta say wow, you're amazing.. I'm currently in my 2nd year doing my Bachelors degree and I'm hoping to be a data analysit some day.. I will go through your videos and understand/know what's best expected of me.. Thank you for this videos good Sir..
you are doing really well to help IT people.....giving that knowledge for free is the thing that no one does....I really appreciate, thanks a load and god bless you....
Just found your video because I just recently applied to EdX to get the certificate for Data Analytics Basics. I have always loved problem solving, brainstorming and analyzing everything. So at the age of 44 with no previous experience or college of any kind, I feel like this is the perfect career for me! Thank you for your information!
Wow!..Thank you for this ! Love the info. I am currently working in a bank in Finance group were I learned to use SQL for data extraction and MIS reports. Now I am starting to study and learning Python. Am I in the right track as well?.haha! I want to shift to a data analyst role too.
Just a bunch of words that mean nothing to an outsider. You mught as well be speaking Chinese. It would be much more helpful to show people what a data analyst does.
Taking first semester of Data Analytics now. It all makes perfect sense. Maybe level up on the topic, and get back to us. Or perhaps consider an alternate career.
Hi Alex, I’m a new subscriber New to data analyst in general, I’m a Graduate in finance but I would like to pursue a career in data analyst. I’m looking forward to watching more of your videos.
Hey Alex, thanks for this video. About the requirements for data analyst, would you say a person changing careers without a bachelor's in math, statistics e, etc is expected to find it difficult to access the market? I know that you have done such a thing, but I would like to hear your current perspective on it.
I have a bachelor's in social science and an associate's in accounting, looking to transition into data analytics with the Google Data Analytics Certificate to pick up programming languages. What do you think of those three qualifications together to land an entry level job? Side note, I definitely plan to do a Python course after the cert so I can work in it as well as R
New subscriber here! Anyhow, I’m also a Data Analyst in the healthcare industry, and I agree with Alex over his summary on what most data analyst do. For starters, learning a database language (like SQL) is vital as well as being familiar on basic programming languages (like XML, JavaScript, Python, etc.) and reporting and analytics tools like Power BI, Tableau, Zoho, etc. It’s also important to have basic understanding over best practices to implement data quality and security, especially when you’re dealing with sensitive data like peoples’ financial and health information.
That's true! I think XML and JSON, both of which are semi structured data, can be a bit more complicated for beginners in the actual ingestion phase. Definitely a great are to know. And for sure, the healthcare industry especially has a lot of sensitive data - great to know data security especially if you don't have a DBA or Data Engineer on you team. At my company we do so this does not fall on the Data Analysts as much. Thanks for subscribing! Hope you enjoy the content :)
Hello. I want to get into data analysis in the healthcare field but what I wanted to ask is it a good step to take medical billing and coding classes also?
I hold a statistics degree, currently doing a post graduate diploma in data analytics. I have been teaching myself Sql which was so much fun i must now moving to Python then i'll learn some basics in power BI and start applying for jobs next year. I'm so excited to start a career in data analytics. Your video was so helpful. Thank you❤
Thank you so much for the video. This channel is a goldmine of useful information and I hope you get more exposure soon :)! Question: Would you consider your SQL skills to be basics or something more advanced? I'm guessing you're just doing querying as a DA and not building tables or the infrastructure of tables? Could you give some SQL examples, like are you using advances case statements or relatively basic things like JOINS, SUMS, AVG, etc.
Thanks for the kind words Josh! For Entry level just the basics should be enough to get a you a job. Some Entry level positions may need Intermediate level where you need to know Joins, Aggregate Functions, Unions, Sub-Queries, etc.. I have a few videos on this as well as some tutorials I'm still currently making on Intermediate SQL. Hope that helps!
Thank you for the knowledge, I am learning python and have seen lots of analyst jobs out there. I know that Numpy and pandas can be useful so I appreciate the insight as to what one would need.
I'm an Information Systems student in college right now. Data analytics is a common job for people with my somewhat unusual field of study. It's something to look into if you want something focused on data and information (also don't have to take as much calculus haha).
Thank you for your insight, I am interested in taking a deeper dive into data analyzing. Currently working in quality assurance and general insurance policy information processing
I just came accross this video .. thanks for the help!! I have a bachelor in Marketing and now planning on pursuing my Masters in Business analytics .. do you think they’re a good match??
Hello there! Wonderful videos. Definitely helped me understand more of what this job entails. You mentioned degrees briefly in your video. Is a bachelor's required for entry level? I have an associate's in an unrelated field, and was hoping after online courses or a bootcamp to hopefully get my foot in the door with an entry level job, then work on the degrees to move up. Is this a feasible plan, or do I need a bachelor's to even get in the door?
I don't think a bachelor's is absolutely required, but it will help a lot. Most jobs do require a bachelors as a prerequisite. Bootcamps can be an okay option depending on the bootcamp itself and your current situation, but in general I don't advise them. I made a video on bootcamps a few weeks back. Just going off the information you provided I would probably try to work on my skills independently for a while. At least get yourself comfortable with all of the staples of Data Analysis. After that you could go to a bootcamp if you want or you could start building a portfolio and ramping up your resume to try to get some experience through an internship, mentorship, or volunteering. Really any experience at all will help a lot. After that try to get an entry-level position. Hope that helps!
Can knowledge in economics, finance or marketing be of advantage in the analytics profession? Aside from job and year of experience, what else can help a junior data analyst to move up to mid-level? Is age a BIG FACTOR in getting a junior role in the U.S?
Yes, your degree can be a big factor depending on the industry you're applying for. The biggest thing to move from junior to mid-level is experience and higher education (master's degree). I wouldn't say age specifically as much as experience, although those two normally go hand in hand.
Actually all data analysts are not done this work as like u said.since in every process one process engineer to stabilize and visualise the status on control tower to maintain SLA attrition employees deployment erc etc .. data analyst just work on clear and clean the data and send to sme .
Every data analyst position is different, but this video is talking about Data Analysts as a whole. At a small company a Data Analyst may do all of these roles themselves. At a large company you may have Data Engineers, Developers, Architects, and Visualization Specialists who do a lot of what I talked about in this video. As a whole these are all the things a Data Analyst should know and be able to do.
College degree or math necessary? I’ve seen excellent salary ranges for this role. It’s an ideal career if you don’t mind staring at screen for hours and hours. I’m for coding in general, but different from this data analytics stuff. Though, this may be a nice role if you like running reports day in day out. Before I even watch all the video I’d say you’d have to at least be versed in mathematics to a minimum statistics and or calculus due to the intense analytical work that goes into this job. You have to visualize this data which is what a data analyst does. I’m still for web development then web apps down the line but just find this video and this guy interesting and motivating 🙂
I wanted to ask you, in which percentage do you work with programming (MySQL, Python/R) in your daily life as a Data Analyst? For example: 40% meetings and clients, 40% programming (Python/R, SQL) 20% visualisation and presentation.
Hello Sir Alex, Keep the amazing work up! Your channel is really helpful for Aspiring data analyst/scientist. I'm 18 and recently moved to the UK. Having 2 years experience in object oriented programming in C/C++ and recently started python, I was looking to continue my college, would you recommend me to get a bachelor's first and then apply for a Data job or should I try getting an online certification and apply for an entry level job whilst pursuing my degree? I would love to know your opinions from a students perspective.
I'm wondering this as well. In my country there is an 8 month "junior data analyst" course where you actually get a mentor and stuff and it does look interesting...but I'm not sure it would work without a related degree
I am looking to become a data analyst although my degree is in business management. I have been working as a merchandising analyst utilize mostly PowerBI to export data and Excel to create reports. I hope you land an entry level data analyst position so I can get more skills to pay the bills lol
I'm getting my bachelor's in English. I was wondering about data and statistics in masters. But I realized that edx and other programs do offer the same info, and sometimes better than uni.
2 minutes in, I realized this work isnt for me, but when I got to the end where you show the salary, I was shocked how low it is. I thought Data Analysts made like $150k per year.
I feel that salary is somewhat off. In a major metropolitan area (NYC here) and dependent on sector, I’ve seen entry level salaries be closer to that mid tier level.
Why self teach data analytics if companies require bachelors degree? I want to do the Data Analytics course online with Google for a certificate. Will employers not interview or hire prospective candidates with this certification?
I hear this is a good career choice for felons. I really need help. Tired of feeling like a loser. I don't want to dedicate myself to something and be turned down again.
Hey, I started the google Coursera for DA following your reccomendations. I am really enjoying. I am learning a lot about SQL and its functions and syntaxes. Which software should I purchase to create my projects? I have MS.
Going into my last year of college and I’ve been looking at the data analyst positions around my area. What would you suggest I do/practice so that I have a pretty good idea already once I finish school.
The Salary Part is definitely not comprehensible. Thats hell a lot of roles combined into one. A Data Engineer, Data Architect, Data Validator, Data Visualization Expert, Automation Specialist. In big organizations each role will have multiple members. Hence I have a problem with Salary Component in this video alone. Agreed that it will not be Salary * 5. But definitely not less than $ 150 (min). I may be wrong. Happy to be corrected. Purely coming from the amount of effort involved.
I’m running out of ideas of what to do with my comp sci degree..everything seems so complicated and way over my head..I can not do web or mobile app development no matter how hard I try ughhh
Hi Alex ! I just obtained my bachelors degree International Business, no previous experience at programming nor maths (just common accounting). I applied to a master in business analytics which is basically Data analysis, do you recommend me to go straight to it or I should take sometime to study or develop the math skills and programming ones ? Thanks, btw great video !
I wouldn't get out of bed in the morning for $110k.. If you are senior, and have 20+ years experience, you can expect $250K as a contractor, especially if you are prepared to travel to the job where ever it is.
I recently graduated with a masters degree in zoology and did a lot of data analysis in my degree, and so am now looking to get into data analysis. I’m looking at getting into it from the angle of environmental / ecological data analysis. Do you think it’d be possible to get into data science this way?
Hello and thank you for the video…I am a junior chemical engineer and during my thesis I have learned to work with MATLAB to model different processes and stimulate them but since then I started to build a huge interest for programming… My question is, how can I use data analysis in my job…I really want to learn about being Chemical engineer with data analyzing skills and prepare myself for the future of industry. Industry 4.0
I have watched a lot of videos and folks are so long winded and don’t say a thing at all! Thank you for getting to the point!
I agree! Definitely something I try to do on this channel :) Except in my ATA Show... It's all nonsense in those episodes lol
True!
Lol 😜😄
That’s what happens when TH-cam wants more watch time for more adds but then you get thousands of youtubers who stretch out a easy ass 4 minute video into some stupid shit
@@AlexTheAnalyst you you have an extra one 😅. Biii😅 😅😅hi Thank yea yea yea using your your under my order for for the the time thank thank love for my 😅😅u I’m u😅 love love 😅unjani I’m so 😅b I up for my my. Uiiiiiiiiii😅😅😅😅uI I’m us I o miss it and 😅😅buy hi hi iiiibi I hope you have you have you have 😅ui uuiu uiuubui I hope you’re unjani too iiiibad iiiito I’ll just have have you and uiiu u but Iii bI’ll ui the whole whole thing I I guess guess guess Uyaphila iI’m I’m sorry but you you are not unot not really sure 😅😅juice uiiand uyou uiuuiyou you iubneed do that that uh I miss my uui and 😅uuiu uiiiunjani uiiii. Bb the whole whole uunjani uuiuuuiiiand uiiiu😅 uiuiiuiiii hi I hug building uiia huiiiiuuuii is my umy iii huny u iiiiiiiiui oh uuuuuuiiuhurry iii bbbuibbiiiu iuiiiiiiuiuuuiI’m I iuuiuiiuiiihuuiiiu Uii😅bbibuuiuiiuiuiuuiiiiiuiuiiuuiiuiiiiuuii😅uuuuiu I’m huiiuuuiii go get a haircut 💇♀️💇♀️ I’m I’m not at uiat at work work I’m I’m uuui😅 I have A A A uuii in u uuiu uiiiii in a good 👍 but I’m sure sure sure will uiwill have have it it will help help uiiiiiiiiiiiiiiiiiiiiuiuuuiiiiiiuiiiuuuuuiiiiiiiuiiiiiii uuiuuuuiuiiiiiuuuiuuiiiii in case I use the the car 🚗🚗 I’m using uthe uiiiiiuiiiiiiiiiiiiiiuiuuuiiiiiiuiiiuuuuuiiiiiiiuiiiiiiiiiuuuuuiiiuuuiuiiuiiiiiiiiiuiuuiiuuuiiiuuiiiiuiuiiiuuuuiiiiiiiiuuiiiiuuiiiiiiiiiuiiiuiiiiiiiiiiiiuiiiiuiiiiiiiiiiiuuiiiuiiiuiiuuuiiuuuiiiiuiiiiiiiiiuuuuuiiiuiiuiiiuiuiiiiiuuuiiiuuiiuiuuiuiiiiiuiiiuuuuuuiuiiiiiiuuvbn in
hey alex, im 28 now since i saw your video, i realize its never too late to switch career into data analyst field, and your video guide me to my goal in future, thanks alex, keep goin'!
That's awesome! You got it!
Iam 43, and it's never too late for me😊.
@@se1184 have u started already? intersting to find out
@@PeterParker-hf8ok yes, i make 2steps:finished MSc of statistic and have AI course using Python.
@@se1184 well done. I only have bachelors in business management. Not sure if i can do statistics. Maths really a major setback for md
This is by far the most helpful video I’ve watched in trying to map out a career change, so thank you!
did you go for it? and if you did, how are you enjoying it so far? I'm really thinking about entering an online program for it starting in 2 weeks
Masha Allah! Thanks a lot for a superb and brief style to express the topic in an easy and effective way!!!!
Thanks a lot for this Alex. It will be also helpful to add programming languages and tools needed in each job description. For example for data setups and visualization one could learn Tableau, I am not sure I know what to learn for other descriptions. This video is very useful.
Thank you so much for the Data Analysis job description. I'm currently taking Data Analysis course through Coursera. There are 8 courses total, and I'm currently on course 4.
How did that go for you? Were you able to find a good decent DA job?
@@stlouie88I’m still on course 4. I had to pause for a bit because I was dealing with some health issues. After I finish all 8 courses, I plan to brush up my resume and start applying for a Data Analytics job.
@@maddiermah5875i would like know your job getting news. And is the coursera course really helps you get skills needed. I was thinking about
@@maddiermah5875 I hope you are fully recovered. Can you please let me know if you are able to complete the course and obtain a job of your choice. I am curious as I am looking into different prospects of Data Analytics.
Keep in mind not all companies have programmers to do the ETL work. I'm a Sr. Data Analyst and I'm responsible for the entire process from start to finish. Sometimes Data Analyst also perform the workloads of Data Engineers, Data Scientists, etc.
jerseyse410 you’re absolutely right. My second Data Analyst job was like this. That part can fall in the Data Analysts territory at certain places.
For the role of the programmers mentioned in the video and this comment, what is their job description? Are they data engineers? Database engineers? Do they design the company websites to collect the data? Any and all expansion on this would be very helpful.
Glad I saw your comment. Just about to start a job and from the interview process, they want me to cover all these roles! I will see where it takes me anyways. Hope it's all going well at your end x
@@onyinoyi_o do they pay you more for covering all those roles?
@@AbdulRahman-fe5zu Nope
Alex, you should definitely consider making a course related to data analytics in Udemy. I would be happy to join 😀
Funny story - I have a bachelor degree in Computer Engineering and I am specializing myself in Big Data. I went on an interview for a traineeship related to something completely different (more of the programming type). The interview went very well but they noticed a passion and predisposition to data in the way I talked. So now they want another interview with me next week directly for a data analyst junior position. That's why I am here. I didn't request the interview, it was offered. So, now I am trying to understand a little bit better the job and requirements.
how'd it go?
@@Cahangir I got the job and I love it. 😄
@@Vivian-ve1qt good for you )
@@Vivian-ve1qt Thats awesome!!
@@joann1699 Thank you very much! 😄
i am at a point where I am no longer paying for more college... between this and coding, I should be able to pull it off without. Udemy seems amazing... I have been doin that for about 2 weeks... LOVE IT... seriously see myself being a lifetime member.
About to attend a job interview for a project manager of a data analytics project. This has been very useful. Thank you.
Good luck!
Did you get the job?
I couldn't thank you enough for making this video. Informative, to the point, answered all my questions, just perfect
Hi Alex. Thanks so much for taking the time to do this. It's super helpful to us aspiring Data Analysts. And like your random jokes, comments, intro of your dog, etc. These all keep things light and interesting 👊🏽
Thank you for getting to the point. Just all the intro i need.
Hi Alex, I'm happy to see you respond to viewers regularly. I recently graduated with a BS in International Business and would like to pursue a career in data analytics, probably in the fields of business, marketing, or economics. Because of the way the programs at my university's business school are laid out, I could go back and do 2 part-time semesters, while continuing to work my current job, to receive a BS in Information Systems with a focus in Business Analytics. This would be cheaper than most of the boot camps I've seen, and seemingly from a more legitimate institution. Is this something you would recommend? I'm not sure if the same knowledge/experience could be achieved/demonstrated through a cheaper or easier channel. Much love from North Cack, and keep up the good work.
I think in your case both options are viable. I think preferably you would get a BS in IS, but if that time is not available a bootcamp may be a good way to go!
Thank you so much for releasing these informations to the public. You're so awesome, I wish you tons of success and happiness!
Hey Tom, thanks for the feedback! Super glad to hear it's helpful :D
Same here, many thanks for sharing this. Really helpful to figure out my next steps
Maths and statistics!!!! What level of competency is required. What area should a none maths savvy person focus on in maths and statistics.. this will save me a lot of time
4 minutes and 18 seconds straight brain spasms! 😂 😂 😂
Wow by far the easiest and smoothest explanation I’ve listened to. Thanks Alex!
Hey Alex a few of my seniors who used to watch ur vedios in college are now working as data analysts in Tata Consultancy Services Deloitte Wipro and Cognizant. Im in my final year of Bachelors in Computer Science with AI & ML. I want to become a data analyst too i stumbled across your channel starting my journey im just not that good at math but i will grasp all of basic stats and stuff. I have been learning ML and Python I love python. Let's see where I land in few months as companies come on campus to recruit me for jobs. Good Content.
Very clear and straight forward
Nice job
Love the videos Alex! I have my first interview for a Data Analyst position tomorrow, I've been utilising your videos to help prepare myself and they've moved me from a position of terror to relative ease. Thanks again!
That;s fantastic! Good luck! And thanks for watching!
@@AlexTheAnalyst thanks Alex. It went well. I now have the first telephone based technical interview. Not sure how that's going to go!
musicisgood how’d it go?
Elijah Masters yeah, how did it go??
@@AlexTheAnalyst hey! Thanks for asking. I'm in the medium stage and final stage of interviews with two companies! Big thanks again for your advice!
I just watched this video today, I gotta say wow, you're amazing..
I'm currently in my 2nd year doing my Bachelors degree and I'm hoping to be a data analysit some day..
I will go through your videos and understand/know what's best expected of me..
Thank you for this videos good Sir..
you are doing really well to help IT people.....giving that knowledge for free is the thing that no one does....I really appreciate, thanks a load and god bless you....
Just found your video because I just recently applied to EdX to get the certificate for Data Analytics Basics. I have always loved problem solving, brainstorming and analyzing everything. So at the age of 44 with no previous experience or college of any kind, I feel like this is the perfect career for me! Thank you for your information!
Do you have any updates about EdX? I'm turning 30 this year and am a pharmacy assistant looking to change career paths.
Well done! Condensed a lot of information into a very practical video. Thanks!
Wow!..Thank you for this ! Love the info. I am currently working in a bank in Finance group were I learned to use SQL for data extraction and MIS reports. Now I am starting to study and learning Python. Am I in the right track as well?.haha! I want to shift to a data analyst role too.
Sounds like you're on the right track to me! Good luck!
Vey good! Simple, clear and easy to understand. Plus, I like tall the covered fields you spoke about. Thanks, Alex!
Just a bunch of words that mean nothing to an outsider. You mught as well be speaking Chinese. It would be much more helpful to show people what a data analyst does.
Taking first semester of Data Analytics now. It all makes perfect sense. Maybe level up on the topic, and get back to us. Or perhaps consider an alternate career.
@@smtxtv yeah man I can't believe he didn't get anything from this video
Everything he said makes complete sense although i have some background knowledge as data analytics student
Hi Alex, I’m a new subscriber
New to data analyst in general, I’m a Graduate in finance but I would like to pursue a career in data analyst.
I’m looking forward to watching more of your videos.
Very thorough & helpful thanks! ❤
Thank u so much…you were direct, to the point, no bs, and answered the questions most people came here in search of…👍
Really straightforward. Enjoyed it.
Hey Alex, thanks for this video. About the requirements for data analyst, would you say a person changing careers without a bachelor's in math, statistics e, etc is expected to find it difficult to access the market? I know that you have done such a thing, but I would like to hear your current perspective on it.
Ff up
I have a bachelor's in social science and an associate's in accounting, looking to transition into data analytics with the Google Data Analytics Certificate to pick up programming languages. What do you think of those three qualifications together to land an entry level job?
Side note, I definitely plan to do a Python course after the cert so I can work in it as well as R
New subscriber here! Anyhow, I’m also a Data Analyst in the healthcare industry, and I agree with Alex over his summary on what most data analyst do. For starters, learning a database language (like SQL) is vital as well as being familiar on basic programming languages (like XML, JavaScript, Python, etc.) and reporting and analytics tools like Power BI, Tableau, Zoho, etc. It’s also important to have basic understanding over best practices to implement data quality and security, especially when you’re dealing with sensitive data like peoples’ financial and health information.
That's true! I think XML and JSON, both of which are semi structured data, can be a bit more complicated for beginners in the actual ingestion phase. Definitely a great are to know. And for sure, the healthcare industry especially has a lot of sensitive data - great to know data security especially if you don't have a DBA or Data Engineer on you team. At my company we do so this does not fall on the Data Analysts as much. Thanks for subscribing! Hope you enjoy the content :)
Hi Marshall, can we connect over a online coffee to discuss about a data analyst role and business objective please.
Hello. I want to get into data analysis in the healthcare field but what I wanted to ask is it a good step to take medical billing and coding classes also?
XML is not a programming language, it is a markup language that uses a specific format to represent data.😅
Why Javascript?
Would you say you spend a majority of your time is spent in the Collect and Clean steps? Just say yes to make me feel better lol
Haha yes - that is where 75% of my time is spent. Definitely a big part of the job.
@@AlexTheAnalyst will you use the pandas library for cleaning the data or something else? Please reply .
Its easy ryt
@AlexTheAnaisnt ut easylyst
I hold a statistics degree, currently doing a post graduate diploma in data analytics. I have been teaching myself Sql which was so much fun i must now moving to Python then i'll learn some basics in power BI and start applying for jobs next year. I'm so excited to start a career in data analytics. Your video was so helpful. Thank you❤
do u have to code in python?
Thank you very much for this video and info. 😊
very straight and concise information..Thank you
Thank you for getting to the point!
You mentioned the degrees that are preferred for this job, would a bachelors in CiS seem suitable? Thinking of changing to that major. Great videos!
Yes it would be a great major!
Thank you so much for the video. This channel is a goldmine of useful information and I hope you get more exposure soon :)!
Question: Would you consider your SQL skills to be basics or something more advanced? I'm guessing you're just doing querying as a DA and not building tables or the infrastructure of tables?
Could you give some SQL examples, like are you using advances case statements or relatively basic things like JOINS, SUMS, AVG, etc.
Thanks for the kind words Josh!
For Entry level just the basics should be enough to get a you a job. Some Entry level positions may need Intermediate level where you need to know Joins, Aggregate Functions, Unions, Sub-Queries, etc.. I have a few videos on this as well as some tutorials I'm still currently making on Intermediate SQL. Hope that helps!
Wow, this very informative and to the the point! Thank you 🙏
Thank you for the knowledge, I am learning python and have seen lots of analyst jobs out there. I know that Numpy and pandas can be useful so I appreciate the insight as to what one would need.
On the point! Answered many questions!
As crisp and clear as it could be. Thanks for the video.
This is so helpful. I've been more clueless than I realized. Thank you!
How much Maths does a data analyst needs to learn and/or use? Please, its the only thin that holds me back from considering it as an option.
What should I do after High school to become a Data analyst in the gaming industry?
STATIC I would focus on majors like Computer Science or Graphic Design and take classes related to Data Analytics while pursuing that degree.
I'm an Information Systems student in college right now. Data analytics is a common job for people with my somewhat unusual field of study. It's something to look into if you want something focused on data and information (also don't have to take as much calculus haha).
@@weldin ive been looking for this exact answer since i’m getting into colleges for IS and started to get concerned about job prospects. thank you!
Thank you so much for this video! Very informative and succinct. This is definitely going to help me make an educated decision for my future career.
Sibei well summarised I'm gonna be a data analyst one day!!
Thank you!!!
You're most welcome! Thanks for watching!
thanks man really understood
Thank you for your insight, I am interested in taking a deeper dive into data analyzing. Currently working in quality assurance and general insurance policy information processing
I just came accross this video .. thanks for the help!!
I have a bachelor in Marketing and now planning on pursuing my Masters in Business analytics .. do you think they’re a good match??
Great Video !
Thank you for being transparent.
How long can I study data analytics to become entry level?
Hey Alex, this helped a lot thanks!
Hello there! Wonderful videos. Definitely helped me understand more of what this job entails. You mentioned degrees briefly in your video. Is a bachelor's required for entry level? I have an associate's in an unrelated field, and was hoping after online courses or a bootcamp to hopefully get my foot in the door with an entry level job, then work on the degrees to move up. Is this a feasible plan, or do I need a bachelor's to even get in the door?
I don't think a bachelor's is absolutely required, but it will help a lot. Most jobs do require a bachelors as a prerequisite. Bootcamps can be an okay option depending on the bootcamp itself and your current situation, but in general I don't advise them. I made a video on bootcamps a few weeks back. Just going off the information you provided I would probably try to work on my skills independently for a while. At least get yourself comfortable with all of the staples of Data Analysis. After that you could go to a bootcamp if you want or you could start building a portfolio and ramping up your resume to try to get some experience through an internship, mentorship, or volunteering. Really any experience at all will help a lot. After that try to get an entry-level position. Hope that helps!
This is exactly me right now, how did it go mate?
Thanks bruh you're helping me out with my homework
Can knowledge in economics, finance or marketing be of advantage in the analytics profession? Aside from job and year of experience, what else can help a junior data analyst to move up to mid-level? Is age a BIG FACTOR in getting a junior role in the U.S?
Yes, your degree can be a big factor depending on the industry you're applying for. The biggest thing to move from junior to mid-level is experience and higher education (master's degree). I wouldn't say age specifically as much as experience, although those two normally go hand in hand.
I'm currently working as a Data Analyst III, and I'm searching for a full time position.
This is my next hurdle. A data analyst
Brilliant definition
Actually all data analysts are not done this work as like u said.since in every process one process engineer to stabilize and visualise the status on control tower to maintain SLA attrition employees deployment erc etc .. data analyst just work on clear and clean the data and send to sme .
Every data analyst position is different, but this video is talking about Data Analysts as a whole. At a small company a Data Analyst may do all of these roles themselves. At a large company you may have Data Engineers, Developers, Architects, and Visualization Specialists who do a lot of what I talked about in this video. As a whole these are all the things a Data Analyst should know and be able to do.
College degree or math necessary? I’ve seen excellent salary ranges for this role. It’s an ideal career if you don’t mind staring at screen for hours and hours. I’m for coding in general, but different from this data analytics stuff. Though, this may be a nice role if you like running reports day in day out. Before I even watch all the video I’d say you’d have to at least be versed in mathematics to a minimum statistics and or calculus due to the intense analytical work that goes into this job. You have to visualize this data which is what a data analyst does. I’m still for web development then web apps down the line but just find this video and this guy interesting and motivating 🙂
I wanted to ask you, in which percentage do you work with programming (MySQL, Python/R) in your daily life as a Data Analyst?
For example: 40% meetings and clients, 40% programming (Python/R, SQL) 20% visualisation and presentation.
Awesome video!!
Hello Sir Alex, Keep the amazing work up! Your channel is really helpful for Aspiring data analyst/scientist. I'm 18 and recently moved to the UK. Having 2 years experience in object oriented programming in C/C++ and recently started python, I was looking to continue my college, would you recommend me to get a bachelor's first and then apply for a Data job or should I try getting an online certification and apply for an entry level job whilst pursuing my degree? I would love to know your opinions from a students perspective.
I'm wondering this as well. In my country there is an 8 month "junior data analyst" course where you actually get a mentor and stuff and it does look interesting...but I'm not sure it would work without a related degree
I am looking to become a data analyst although my degree is in business management. I have been working as a merchandising analyst utilize mostly PowerBI to export data and Excel to create reports. I hope you land an entry level data analyst position so I can get more skills to pay the bills lol
I thought I was watching at 1.5 velocity but no, was normal 🤣 btw great video
I'm getting my bachelor's in English. I was wondering about data and statistics in masters. But I realized that edx and other programs do offer the same info, and sometimes better than uni.
This was helpful!
thanks for sharing
Alex please tell me that what are the methods you are using to clean up the data in pandas . Can you make a dedicated video on this topic.
I will definitely be making a whole video series on data cleaning in SQL and in Python.
@@AlexTheAnalyst ok
2 minutes in, I realized this work isnt for me, but when I got to the end where you show the salary, I was shocked how low it is. I thought Data Analysts made like $150k per year.
I've watche this cause I have job interview tomorrow
NAKAPASA KA?
I feel that salary is somewhat off. In a major metropolitan area (NYC here) and dependent on sector, I’ve seen entry level salaries be closer to that mid tier level.
Great video
Recommend trade by iron hack, but doesn’t sound interesting. Thanks for the info.
Why self teach data analytics if companies require bachelors degree? I want to do the Data Analytics course online with Google for a certificate. Will employers not interview or hire prospective candidates with this certification?
If you have the right skills and can demonstrate it in a portfolio then I think they would - depends on the company of course
I hear this is a good career choice for felons. I really need help. Tired of feeling like a loser. I don't want to dedicate myself to something and be turned down again.
Hey, I started the google Coursera for DA following your reccomendations. I am really enjoying. I am learning a lot about SQL and its functions and syntaxes. Which software should I purchase to create my projects? I have MS.
Going into my last year of college and I’ve been looking at the data analyst positions around my area. What would you suggest I do/practice so that I have a pretty good idea already once I finish school.
The Salary Part is definitely not comprehensible. Thats hell a lot of roles combined into one. A Data Engineer, Data Architect, Data Validator, Data Visualization Expert, Automation Specialist. In big organizations each role will have multiple members. Hence I have a problem with Salary Component in this video alone. Agreed that it will not be Salary * 5. But definitely not less than $ 150 (min). I may be wrong. Happy to be corrected. Purely coming from the amount of effort involved.
I’m running out of ideas of what to do with my comp sci degree..everything seems so complicated and way over my head..I can not do web or mobile app development no matter how hard I try ughhh
Restaurant to another world secret episode wow
(Saw this video on a playlist of anime)
Hi Alex !
I just obtained my bachelors degree International Business, no previous experience at programming nor maths (just common accounting).
I applied to a master in business analytics which is basically Data analysis, do you recommend me to go straight to it or I should take sometime to study or develop the math skills and programming ones ?
Thanks, btw great video !
Hey what are you doing now?
did any restaurant from another world fan confused when this video come up?
I wouldn't get out of bed in the morning for $110k.. If you are senior, and have 20+ years experience, you can expect $250K as a contractor, especially if you are prepared to travel to the job where ever it is.
How much should I expect as entry level data analyst with a masters? In Southern California
Do you need excellence English writing skill to be a data analyst?
Depends on where you're trying to work honestly. I think it definitely helps for a lot of jobs in the US.
I recently graduated with a masters degree in zoology and did a lot of data analysis in my degree, and so am now looking to get into data analysis. I’m looking at getting into it from the angle of environmental / ecological data analysis. Do you think it’d be possible to get into data science this way?
useful video
Hello and thank you for the video…I am a junior chemical engineer and during my thesis I have learned to work with MATLAB to model different processes and stimulate them but since then I started to build a huge interest for programming…
My question is, how can I use data analysis in my job…I really want to learn about being Chemical engineer with data analyzing skills and prepare myself for the future of industry. Industry 4.0
Helpful 🎉😊
Hey Alex! Thanks for the video!!
You speak about automation in your videos, could you please talk about the process of automation? Thanks!!
I definitely will one of these days
i still dont quite understand what is data anylyst.. so you just compile data but how?
Did he actually say datum out loud lol? I respect that