UNPIVOT: Data Cleaning Power Tricks 💡

[@liliancruz5276]

Thank you so much! If you ever come to NYC or NJ to do a workshop I will be the first one signing up. All your videos are amazing! You go direct to the point and make it so easy to understand. Thank you 🙏🏽

[@tridibbiswas3361]

Another Awesome Video. You make learning so simple. Thank you for your time and effort. This is something I was looking for the past year without any luck.

[@nelsonmotivation]

Unpivot saves alot of time and energy. Thanks for sharing your knowledge with the world Chandoo.

[@nim3186]

Oh my gosh!! Why I’m just learning this? Thank you!

[@ashokkumarpadmanabhan6483]

Excellent Explanation !!! Appreciated your effort of preparing & sharing

[@SandipanSarkar-c8v]

Finished watching

[@canirmalchoudhary8173]

Nice learning on Power query

[@abbottkatz8830]

Great tips, one which works within Excel (i.e. transforming an "unpivoted" data set.

[@chrism9037]

Great video Chandoo!

[@ysantosh]

Fair explanation, simple thank you chandoo anna.

[@EDM179]

Chandoo thank you!

[@BiggBrro]

The easy way to understand these typical transformation is to first design these transformation in your mind!

[@vigneshm1060]

Thanx Dr, very useful. Am a beginner.

[@bichnhatpham2]

exactly what I'm looking for

[@ngwafabrice9561]

Hey Chandoo bai, can you please do a data anlaysis on power bi for a snagging company with datasets from construction or engineering, these has no videos on KZbin.

[@TariqMajeed-ng3id]

Quote informative @Chandoo sir

[@shebelieveshecan]

Wow this is really helpful ❤

[@vargheseantony5677]

Thank You ❤

[@andrewjason3756]

Hello Chandoo is there any limitations of excel when using on a MAC book compared to a windows laptop. Like any restrictions on power query

[@MattP79]

Yes. Excel on Mac is missing many features.

[@rajarathinam365]

Thanks sir, it's really awesome. Sir if possible unpivot data format change to pivot format ??

[@cabenzeneyou]

Thank you Chandoo. It's an awesome trick. Do you have an example only by using Excel ?

[@chandoo_]

The process is same even in Excel. Just load the data to Power Query (from Data ribbon) and rest is exactly as demoed in the video.

[@kothapallibhaskar5430]

Hi Anna. Please help to know the next tools or career developments after Power bi developer /Data Analyst .

[@saumyajoshi-ym2os]

Sir is leetcode required for SQL hands-on to crack the interview as a data analyst fresher

[@saumyajoshi-ym2os]

Sir i have 2 year workexperience in java developement in IT company My doubt is if i clear data analyst interview then will they ask me the questions regarding my java profile experience???

[@BhaskarReddy-bv3ls]

I got error problems in power bi, failed to save modifications to the server. Error returned: the following system error occurred: class not registered. The error shows like this please how to solve this problem help me brother

[@dprocks998]

Hi. How I can connect you

[@mostafahwafy]

could you answer me on this question plz: i want to highlight top 3 in pivot chart with every drill down is that possible ? thank you for all your information you sharing🤗

[@deaspirant]

Can anyone let me know how to do the same in sql while data coming from tables

[@database_tips_tricks]

Unnest(array[columns]) in postgresql

[@harshateluguvolga7416]

Power bi Telugu plz sir