Power Query - Beginner to PRO Masterclass in 30 minutes

Learn Power Query in 30 minutes. Sample file: https://chandoo.org/dac ~ In this video, you will learn: Why Power Query is the best feature in Excel and Power BI Webscraping with Power Query Understanding the PQ Editor Screen Data cleaning with Power Query editor Fill down operation (dealing with nulls) Adding columns Filtering the data Find / replace values Trimming data Column Quality Indicators Adding column based on rules (conditional column) Fixing date format issues Splitting First and Last name Writing M code to create columns Calculating tenure from start date Updating and refreshing the data 📁 Sample File ============= Web scraping: https://en.wikipedia.org/wiki/2020_Summer_Olympics_medal_table Staff data file: https://chandoo.org/wp/wp-content/uploads/2024/08/sample-staff-data.xlsx Completed file: https://chandoo.org/dac Free Data Analyst course: https://chandoo.org/dac ⏱ Video topics: ============= 0:00 - Why Power Query is important? 1:46 - Web scraping with Power Query 4:54 - Understanding the Power Query Editor (PQE) 7:33 - Data cleaning the web scraped data 13:36 - Loading the data to Excel 15:43 - Business Data with Power Query 17:50 - Data cleaning staff data 24:55 - Cleaning "dates" with Power Query 26:15 - Splitting first and last name 28:25 - Bucketing salary values 30:25 - Calculating the "tenure" of the employee 31:54 - Writing M code yourself - simple example 33:35 - Closing and loading the data (and refresh process) 📺 More videos - FREE Data Analyst Course: ===================================== Course page: https://chandoo.org/dac Check out the playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO 🤖 More Power Query ================== Power Query masterclass (90 mins) - https://youtu.be/PiFAa_jjaEI Power Query in 15 minutes - https://youtu.be/UAFExySaSPY Power Query and automation (2 hours) - https://youtube.com/live/t43kb7BRsFY?feature=share Power Query mini-course - https://chandoo.org/wp/power-query-power-course/ Power Query + Advanced Excel Course - https://chandoo.org/wp/excel-school-program/ ~ #powerquery #chandoo #freedataanalystcourse #fdac