Kaggle Dataset Competition Tutorial using Excel for Data Analysis - Jobs Data in Australia - Part 1

We revisit Kaggle and this time explore jobs data from Australia. Great for those who want to build data analysis skills for Beginner/Intermediate users 1:49 Exploring the dataset 4:28 Q1 (Easy) - How many occupations are listed in total across 2021–2024 6:13 Q2 (Easy) - Which skill level has the most shortages overall Nationally? 8:06 Q3 (Medium) - How many roles in Northern Territory have a skill rating of 2 or more in 2024 that are in Shortage? 9.39 Q4 (Medium) - Between 2021 to 2024, which state saw the biggest rise in jobs with Shortages? 12.56 Q5 (Hard) How many roles in NSW were in shortage in 2021 and still in shortage in 2024? 18.23 Q6 (Hard) Following on from Q5, which of the same roles above are also seeing a shortage in Tasmania for 2024? Data set here: https://www.kaggle.com/datasets/sidgha/occupation-shortage-list-australia-2021-to-2024 Part 2 also available below: https://www.youtube.com/watch?v=1Th99bFTuc0&t=186s About me and my channel (My name is Sid, I am currently a Data Analyst based in London, UK and I have been working in Data Analytics for over 7 years. Follow me for more Data related content.) Some of my other popular videos: Kaggle dataset analysis using Jobs data: https://youtu.be/TDpX8o6YplU How to become a Data Analyst in 2024: https://www.youtube.com/watch?v=M-_nODeA8Qw&t=35s 5 Common Data Analysis Mistakes (and How To Avoid Them!): https://www.youtube.com/watch?v=_iB9161ZQwA Interviews I did in the last few years: HSBC Bank: https://www.youtube.com/watch?v=Q9u1ePOE9-8 FAB Bank: https://www.youtube.com/watch?v=R52ccyoAg_U&t=871s JPMorgan Chase: https://www.youtube.com/watch?v=x5KrfIZA5Pk Follow me on social media here: LinkedIn: https://www.linkedin.com/in/sid-skills/