UNPIVOT: Data Cleaning Power Tricks 💡

Unpivoting is an extremely valuable feature of Power Query. It can take report style data and turn it into usable tabular format. In this video, let me introduce Unpivot with two practical examples.

Download the sample data file from here - https://chandoo.org/wp/wp-content/upl...

WATCH NEXT:

Budget vs. Actual Variance Analysis with Power BI -    • Data Analysis with Power BI - from st...  

MORE ON POWER QUERY:

💥Learn Power Query essentials in 1 hour - https://chandoo.org/wp/power-query-po...

Power Query - Basics:    • Learn Power Query & Automate Boring D...  
Power Query - Deep introduction:    • Power Query Tutorial - What is it, ho...  
Power Query - 5 Advanced Examples:    • FREE Power Query Materclass with 5 Ad...  
10 Timesaving tricks with Power Query:    • 10 Ways to save time & Automate tasks...  
Power Query vs. Power Pivot vs. Power BI:    • The truth about Power BI (and how to ...  



~

In this video:
0:00 - Unpivot, why we need it?
0:27 - Trick 1: Unpivot budget data
2:58 - Trick 2: Unpivoting two-level data
4:29 - Budget vs. Actual Variance Analysis

~

What does the baker do half way thru baking the bread?
She BUNPIVOTS 😂