Power Query - Beginner to PRO Masterclass in 30 minutes @chandoo_
Power Query - Beginner to PRO Masterclass in 30 minutes  @chandoo_
Uploaded August 2024 | Updated November 2026, 2 hours ago
Learn Power Query in 30 minutes.
Sample file: 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: en.wikipedia.org/wiki/2020_Summer_Olympics_medal_table
Staff data file: chandoo.org/wp/wp-content/uploads/2024/08/sample-staff-data.xlsx

Completed file: chandoo.org/dac
Free Data Analyst course: 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: chandoo.org/dac

Check out the playlist - youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO


🤖 More Power Query
==================

Power Query masterclass (90 mins) - youtu.be/PiFAa_jjaEI
Power Query in 15 minutes - youtu.be/UAFExySaSPY
Power Query and automation (2 hours) - youtube.com/live/t43kb7BRsFY?feature=share

Power Query mini-course - chandoo.org/wp/power-query-power-course
Power Query + Advanced Excel Course - chandoo.org/wp/excel-school-program

~

#powerquery #chandoo #freedataanalystcourse #fdac
Power Query - Beginner to PRO Masterclass in 30 minutesThe little known BYROW function changes how you write formulas in Excel 🤫Mind-blowing Excel Trick - MODE for TEXT VALUES!How to make payroll & pay slip calculator in Excel (with sample file 📄)How to Analyze Data with Power Query, Power Pivot & Power BI - Free MasterclassHow to make a Thermometer Chart in Power BI ~ Easy Tutorial10 things my boss struggles to do in ExcelWHAT? Pivot with an Excel Formula 😲Power Query vs. Python - Soccer Data Cleaning Challenge ⚽🥅AI Jargon Confusing you? A No-Nonsense guide to understand top AI termsHow to find Outliers in Your Data Easily with Z-Scores in ExcelCreate your first Power BI APP in 5 minutes!
Chandoo |

Power Query - Beginner to PRO Masterclass in 30 minutes

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER