Data Engineers vs Data Analysts vs Data Scientists | What's right for you?

┋Get your data job┋
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-por...
PATREON: Even more detailed data analysis content ➡ / mo_chen
1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro and Organizational Data Flow
01:08 Data Engineer
02:15 Data Analyst
04:03 Data Scientist
06:08 Recap
Thanks so much for taking a little time out of your day to watch this!
Icon made by Freepik from www.flaticon.com

[@Dianamatis]

So for a long time I thought I want to be a Data Scientist because I loved predictive analysis. And I landed a job in Big Data and Analytics team which is quite the mix between data engineer and data scientist. A lot of focus on data manipulation and also strong analytics using R. The salary is greater than I thought for a Junior position. I will keep you updated, when I first saw your channel 2 months ago I was in the job hunt stage. 🎉

[@mo-chen]

Congratulations on landing your job! Very well done 😁 And yes, please drop a comment every now and then to share how you're doing.

[@greenwoodeastland5457]

How did you get the job? Do you have a masters degree in Data science

[@ibrahiimycl]

I am looking for a colleague to advance in the field of data science, someone I can exchange ideas with and learn together

[@Canda-fh4xc]

Thank you for the great explanation. Clear, simple, and complete information.

[@user-ey6eh3bx4z]

thanks sir , really needed this info , as i was always confused among data analyst , engineer and scientist.

[@shanjana_]

I just got a clear idea about how to develop my skills and communication skills..thanks man❤

[@user-zp1co9dg1e]

Amazing I really appreciate the effort you put even in this Small informative videos

[@krahkyn]

Great video -- your talks are always concise and display how each action fits into the greater picture

[@mo-chen]

I'm glad you liked the video!

[@richardenriquezjr.9868]

Thank you again for this video, Mo. Kudos!

[@mo-chen]

Glad you enjoyed it!

[@kolawoleagoro6893]

Great Video! Very well explained 👏

[@werapatmalikhao6016]

Let i sharing some experience my job role currently working as BI dev and i will move to work as DA at the cooperate company (real estate) next month . during today i try to study for improving my skill everyday watching your channel about the technical skill and soft skill in business . you know some tech skill that i very interest it's seem like my hobbies about learning how to build the model as predictive model by using any algorithm that fit with data even today i work as DA in real life but i hope that my career will progress than today in field of data . finally all of video that you published it very benefit too me you help me to got great job role . thank you !!

[@colinakarla]

I've always been interested in Data Analytics and after watching this video I am more confident that this is what I want to do, even though I hope to become a data scientist as time goes by. Thank you for your videos and the community you are building, Mo. Your roadmap has been extremely useful in my journey and I'm looking forward to getting some 1:1 mentorship as I get more and more into the field. Keep doing what you are doing!

[@mo-chen]

I'm glad you found many resources useful! Good luck with your data journey 😃

[@joelle9588]

Same here 😅

[@jessicapierceart]

Excellent information and perfect timing, as I specifically logged on today to see if you had a video on this subject! (Small tip: I think you had a little too much fun editing. The movement became a bit much. 😣) Personally, I think DS is my end goal. A little sad to hear more formal education is often required, but we'll see how things are at the end of the year (hopefully I'll be fluent in Excel, SQL, Tableau and Python by then).

[@mo-chen]

Thanks for the feedback on the editing -- just trying something new haha. DS is a great goal 😁

[@bluemage8504]

Very informative, thank you!

[@tanweerashif]

You are amazing Mo. Thanks for the video. I’m currently working as network software engineer in an MNC with a handsome salary but my passion for data engineering has put me in a place where I made one of the hardest decisions of my life probably. I’m quitting my current job in March 24. I’m already halfway through the skills needed for DE but I strongly felt that for job hunting and complete preparation, I need to devote 100% of my time into the same, which is obviously not possible with having a full time job. I’d love to hear your thoughts on these.

[@tanweerashif]

Update 1: Just couldn’t wait for it. Put the notice on 16th November already so that I leave on 16th January. Can’t explain how excited I am.

[@alexpro170798]

​@@tanweerashifsono felice per te! Fai quello che ti appassiona!

[@zahraedaoudi3485]

thaanks a lot for those information good luck from morocco

[@mo-chen]

Glad it was helpful!

[@ammarsenchoi4163]

Thank you for this video

[@preciouskennedy6370]

Hello Mo, is it possible to get A job as a Data analyst with the google advanced analyst course and some portfolio project as a beginner witb no data related degree?

[@rdbdebeer9085]

Bro This helped alot.

[@keylanoslokj1806]

Mo I've heard that data analysts have a harder time to set boundaries with their managers and employers who ask all the more different tasks from them. Often overlapping with tasks of other specialists' obligations like scientists, architects, ml-engineers etc. What's your take on this... ?

[@mo-chen]

I think this really depends on your exact role and your relationship with your line manager. Some say that your job can only be as good as your relationship with your LM.

[@keylanoslokj1806]

@@mo-chen so you separate it according to each analyst's niche, scope of responsibility etc

[@HalpPlsxx01]

MY MAN MO!

[@mo-chen]

Haha I'm still here indeed!

[@jackychan4640]

Great introduction again 😊

[@mo-chen]

Thank you!

[@jackychan4640]

Have a great day@@mo-chen

[@taetae7778]

Do Data Analysts work typically alone? Like other than interacting with Data Scientists and stuff? I’m a Developer and I’m used to working with other devs, so I’m a bit scared about having to work all alone

[@smiley3239]

is it a good idea to start as data analyst and switch to data scientist? will it be easier to get the data science roles after being a data analyst?

[@mo-chen]

Yes 😁

[@anshulbhardwaj909]

Hey Mo! Would you be making an end to end Churn Analysis Project a anytime soon?!

[@mo-chen]

Check this out -> kzbin.info/www/bejne/iKm7lYCpaJmfn80si=tNCFMdjVIOluI38y

[@marlonmontenegro8611]

Hi, I am facing a difficult decision. I currently own an administration business, and I have the opportunity to pursue a master's degree in Data Science with Python. While I've been following the tech path, learning web development with programming skills in Java, JavaScript, and SQL, I'm considering this because sometimes there's a requirement for a related title. Do you think it's a good idea to pursue this master's and venture into the Business Analytics path?

[@nari1071]

Can someone explain to me the need of statistics knowledge for a data analyst ?

[@datawithtess]

Nice video

[@ssk3532]

Hello everyone Currently I'm doing job as MSSQL database administrator now I want to switch my role. Because as I see demand of mssql dba is decreasing Kindly give me some tips which role is best for me

[@datawithtess]

I don't know what I am, I am interested in marketing and e-commerce analytics. A/B testing, and consumer analytics. But I have an undergraduate in mathematics

[@rafardzrba]

Meta just came out with their Marketing Analytics program in Coursera. Check to see if it is what you would like. 👍 good luck 🍀

[@mo-chen]

Undergrad in math is a great starting point 😃

[@rafardzrba]

@@mo-chen Yes, this 👆 what Mo said. Math will give you a good starting point .

[@keylanoslokj1806]

How do you get a portfolio site to showcase your excel projects?

[@mo-chen]

You could write an article on medium with nice visuals and link the excel file and data to the article.

[@user-bi9ln7pv5x]

It is ELT process or im mistaken?

[@yokimatzu6829]

Do i need to communicate with stakeholders for data engineer role

[@zabashhd459]

Hi Mo, can you suggest me top portfolio projects that can get me a Job In Data Analytics ?

[@mo-chen]

kzbin.info/aero/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU&si=swLXAyMBgRYtYg5E Here you go 😁

[@bodicpen]

My mentor put it this way: Data Analysts - What happened Data Scientists - What will happen Data Engineers - How do we know what happened

[@goutamnayak5011]

Can copilot 365 and other ai tools do all type of works in ms Excel or is it still important to learn ms Excel all functions and advance formulas ????? Please ans me sir

[@datawithtess]

Nice background

[@ibrahiimycl]

I am looking for a colleague to advance in the field of data science, someone I can exchange ideas with and learn together

[@mo-chen]

Check the invite link to my discord in the description please. It’s a great data community where you can easily connect with people.

[@syedmatluburrahman1958]

Salary of data analyst?

[@goutamnayak5011]

Copilot and other ai tools replace the Data analyst jobs ???

[@mo-chen]

This video should answer your question kzbin.info/www/bejne/hHSafpScYqmMjqMsi=eKFI2T6wFqEAjR05 😁

[@anidiotsguide757]

This video was clearly made for the tiktok-generation. Things constantly popping up on screen, sound effects, random zooms all the time. Exhausting

[@felipeoliveira8464]

Just like every other ytb channel. Video is flawless

[@dotmalec]

Agree, too much for me. If you do this every few minutes it's ok to catch attention to some important topic. Pop ups every few seconds is just annoying. The content is great 👍

[@sudevsen]

? Clearly you haven't seen tiktok. The pace is much faster

[@rogeremilemanzi406]

I agree, 1 minute in!

[@Svgcibay]

I am on my way to becoming a data analyst. I watch all your videos, but I do not know English. Can you please add Turkish subtitles to your videos? It is very difficult to translate. Your suggestions are very important to me. You explain it very well. I want to be a good data analyst like you. thanks 👏👍

[@mo-chen]

I'm glad you like the channel. Try Auto translate -- it's got Turkish and works pretty well usually.