Today i would like to discuss about the Pivot/Un-Pivot Columns feature easily in BI Tools (Power BI, Tableau, MicroStrategy, Qlik).
Data is looking like below for example that we bring into data modeling interface in any BI tool (via Self Service approach)
Current Table Structure – Where YEARS are in columns instead of ROWS
We need to pivot them as below
You can see the expected way of data format in tabular structure
Now, lets see how can we do this on different BI tools & see who wins the race in the end to achieve this – Ready ?? !! Let’s go
- Power BI
I will be using World Population data
Power BI – Microsoft
Who wins in this race ? 🙂 Comment your views lets hear it out!!!
My answer is each of the tool is equally easy to set this up. All win the race equally 🙂
Thanks for reading! Enjoy the day!!