I analyzed 2,789,369 jobs to solve THIS

📲 The Data Nerd App 👉 datanerd.tech
Courses for Data Nerds
==================================
📜 Google Data Analytics Certificate (START HERE) 👉🏼 lukeb.co/Googl...
🐍 Python for Everybody 👉🏼 lukeb.co/Pytho...
💿 SQL for Data Science 👉🏼 lukeb.co/SQLda...
🧾 Excel Skills for Business 👉🏼 lukeb.co/Excel...
📊 Data Visualization with Tableau 👉🏼 lukeb.co/Table...
🏴‍☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforD...
➕ Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/Cours...
👨🏼‍🏫 All courses 👉🏼 kit.co/lukebar...
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebar...
📗 Data Analyst Must Read 👉🏼 geni.us/Storyt...
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebar...
🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 lukeb.co/Paral...
Social Media / Contact Me
======================
👾 r/DataNerd 👉🏼 / datanerd
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
🙋🏼‍♂️Newsletter: www.lukebarous...
As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
#datanerd #dataanalyst #datascience

[@honestabe_9207]

Do this for every major job category, and you’ve got yourself a full blown company

[@MathTech83]

I agree with this comment so much. You have a very valuable and solid product here. You have connected skills to what employers are really looking for by data job category and country. You deserve good funding for this.

[@frothylube491]

The fact we have people like Luke who give us a genuine look into the field, create tools to show us where we should focus our own time and money, and give us repeated hope that anyone can learn this is truly incredible. Finally finished the Google Data Analytics Certification. Painfully going through my first project and hoping to land my first job in the field.

[@LukeBarousse]

Congrats on finishing the certificicate!

[@tawesome]

Congrats! I finally finished today as well. I wish you the best of luck in getting that first data role.

[@ainaqui6095]

Congrats! I am on course 8 at the moment. Hopefully will finish in March 😊

[@juliusphu9847]

Congrats and good luck!

[@vivekjoshi3769]

@Max Brilian I personally found R better because you don't have to import the libraries and assign them to alias then use the methods inside the library using alias which is the the case with Python. You just load library once packages are installed and use the functions. After moving to python after R is making it difficult for me to adapt python's way of working but I have no choice as market favors Python more here lol

[@AdirFeijo]

The amount of work and effort that went into this project and this video just blows my mind. I love it. Thanks bro keep up the good work

[@LukeBarousse]

Thanks for noticing this, Adir! Appreciate you!

[@uchennachilokwu156]

The sheer amount of work that went into this is mind-boggling. Thanks for all you do, Luke.

[@LukeBarousse]

🙌🏼

[@kangwamumba7479]

Luke, the fact that you expanded to your dataset to cater for countries outside the US makes this resource a 1000 times more valuable to those of us living outside the US. Thank you for your time and effort. Google better reference this website ehen they update their data Analytics course.

[@LukeBarousse]

Data Nerds! Loving the feedback on datanerd.tech 🙌🏼 I just added a country filter and am working on more features! 🤓 If you want to help contribute to this project, slide into my DMs on Instagram with your github handle. DONE: Country Filter Added (23Feb23) Cache Common Queries for faster loading(9Mar23) Job Title & Country Filter Clean-up (9Mar23) UPCOMING CHANGES: Industry/Company Filter Years Experience Filter

[@ericGTS]

Amazing project! Thanks !

[@thomasjaeger648]

I'd suggest you use redis to cache some of the more common queries i.e. UK and US and the three Data job roles. Just changing the filter for data analyst takes over 1.5 seconds for it to retrieve and re plot the horizontal bar graph.

[@karljm7024]

The site is no longer showing the skills and titles etc along the graph

[@MrJos597]

would be cool if we could enter any job posting titles

[@yogidrink2430]

Awesome work! I was wondering if you would like to open source this, so others can also perform the analysis with other job categories and help develop the filters and such.

[@samuelpezzetta7084]

Hi Luke, fellow Data Analyst here. You have my sincere gratitude and appreciation for this masterpiece. The amount of value you just provided to all aspiring Data enthusiasts and the enormous effort that you put into this video are just incredible - you have really outclassed yourself and everybody on youtube 🙏

[@matthiasblum6555]

I am a little bit baffled about the fixation on job titles to be honest. My position was called DB Developer, Controller, Solution Engineer, BI Engineer, BI Developer, and I am pretty much doing the same for 20 years. ETLs, Reports, DB Development, SW Development, working with different Tools like SSIS, SSRS, SSAS, Cognos, APEX, different DBs like SQL Server, DB2, Oracle. A Data Analyst in my book can be the same I did the last 20 years with a more technical emphasis, or he has a stronger focus on the industry sector he is working for, and is analyzing Data in that direction (Marketing, Controlling, Business Cases, etc.).

[@vernator]

This is brilliant Luke !!!! For all the students, this is how you structure a project! Take cues! Problem, plan, execute, visualize, insights and conclusion.

[@LukeBarousse]

Thank you!!

[@zacronk6945]

What a crazy lift you've done here. I always enjoy the content, but this one in particular really lifted the curtain into what so many of us do every day. You managed to document an application of all the skills necessary to be a great Data Nerd, but you did it in order to clarify what helps you become a great Data Nerd. Bravo!

[@LukeBarousse]

Thanks, Zac! Hope it gets put to good use!

[@TcRiverrat18]

As someone who is breaking into the data industry I just want to say thank you so much for your hard work and dedication on behalf of people like me. ❤

[@UnorthodoxChange]

Its actually crazy how much effort you put into this video even using tools you haven’t used before really showcasing the “keep learning” mantra of being a data analyst. Honestly, the best data analyst on KZbin. Thanks Luke.

[@LukeBarousse]

I appreciate that! 🙌🏼

[@lo_ebb]

Of all the videos I have seen come out of the data influencer space, this is far and away one of the most inspiring. I particularly appreciate that you started with a personal question, collected your own data, and gave back to the community. I hope viewers take note that this project has been, and continues to be, an iterative process for you: a great example of how perseverance yields cool things!

[@LukeBarousse]

Thanks for noticing this Eimantas! Appreciate it!

[@thiagoparaiso21]

This project amazes me, cause I am part of this group of people who are changing careers. It's quite hard, even with a ton of information, to decide what I must pick to learn and be fit to work as a data analyst. Thank you, Luke, for the effort, and for helping guys like me choose the right path base on data. I'm doing the Google Data Analyst Certification, and you and Alex were my reference doing that, I am enjoying the course and I hope to tell you soon that a finished my project and got a job. Cheers from Brazil.

[@LukeBarousse]

Heck yeah! Subscribers like you are why I did this project, so thanks Thiago!

[@svgenterprises1]

I have been on a similar boat! I just finished the Cert a few weeks ago and if anything, it got the juices flowing on confidence to be able to jump into data analytics! Luke and Alex have been my go-to as well. Cheers to you and to your future in analytics!

[@thiagoparaiso21]

@@svgenterprises1 It's pretty good to hear that you feel ready to work and that we've got the same senseis Godspeed, bud!

[@arnouthpessoa]

Fala @thiagoparaiso21, tudo massa? Queria saber se tu conseguiu tua vaga, e se curtiu o Google DA Cert. Tens alguma rede para trocar uma ideia? Qual teu Ld? Abraçao!

[@thiagoparaiso21]

@@arnouthpessoa cara, eu acabei parando porque tive uma outra oportunidade. Honestamente o certificado da Google é bom, mas acredito que buscar cursos seria uma ideia melhor e fazer esse curso seria só pra buscar ter uma"carta de recomendação". Do que pesquisei na época, foca em aprender excell, escolhe alguma ferramenta de BI e uma linguagem de programação. Tem uma galera que oferece cursos no Brasil e acho que te darão mais conteúdo pra trabalhar.

[@jessieobeng9592]

As someone who presently works as an analyst, I’m blown away with how you’ve taken the problem of the industry using buzz words to describe their roles and now have a tool that shows a person to be about to clearly understand what the market is asking for

[@TinaHuang1]

This is such an amazing video - so appreciate the amount of work that must have went into this 💪💪 your videos deliver so much value!!

[@LukeBarousse]

🥹 Aw Tina, thank you so much! 🙌🏼

[@pedroavila1584]

as a data guy, I can't stress enough how thorough and insightful this is, definitely Luke is setting the standard, kudos!

[@LukeBarousse]

Thanks Pedro!

[@TheVincent0268]

In my first job, in 1994, I have build an app (for maintenance of a process plant) in Access, including a GUI, with forms. I learned to apply DB normalization and SQL then. I think SQL is one of the most robust languages there is. It is here already for decades and I don't see it disappear soon.

[@hassanhisham]

The amount of work and effort that went into this project is mind-blowing. Thanks, Luke for this hard work helping the data community.

[@serpapi]

Luke, thank you for an explanation on how to build a data pipeline and then how to analyze the data!

[@LukeBarousse]

Heck yeah! Thanks for making this project possible by providing the search credits!! 🙌🏼

[@emonymph6911]

@@LukeBarousse Tell done both of you and special thanks to SerpApi for making it possible.

[@argiovannini]

Aptly timed! Thank you Luke, I just finished my data analysis bootcamp. If you read this, I was also a nuclear machinists mate on the USS La Jolla, SSN-701. While I don’t have a degree, I am glad to hear that this transition is possible. I hope to run into you in the future 🙏

[@LukeBarousse]

Thank you shipmate and congrats on finishing up the bootcamp!

[@CésarManuelCuervoOrizondo]

Gotta say... the way you design and edit your videos is as mind-blowing as the content itself... is just brilliant in every aspect Luke.

[@LukeBarousse]

Thanks for noticing this, I put a lot of time into editing; so I appreciate your comment!

[@bhumikachauhan3175]

Beautiful video.. really insightful. I was wondering why are you not posting anything and now I know why. The amount of hard work that has gone into producing a high quality content like this is quite evident. Highly appreciate. Big fan.

[@LukeBarousse]

NGL it's difficult not to post sometimes when you want to share... but sometimes the story just takes longer than you want; so thank you for noticing this!

[@Headlikeanorange84]

Your videos amaze me. The amount of time and effort you've put into this one is mind boggling. Also, your visualizations are hilarious!

[@diazjubairy1729]

The moamst comprehensive and legitimate channel related to data analyst role, damn, this project is so cool

[@jafetreyes3809]

Damn Luke you rock!!!

[@balasubramanianp.g6970]

Every time I feel like we have hit a ceiling, you come through in clutch with another video explaining previously unknown use cases. You are a serious role model for inspiring analysts like myself. I would definitely like to see more of these videos.

[@LukeBarousse]

More on the way!

[@jimcallahan448]

Fantastic analysis! Both in how you justified it in the initial part qne consulted a data engineer. I completely understand what you are doing, but it is way, way beyond my skillset and I am very impressed with the way you grew your skill set. Suggestion: Your non=U.S. viewers who hope to get jobs in U.S. might be interested in keywords relating to citizenship or visas. Also human languages: English, Chinese, Japanese, German, Spanish etc. Also industry knowlege: Social media, banking, agriculture, insurance, criminal justice, genetics, etc.

[@LukeBarousse]

Thanks for these suggestions! Adding it to the list to see what I can change for v2!

[@justbelit]

wow. the amount of work and information in just 15 minutes! thank you. this is beyond helpful

[@gabriel.groppo]

This is absolute gold Luke, I started pursuing the business analysis job some months ago and it is really hard to understand what tools you should prioritize to increase your chances of landing a job. Thank you for your hard work

[@jjones503]

This video deserves so many more views. Grade A work sir!

[@CommandoMaster]

Can u make more videos on how to land a data analyst job if u have no prior working experience in that field (eg. finance analyst, or investment analyst)?

[@michaelkhanwald4522]

Chills literal chills❤ The way presenting the info you collected

[@mahadjamaroble1444]

Most informative 👌

[@wanharris6926]

Speechless! That’s how amazing and helpful it is for data nerds!!!

[@AngelFelizF]

You could include some R libraries like: tidymodels, h2o, shiny, modeltime, quarto, rmarkdown, ggplot2, data.table, tidyverse, stringr and plumber

[@John-qs5hu]

Finally something good at distinguishing the difference between a data scientist, data analyist, and data engineer.

[@d7oomy-964]

WOW, Actually this is one of the most impressing projects I've ever seen, Bravo man!

[@rexplorenow]

Luke - thank you! This is extremely valuable and I wish more people watch this.

[@jumbolarge108]

Amazing! I wish you could apply these tools to other job fields! Not a data analyst myself, just interested.

[@farafz3798]

Awesome video man, truly informative and useful. I’m still learning stuff through google data analytics certificate, have to learn more Python and SQL in-depth thanks to your video. Keep coming with those videos! 🍻

[@jaybestnz]

One thing, the ads are also often written by non technical HR hiring so the ad may not describe the actual skills.

[@waynelast1685]

Luke, excellent review. Idea: 1) comparison of tableau vs power bi , 2) influence of NLP TOOLS on skill sets , salary etc over time.

[@LukeBarousse]

I have a video on tableau vs power bi. Let me see about idea 2; I like it!

[@alanhf]

I think I never saw a video/content/effort in that complexity. From now on, I will rate videos based on "Barousse Scale". Seriously, fantastic work.

[@peterxyz3541]

The ANIMATION & graphics is hilarious AND illustrative. Easy to understand. Thanks 😂👍🏼

[@thomasbrothaler4963]

It does not matter how long this video took. This was one of your greatest ones! You showed very accessible how a Data (Engineering + Analyst) Project may look like in the real world, while providing value to all of us with your great website/app. Great Job!

[@LukeBarousse]

I appreciate this 🙌🏼 felt bad for taking so long with this one, but knew it would be worth the wait

[@alexanderthompson8433]

Hey Luke, I love the details and effort gone into this. As someone who is actively trying to get into a junior or entry level position for data analytics, I've done what I can to learn the essential skills to be marketable -- and then some. From getting degrees and certifications to gaining those essential skills and going beyond like learning graphic design to present reports and dashboards in a beautiful way, I still struggle to get my dream job. Job hunting itself is incredibly hard. Even if someone who has the skills, varied education, and a comprehensive portfolio, the other half is playing the game of reaching out to employers and hoping one day someone will give you a chance. I feel like this is a very underrated topic and curious what your thoughts are on this. Maybe it's bad luck and poor timing. Even the staffing agencies are having a hard time

[@ashleygesty7671]

Wow your communication and data skills are on another level!

[@KajalDhimmar-c2h]

Hey Luke, I just had to tell you, this video is absolutely insane! I've watched it so many times, and every single time, it just blows my mind. I'm constantly amazed by it, and it's got me thinking-I really want to tackle a project like this someday. It's just that mind-blowing.

[@malace2]

It makes sense. When I was applying for a data analyst job, Some of the technical interview needs some data engineering skill which I don't or barely have.

[@blackdeath7678]

We are sooo Lucky to have you luke 😊 Make it so easy for us now 🙏🏻

[@discretetantrum]

Respect as to what you have pulled out of this, Luke!!

[@zakwhite5159]

I would not brag that a matplot bar chart took an hour to process with out showing the dataset info. It screams "idk wtf I'm doing".

[@iRockTheBeat1]

This is crazy! Please build something similar for Software Engineers

[@franhike]

Look man, I don't get just "data" from you, I crack up with your videos. Thank you a lot from an data analyst from Spain!

[@octaviosubirana7145]

You're such a crack Luke! One advice for the website... Adding a filter for location or remote Jobs...

[@petatownsent]

You're the real OG Sir. We newbies and learners always grateful. Thanks a bunch.

[@santiagoaristizabal944]

Bro, its awsome the work you did. It will help me a lot. World needs more people like you.

[@zomgneedaname]

Can confirm this is about how a 'real project' in 'real companies' works, except it underestimates the amount of manual data cleaning / extraction there is...

[@raagjoshi4521]

By far the most insightful video on data careers, that I have seen. Thank you.

[@hbarudi]

Great video showing another way to get employment and even avoid the capchas without putting pressure on the bandwidth of the websites. I want to use this to help with my job search...

[@omidsakhi]

Damn! I was plowing snow on the street, chilling out my layoff when you car crash sound effect rolled in. I thought I was dead!!

[@LukeBarousse]

🤣

[@Deya__]

You're fucking crazy bro! Salute for all the hard work actually put in this.

[@EstamosAíÉnóis]

Damn. You set the bar high now. Wish I could something like this one day.

[@amberlynny]

You are a true gem, Luke. Thank you for the transparency and hard work!

[@adnanebekkaoui9480]

Simplified straight to the point of what can be done from data collection, preparation and viz. I really enjoyed watching this video. Hats off for the huge amount of work u've done, I felt the passion behind every step. Love it!

[@kiko83903]

Maan, you are such a data nerd and I love it! :D I've just secured my first data job as a BI developer and your videos helped me a lot.

[@LukeBarousse]

Congrats on the first data job Kris!

[@taaZtyr]

Great work! Would love to see this expanded to other ambugious professions like Mechatornics Engineers who also face similar issues with what skills are in demand due to integrated disciplines

[@GermanRodriguezqndq]

as always you went above and beyond, thank you

[@michelemoneywell8765]

Well done Luke! Thanks for all your work. I'm glad SAS made the list for Data Analyst languages. With the many thousands of tech layoffs in the San Francisco Bay Area, I quit pursuing becoming a Data Analyst, figuring why would a company hire someone with little/no experience when thousands with experience are available. But your video got to me. I love Python and know SQL, Excel, SAS and an intro level of Tableau and Power Bi. I'm substitute teaching in a CA charter school now, but this summer will resume the Google Data Analyst Career Certificate, brush up on skills, and expand Python knowledge. Thank you so much! The future is looking so bright, I'll have to get shades.

[@anthonychilaka]

Got a lot of value from this video and I happy that your channel has aided me align my transition from a 12year warehouse inventory role to Data Analytics with Data Engineering as my final destination

[@justtemporaryreally4086]

When you said "data engineer" I had to have a cynical sigh at the thought that engineering data, as opposed to at least pretending to be just objectively analyzing it, is an actual profession with a name for it.

[@Memeparable]

Just discovered your channel, I love it. Thank you for your work

[@jessegarris7037]

Great work. As a senior IS major this is very helpful! The video deserves more views given the work you've put in.

[@reitznerdomenik]

A lot of job postings have optional skills. It might be nice to highlight the percentage of a certain skill, where it is optional, or nice to have in a job posting

[@thedanyesful]

Great video! A little scattered maybe, but this topic is a gold mine and the amount of work you put in and the amount of important insights you surfaced is incredible.

[@tc2241]

I could have misunderstood, but you may have a inaccurate data point regarding the degree requirements(if mentioned). Many companies, mine included, will forgo a degree for the equivalent amount of experience. So maybe create two filters?: - Degree: required, preferred, not required. - Experience: range of amount of yrs required and preferred For a more accurate model.

[@TreetopCanopy]

Feedback: Very cool resource! Small issue with the job title filters: I see many duplicates with slightly different formatting ("Data Engineer" vs. "DATA ENGINEER", "Senior Data Scientist" vs "Sr. Data Scientist," etc.), which could be fixed with some simple regex and string manipulation. Thanks for putting this great tool up for everyone

[@LukeBarousse]

Yes! on the list of things to do; thanks for sharing this! 🙌🏼

[@CaptainNinjaKid]

I would love to have some kind of crowdsourcing for this project to gather date for other tech fields. I'm specifically in the video game industry and I think it would be wild to see how these different job titles compare.

[@LukeBarousse]

I like this idea; I wouldn't mind expanding this related tech fields and industries

[@Cyamonicaa]

Thank you 🙏🏽. Honestly, we are thankful.

[@praveent1343]

Great work man, putting together all this info in a 15 minute video is not that easy but you did a fantastic job. Thank you so much.

[@shreyadubey7905]

In the era of ATS where keywords matching the job role matters a lot ,thought about this idea few weeks back to build a project that displays the skills required for specific role based on present time requirements ,but cannot find the right path to proceed due to lack of guided roadmap .Thank you Luke sir for this video .

[@aaronanthonymoat]

This is just amazing. I think this is the best description of what a Data scientist does. The amount of effort you put in is astounding. Thanks so much

[@josho225]

this is ... simply stunning, great work!

[@TinkerTaverns]

This is both impressive and mighty interesting. Although I'm looking more for software engineering roles, it's really cool to see what data engineering is like through your process

[@amams_kaiser]

Wow… this is a great content Luke. A lot of work was put into this.

[@scottyclips552]

Incredible work Luke! Hopefully one day I can do work this advanced. I’m just starting out now, and I’m loving it. Thanks for the video.

[@esparzaoscar]

Amazing Job Luke!! I personally admire this job. I am 6 standard deviations motivated to embark on a personal project like this.

[@CarlosEliezerHernandezPintor]

This is beyond amazing, and I think this a good representation of what can be done when someone with data knowledge and a lot of effort. Thanks Luke !

[@bagelsforall1794]

When your personal project becomes a startup. Someone sponsor this man.

[@Lukiel666]

Darn it. Just studied Excel and start learning Access next week in my computer course.

[@TerriTerriHotSauce]

Swear I've been thinking about building the exact same thing, but for all programming languages. Even using the same techniques and stack. Watching this feels like deja vu it's crazy.

[@tadiwashangwa4931]

been waiting for this video man thanks luke

[@Sensorium19]

I admire the purpose and functionality of what you created and that you showed the steps in your process. A lack of accurate information has often been a bane in my life.

[@DanKxxx]

I would say the most important thing for any data analyst/scientist is to have a programming background. Can be any language doing anything. If you come from this background you'll already know SQL and you can pick up python/SAS/R really quickly and you should be up and runniung quickly. The next step is to learn how modeling works. I would learn both traditional models and machine learning ones as knowledge of both is handy and MLM are much harder to impliment in certain areas so it's good to know both.

[@haoho78]

I enjoy watching you walked through your thinking. Kudo for you, curious mind. I wish your channel reach to many many people around the world

[@noamventura8311]

I suggest allowing the ability to filter by country\ies for all the results, so that you can see the data that's most relevant to you

[@LukeBarousse]

I added a country filter!

[@aldorodriguez7310]

Beautiful content. Bro a data analyst giving data-backed advise about data analysis education. Priceless. Thanks bro, this is fantastic. This is information that is actually useful.

[@cindystokes8347]

Omg the framed pic of Alex Freberg (don’t know who the other guy is yet) behind Data Nerd’s stack of books!! Icon! 😊

[@ZhivixG]

further suggestions could be that in the future if we can see if the roles offered are either in-office, remote or hybrid and if its remote, is the role only offered to the residence of the country or open to anyone regardless of nationalities

[@industryrule-4080]

Insane video editing for a relatively simple concept of a video. Also, what a great portfolio project for Luke! 🎉