Uploaded April 2023 | Updated November 2026, 1 day ago
Learn 5 advanced tricks to speed up your data tasks in either Excel or Power BI. We are going to look at Power Query tricks to automate and boost your data management tasks.
โฑ IN THIS VIDEO ๐
================
0:00 - Welcome to the live stream and topic explanation
13:14 - The 5 Data Tasks - a close look at the data and the problems
20:53 - Loading the data and opening Power Query Editor
22:05 - Data Task 1 - Unpivoting the Budget Data
36:10 - Data Task 2 - Unpivoting the 2 level Budget Data
40:00 - Data Task 3 - Unstacking the data (both Excel and PQ approaches)
1:09-:15 - Data Task 4 - Unstacking the messy data
1:18:50 - Data Task 5 - Merging Data when it is messy
1:29:55 - Unstacking messy data with Excel (Data Task 4)
๐ป DOWNLOAD SAMPLE DATA FILE ๐
================================
Visit chandoo.org/wp/wp-content/uploads/2023/03/Advanced-PQ-Examples.xlsx to download the sample data file.
To know more about Power Query, watch these long-form videos:
Deep introduction - youtu.be/PiFAa_jjaEI
Live stream with 10 examples - youtu.be/t43kb7BRsFY
Full course - chandoo.org/wp/power-query-power-course
#powerquery #powerbi
Learn 5 advanced tricks to speed up your data tasks in either Excel or Power BI. We are going to look at Power Query tricks to automate and boost your data management tasks.
โฑ IN THIS VIDEO ๐
================
0:00 - Welcome to the live stream and topic explanation
13:14 - The 5 Data Tasks - a close look at the data and the problems
20:53 - Loading the data and opening Power Query Editor
22:05 - Data Task 1 - Unpivoting the Budget Data
36:10 - Data Task 2 - Unpivoting the 2 level Budget Data
40:00 - Data Task 3 - Unstacking the data (both Excel and PQ approaches)
1:09-:15 - Data Task 4 - Unstacking the messy data
1:18:50 - Data Task 5 - Merging Data when it is messy
1:29:55 - Unstacking messy data with Excel (Data Task 4)
๐ป DOWNLOAD SAMPLE DATA FILE ๐
================================
Visit chandoo.org/wp/wp-content/uploads/2023/03/Advanced-PQ-Examples.xlsx to download the sample data file.
To know more about Power Query, watch these long-form videos:
Deep introduction - youtu.be/PiFAa_jjaEI
Live stream with 10 examples - youtu.be/t43kb7BRsFY
Full course - chandoo.org/wp/power-query-power-course
#powerquery #powerbi
![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)




