Kaggle Dataset - Data Transformation using Power Query

Continued from our previous video below, we look at some Data Transformation questions and how you can use Power Query to transform data Timestamps 1:04 - Question 1 2:30 - Question 2 7:37 - Question 3 using Power Query Link to previous video: https://www.youtube.com/watch?v=TDpX8o6YplU&t=39s You can also find the dataset on Kaggle below https://www.kaggle.com/datasets/sidgha/occupation-shortage-list-australia-2021-to-2024 About me and my channel (My name is Sid, I am currently a Data/Business 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/