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 minutes ( Download)
- Power Query - Beginner To PRO Excel MASTERCLASS in 30 Minutes: Import & Transform Data Tutorial ( Download)
- ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024) ( Download)
- Learn Power BI in 30 minutes and build your first dashboard 🚀 ( Download)
- Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- Power BI Full Course in 8 Hours | Power BI Tutorial for Beginners | @PavanLalwani ( Download)
- Power BI Dashboard for Beginners - COMPLETE MASTERCLASS (with sample file 📁) ( Download)
- Power BI Full Course in 6 Hours | Learn Power BI for Beginners with Project - 2024 Edition ( Download)
- Power BI Tutorial for Beginners ( Download)
- PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples ( Download)
- MS EXCEL Full Course for Beginners in 3 HOURS (FREE) - 2024 Edition ( Download)
- Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!) ( Download)
- [[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner ( Download)
- How to Analyze Data with Power Query, Power Pivot & Power BI - Free Masterclass ( Download)
