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_Su...
Staff data file: https://chandoo.org/wp/wp-content/upl...

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 -    • FREE Data Analyst Course  


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

Power Query masterclass (90 mins) -    • Power Query Tutorial - What is it, ho...  
Power Query in 15 minutes -    • Learn Power Query & Automate Boring D...  
Power Query and automation (2 hours) - https://youtube.com/live/t43kb7BRsFY?...

Power Query mini-course - https://chandoo.org/wp/power-query-po...
Power Query + Advanced Excel Course - https://chandoo.org/wp/excel-school-p...

~

#powerquery #chandoo #freedataanalystcourse #fdac