I analyzed 2,862,763 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]

🙌🏼

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[@justbelit]

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

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

[@jafetreyes3809]

Damn Luke you rock!!!

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

[@rexplorenow]

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

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

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

[@wanharris6926]

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

[@mahadjamaroble1444]

Most informative 👌

[@jacobnotte3699]

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

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

[@Deya__]

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

[@luissousa3165]

This is absolutely amazing !!

[@peterxyz3541]

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

[@blackdeath7678]

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

[@proteuswave]

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

[@tadiwashangwa4931]

been waiting for this video man thanks luke

[@josho225]

this is ... simply stunning, great work!

[@jjones503]

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

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

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

🙌🏼😂

[@coolstoryai]

Solid video I appreciate your hard work processing the data!

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

[@johnbellebenaning1666]

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

[@diazjubairy1729]

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

[@petatownsent]

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

[@BRIDAHECHISERA]

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

[@d7oomy-964]

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

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

[@santiagoaristizabal944]

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

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

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

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

[@raagjoshi4521]

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

[@spaaaaace8952]

Also, superb editing, as usual!

[@killjaqular]

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

[@jasondaniel254]

I randomly found this on my recommended and this has to be the best thing i've watched in so long. I feel like I've found my home. This is my calling. I have to do this long term like what he just did for this youtube video is what I'd want to do for shits and giggles on any hobby or interest but I never had the skills or knew where to get them this... thank you so much and god speed

[@LukeBarousse]

Glad you found the channel Jason!

[@jasondaniel254]

@@LukeBarousse you and me both

[@deevanshisharma5036]

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

[@AngelFelizF]

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

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

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

[@amykostecki7789]

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

[@dadehd09]

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

[@rubenibarra3260]

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

[@LukeBarousse]

🙌🏼

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

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

[@jessegarris7037]

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

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

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

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

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

[@StaK_1980]

Really LOVE this video! I'd like to see this kind of breakdown on software testing. Both manual and automatic testing (and especially the skill listing on the latter) .

[@nathanielloueferandez2886]

Dude! Not only was the video very interesting and very insightful, but it was also well produced. Thanks!

[@LukeBarousse]

Thank you!!

[@CheshireArt_]

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

[@LukeBarousse]

Heck yeah!

[@kinseywk]

You really went all-out on this one. Very helpful and comprehensive. Thank you!

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

[@TheRomantika11]

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

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

[@MohamedIbrahimEid]

This an amazing clips with a lot of engagement. Thanks a lot Luke

[@pyaeaung3997]

Thanks a lot for getting this info free

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

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

[@NoamGonen]

Great video! Entertaining while briefly educating - thanks!

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

[@michaelpetersentv]

Thank you Luke for always being such a great resource for all things data!

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

[@nates3361]

This is amazing! Thank you for sharing Luke

[@felipevic27]

awesome! thanks for detailing how you did the project, it's very helpful for us to gather the pieces together

[@ashleygesty7671]

Wow your communication and data skills are on another level!

[@Memeparable]

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

[@gaboceron100]

Amazing job! Thank you! Great way to support which skills are needed in the industry. Just what I needed! 👏

[@ChristianEriksson83]

This is freaking awesome! I get so pumped after seeing your videos! Great content nerd!

[@LukeBarousse]

Thanks Christian!

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

[@andreynesterov1116]

Outstanding work, Luke. Thanks for sharing!