FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work ๐Ÿš€ @chandoo_
FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work ๐Ÿš€  @chandoo_
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
FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work ๐Ÿš€How to Self-Join Tables in Power Query [Step-by-step Tutorial]Using WRAPROWS to Reshape Data (NEW Function ๐Ÿคฏ) #excelHow I Use AI To Work Smarter Every Day as a Data AnalystStop making boring column charts in Power BI - Do this instead ๐Ÿ’กHonest review of Excel CoPilot - What it can and cannot do ๐Ÿค–Excel Pivot Tables - Master Data Analysis in just 45 minutes
Chandoo |

FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work ๐Ÿš€

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER