I analyzed 2,805,490 jobs to solve THIS
HTML-код
- Опубликовано: 6 окт 2024
- 📲 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 
Хобби
![Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡](http://i.ytimg.com/vi/5X5LWcLtkzg/mqdefault.jpg)
Do this for every major job category, and you’ve got yourself a full blown company
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.
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.
Congrats on finishing the certificicate!
Congrats! I finally finished today as well. I wish you the best of luck in getting that first data role.
Congrats! I am on course 8 at the moment. Hopefully will finish in March 😊
Congrats and good luck!
@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
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
Thanks for noticing this, Adir! Appreciate you!
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.
The sheer amount of work that went into this is mind-boggling. Thanks for all you do, Luke.
🙌🏼
This is brilliant Luke !!!!
For all the students, this is how you structure a project! Take cues!
Problem, plan, execute, visualize, insights and conclusion.
Thank you!!
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 🙏
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.).
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!
Thanks, Zac! Hope it gets put to good use!
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
This is such an amazing video - so appreciate the amount of work that must have went into this 💪💪 your videos deliver so much value!!
🥹 Aw Tina, thank you so much! 🙌🏼
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!
Thanks for noticing this Eimantas! Appreciate it!
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 RUclips. Thanks Luke.
I appreciate that! 🙌🏼
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. ❤
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
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.
Heck yeah! Subscribers like you are why I did this project, so thanks Thiago!
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!
@@svgenterprises1 It's pretty good to hear that you feel ready to work and that we've got the same senseis
Godspeed, bud!
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!
@@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.
The amount of work and effort that went into this project is mind-blowing. Thanks, Luke for this hard work helping the data community.
Luke, thank you for an explanation on how to build a data pipeline and then how to analyze the data!
Heck yeah! Thanks for making this project possible by providing the search credits!! 🙌🏼
@@LukeBarousse Tell done both of you and special thanks to SerpApi for making it possible.
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!
Ben is the man and was a big inspiration for this project
What is Ben's channel?
@@bluelantern5241 www.youtube.com/@SeattleDataGuy
as a data guy, I can't stress enough how thorough and insightful this is, definitely Luke is setting the standard, kudos!
Thanks Pedro!
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 🙏
Thank you shipmate and congrats on finishing up the bootcamp!
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.
Thanks for noticing this, I put a lot of time into editing; so I appreciate your comment!
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.
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.
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!
wow. the amount of work and information in just 15 minutes! thank you. this is beyond helpful
Your videos amaze me. The amount of time and effort you've put into this one is mind boggling. Also, your visualizations are hilarious!
Speechless! That’s how amazing and helpful it is for data nerds!!!
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
Amazing project! Thanks !
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.
The site is no longer showing the skills and titles etc along the graph
would be cool if we could enter any job posting titles
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.
This video deserves so many more views. Grade A work sir!
Damn Luke you rock!!!
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! 🍻
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.
THanks for noticing this!! 🙌🏼
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.😂
🙌🏼😂
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.
Thanks for these suggestions! Adding it to the list to see what I can change for v2!
Luke - thank you! This is extremely valuable and I wish more people watch this.
Most informative 👌
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)?
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.
More on the way!
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
Chills literal chills❤
The way presenting the info you collected
Luke, excellent review. Idea: 1) comparison of tableau vs power bi , 2) influence of NLP TOOLS on skill sets , salary etc over time.
I have a video on tableau vs power bi. Let me see about idea 2; I like it!
Amazing! I wish you could apply these tools to other job fields! Not a data analyst myself, just interested.
Excellent video, please do same for other job titles as well like DevOps, cloud engineer etc
WOW, Actually this is one of the most impressing projects I've ever seen, Bravo man!
The moamst comprehensive and legitimate channel related to data analyst role, damn, this project is so cool
This is one of the best videos that I've seen on this channel. Keep it up, Luke!
🙌🏼
We are sooo Lucky to have you luke 😊
Make it so easy for us now 🙏🏻
Thank You Luke. One Suggestion: Can you please make this into an end-to-end project course. We can get some valuable hands on experience on this amazing project and also pay for the course.
Let me see what I can do on this!
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!
I appreciate this 🙌🏼 felt bad for taking so long with this one, but knew it would be worth the wait
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!
This is crazy! Please build something similar for Software Engineers
By far the most insightful video on data careers, that I have seen. Thank you.
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!
You are a true gem, Luke. Thank you for the transparency and hard work!
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.
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!
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
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
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.
Man this couldn't come with a better timing! Thank you very much!
Great video. So helpful seeing the whole process of a project like this and finding out about new tools such as Serp api, Apache Spark and Airflow. The only thing I didn't like about this video was the news that remote jobs were not in demand. For me, that's the main reason why I didn't continue with data science after doing the Google Certificate. For me, as I only have one leg, hopping on the bus each day isn't much fun - only joking but remote working is definitely a must.
You're the real OG Sir.
We newbies and learners always grateful.
Thanks a bunch.
You could include some R libraries like: tidymodels, h2o, shiny, modeltime, quarto, rmarkdown, ggplot2, data.table, tidyverse, stringr and plumber
Bro, its awsome the work you did. It will help me a lot. World needs more people like you.
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!
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.
as always you went above and beyond, thank you
Wow your communication and data skills are on another level!
This an amazing clips with a lot of engagement. Thanks a lot Luke
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.
Congrats on the first data job Kris!
The ANIMATION & graphics is hilarious AND illustrative. Easy to understand. Thanks 😂👍🏼
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
Glad you found the channel Jason!
@@LukeBarousse you and me both
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.
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
This is radical! Great job. It certainly helped me think about potential directions as a data professional!
Love what you did and appreciate the work you put in to visualize that data!🎉😊
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.
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.
Amazing presentation. Well spoken, delivered well, elaborated when you needed to and did so very clearly. Thank you!
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.
Respect as to what you have pulled out of this, Luke!!
Just discovered your channel, I love it. Thank you for your work
Great job! Thank you for your work Sir!
Dude! Not only was the video very interesting and very insightful, but it was also well produced. Thanks!
Thank you!!
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.
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
Never been more impressed with a RUclips video. Great stuff!!
The new vid we’ve been waiting for!!!!
Only took 3 months! 😘
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: ..
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! 🎉
Glad it was helpful!
The way you structure the planning of your projects is amazing. Thank you so much for building this.
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.
Damn. You set the bar high now. Wish I could something like this one day.
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...
Valuable content, thanks for publishing this Luke!
You're fucking crazy bro! Salute for all the hard work actually put in this.
Great work. As a senior IS major this is very helpful! The video deserves more views given the work you've put in.
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) .
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
Great video Luke. This will be such an amazing tool. I jut had one question: How did you deal with different currencies in the salaries?
Based on the searches coming from the US (how I had it configured) it converted everything to USD automatically.
4:14 OH GOD MY HEARTRATE JUMPED WITH THE TEAMS CALL SOUND
Outstanding work, Luke. Thanks for sharing!