I am sure people spend more time and effort cleaning and organizing their data when they need to perform data analysis in Excel, Power BI or any other tool. You do not always receive data in tabular and normalized formats for you to straightaway use the analysis tools like Pivot Tables, Filtering, Chatting and data modeling in Excel. Power Query introduces some powerful yet simple functions that make your data transformation super easy.
Following three videos will demonstrate how different data transformations are carried out and will give you a good understanding of the functions such as PIVOT, UNPIVOT and TRANSPOSE.
I have started sharing my videos through a YouTube channel and appreciate your support if you could subscribe and support me in sharing my knowledge. Thanks again!
Video # 1 : Simple Columns to Rows Transformation
Video # 2 : Unpivot Multi Header Data in Power Query
Video # 3 : Pivot Rows to Columns in Power Query
I hope you found these videos useful and learned some new data transformation techniques as well. Please leave your comments and questions below.
Have a nice day!
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s Saudi Arabia as the Head of ERP and Business Intelligence. He is interested in everything data-related, he likes to share his passion and knowledge with the data community.