I analyzed 2,885,160 jobs to solve THIS

[@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!

[@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.

[@uchennachilokwu156]

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

[@LukeBarousse]

🙌🏼

[@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!

[@notfancy.gabriel]

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

[@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!

[@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. ❤

[@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.

[@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! 🙌🏼

[@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

[@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! 🙌🏼

[@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.

[@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!

[@YottabyteUpdate]

As a data analyst/wannabe data engineer, a Luke and Ben collab is a dream come true. Thank you so much for this video and keep up the good work!

[@LukeBarousse]

Ben is the man and was a big inspiration for this project

[@bluelantern5241]

What is Ben's channel?

[@LukeBarousse]

@@bluelantern5241 www.youtube.com/@SeattleDataGuy

[@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.

[@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!

[@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.

[@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.

[@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!

[@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!

[@peterxyz3541]

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

[@jafetreyes3809]

Damn Luke you rock!!!

[@jacobnotte3699]

Sick. Thank you for making this public and updating! +1 sub

[@aumpatil6536]

Bruh, you just casually put together an actual usable product, which *also* helps the community. What a legend. Much respect! Edit: forgot to mention how well the process is documented in this video. Incredible.

[@LukeBarousse]

THanks for noticing this!! 🙌🏼

[@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! 🍻

[@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)?

[@justbelit]

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

[@mahadjamaroble1444]

Most informative 👌

[@maxpatrickoliviermorin2489]

I came across this channel yesterday, and I've already watched nearly 10 videos. You've single-handedly deepened my understanding of the entire field. This is one of the best data-related channels I've subscribed to so far. Thanks Luke Skywalker. You are an outstanding jedi trainer.😂

[@LukeBarousse]

🙌🏼😂

[@paulbuono5088]

I think there's still a disconnect between reality and web based data. What you need to do IMO is survey people who made the hiring decision do see what it was based on: experience with particular software, credential, interview skills. Thatll show you what you need to focus your attention on

[@tadiwashangwa4931]

been waiting for this video man thanks luke

[@BaldyMcRedbeard]

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!

[@deevanshisharma5036]

Amazing Video and a Great project. Good work Luke!!

[@amykostecki7789]

Wow, you are awesome!!! I got so much out of this video, every piece was helpful and educational.

[@coolstoryai]

Solid video I appreciate your hard work processing the data!

[@rexplorenow]

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

[@spaaaaace8952]

Also, superb editing, as usual!

[@blackdeath7678]

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

[@luissousa3165]

This is absolutely amazing !!

[@proteuswave]

This is radical! Great job. It certainly helped me think about potential directions as a data professional!

[@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!

[@michaelkhanwald4522]

Chills literal chills❤ The way presenting the info you collected

[@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

[@wanharris6926]

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

[@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

[@jjones503]

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

[@amberlynny]

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

[@Deya__]

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

[@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

[@CheshireArt_]

THIS IS FREAKING AWESOME DUDE!!!!! LIKED AND SUBSCRIBED

[@LukeBarousse]

Heck yeah!

[@joselixao5349]

Hey @LukeBarousse this a fantastic work. Thank you much for sharing. There're 2 things I would like to see, when it comes down to skills, what are the company sizes and or industry asking for them. What skills are most asked by Health industry or retail? I would love to get answers for that.

[@NoamGonen]

Great video! Entertaining while briefly educating - thanks!

[@johnbellebenaning1666]

Man this couldn't come with a better timing! Thank you very much!

[@Victor-yn6lv]

The process you building the data pipeline for gathering the real-world data to drive the insights into data tech job market is really amazing. Thank you for your hard work and the great video!

[@pyaeaung3997]

Thanks a lot for getting this info free

[@datasensei21]

Luke is adding so much to the community! I'm taking this moment to say THANK YOU for all the help you've been providing!

[@rohitgopinath5960]

Really loved your app, great insights, is it possible to include other job titles like Product Manager and Technical Product Manager?

[@BRIDAHECHISERA]

The way you structure the planning of your projects is amazing. Thank you so much for building this.

[@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...

[@jessegarris7037]

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

[@pancakez2181]

Thanks for doing such heavy lifting, dude! The day you posted this video I was actually scanning through data analyst job posts to reprioritize my studying, but obviously we love the hard numbers. I’m curious if skills or tools differ my industry, since I was specifically searching healthcare postings.

[@LukeBarousse]

I think they are slightly, but my data right now isn't sortable by industry. This IS something I do want to add in the future so stay tuned!

[@DynmcStudio]

The beauty of this video is that it genuinely shows the amount of work data-related work needs and that just because you get a certification it doesn't mean they'll give you the job. You have to create and show your work. Thank you for this beautiful work. I'll be using this as reference for my future work.

[@josho225]

this is ... simply stunning, great work!

[@petatownsent]

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

[@fizzy3949]

Love the subtle humour in your video! V. impressed at the work you put into this project but more than anything the insight of how this project came together is useful. As someone transitioning over, being shown examples of projects helps to put into context what the reality looks like, but also is a helpful guide to decide what types of work you might enjoy. Its an interesting project, so thanks for taking us on that journey.

[@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.

[@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.

[@rubenibarra3260]

This is one of the best videos that I've seen on this channel. Keep it up, Luke!

[@LukeBarousse]

🙌🏼

[@santiagoaristizabal944]

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

[@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

[@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.

[@vinayindoria]

Such a great work!! Some suggestions for the project, I am sure you might be already working on these: * It would be great to see the most trending tools or tools which became popular more recently(% increase in demand over month). Since the video is 2 month old, may be comparision with past data would be super handful! * It would be great to further enhance this data with a roadmap related to earnings. Mostly people lookout for a specific salary bracket and if they can just select a salary range, they can be showed with the skillset required in order to attain the same. Right now too we can get to below information but it would be great to just see it in a single glance rather than switching between multiple radio boxes. e.g: Select Salary range: 150k to 200k Languages : .. Tools: .. Cloud: ..

[@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

[@TheRomantika11]

Thank you for the labor and time you have committed for this very useful video.

[@d7oomy-964]

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

[@killjaqular]

Amazing presentation. Well spoken, delivered well, elaborated when you needed to and did so very clearly. Thank you!

[@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 !

[@dadehd09]

Love what you did and appreciate the work you put in to visualize that data!🎉😊

[@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.

[@fernando_dominguez]

Mannnn you are awesome Luke! I am 33 and started my data analyst journey 3 years ago. So far know SQL and intermediate Python (doing Python for everybody, the specialization you recommended). All this to say thank you for all your hard work and content. It's really hard to scope where to continue my journey and become much more skilled so pretty sure your website will help a ton!

[@venkatprasath01]

Wow, I was looking for a video on these topics of explaining the end to end process right from data collection and deploying it as an app, that too updating the database on a real-time basis ! This is a excellent excellent work Luke. Thank you so much for documenting it! ❤❤ Wish to see more such in-depth videos in future. Thanks once again! 🎉

[@LukeBarousse]

Glad it was helpful!

[@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!

[@raagjoshi4521]

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

[@DEDE-ix9lg]

love these videos , where u show the process. a very fun way to learn , without the discomforts. VIDEO IS INSANE Luke being Top yet again

[@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!

[@gianllucasimi]

This is absolutely fantastic! Thank you ever so much for doing all of this and, most of all, for sharing it with us, Luke. Fantastic!

[@dedpossum66]

I found this extremely informative! Thank you for documenting your work, so many of these tools look useful and are now things I’d known about earlier

[@rauhan_sheikh]

My god you really are committed to helping people. I mean no one does that much work just for a video you really care about this stuff. Thanks man

[@LukeBarousse]

Thanks for noticing this, Rauhan! 🙌🏼

[@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".

[@uubaidullah]

Excellent video, please do same for other job titles as well like DevOps, cloud engineer etc

[@svgenterprises1]

You are awesome Luke! Within the last couple of years, I have been moving into analytics more and more for my company. You and Alex have had the most helpful content hands down. Thank you for all your time and effort good sir!

[@asadon1950]

Amazing video as usual. I know we all missed your vids but the wait is always worth it.

[@greenc1088]

Thank you so much for this app and this video, mind-blowing amount of work was surely put into this.

[@mamamikazala]

such a great work! thank you!