Power BI: cleaning and transforming financial data in Power Query
Finance professionals spend a lot of their time cleaning data imported from different sources. It is not that data is necessarily inaccurate, it is just presented in a wrong format to make any sort of meaningful analysis right away.
Power Query comes as a help for us to clean this data and make sense of it. The Power Query editor has some powerful tools for cleaning data imported from a variety of sources and finance professionals will appreciate some of these functions.
In this video, we focus on the use of the powerful transpose function, which rotates a table by 90-degrees, changing the position of rows and columns. This can be helpful in situations when there is a need to stack up row values on top of each other, turning them into columns.
Read a full article here: https://bit.ly/2yZilJ7
#PowerBI #PowerQuery #Transpose #Finance #Data #Excel