5 Advanced Tips to Speed up your Data Tasks (works in Power BI or Excel)

Merci ! Partagez avec vos amis !

Vous avez aimé cette vidéo, merci de votre vote !

Ajoutées 1 année by admin

88 Vues

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 https://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 - https://youtu.be/PiFAa_jjaEI
Live stream with 10 examples - https://youtu.be/t43kb7BRsFY
Full course - https://chandoo.org/wp/power-query-power-course/

#powerquery #powerbi