How to transform data from SurveyMonkey with Excel, PowerQuery, PowerPivot.

[@ShashankData]

Awesome stuff! And yes that pronunciation of my name is actually perfect! Your English is excellent and your explanation of this is perfect! Thank you for seeing an opportunity to provide more knowledge to the world and taking advantage of it!

[@vasylsalyk165]

Thank you for that opportunity. Since I'm learning both Python and R your video also was very helpful and inspiring!

[@taricov4662]

This is some serious Excel :D thanks Vasyl for sharing

[@jasonyang474]

This is an extremely useful video! Thank you for sharing. Looking forwards to more of your videos!

[@AnyFactor]

My mind is too blown! Please make more videos using excel. Wow.

[@furtadomd]

Thank you very much for sharing. Your English is great, don't worry about it.

[@deepaklekhwani]

Great work I was casually surfing through yt and found Shashank's video and then your both of you gave great perspectives of solving a problem I am a subscriber now thank you

[@sunnyshounok7171]

Very good video, thank you so much

[@Ben-xw5uo]

Amazing video!! Please do more video similar to this.. valuable content. Thank you and don't stop :)

[@AnyFactor]

Great job, Vasyl!

[@amospeter5603]

Please can you make more videos? This was very helpful. I will also love to see the detail explanation of each step. Thank you for this, it was very helpful.

[@denellivillanueva]

Thank you so much for sharing this! I am not yet well-versed in python, so this video helps a lot! Your explanation is really good and easy to understand. Consider me as a new subscriber. Please share more tutorials like this.

[@manuelcolaco9175]

Thanks. I hope to see more videos from you. I am the 4th subs

[@vasylsalyk165]

Than you. If you have some cases related to data analysis for discussion in next videos, pls share with me.

[@EnochAppiah]

Good job done Vasyl!. One thing I like about PowerQuery and PowerPivot is the ability to easily automate the same task again on similar data since it creates the process flow for you. I use it a lot for my work and it's a lifesaver when combined with power automate 👍🏽. We need more using this tool.

[@unwind3413]

I think this is better and very efficient thank you for sharing

[@rosalee7517]

thanks a lot, this video really helpful, please continue this content in the future.

[@maxmouse2004]

Awesome job! Thanks for sharing! Really helped me! :D

[@sulaimanahmed013]

Wow! Excel is STRONG!

[@irohaemmanuellawrence2520]

MIND BLOWING!!! SUBSCRIBED

[@hongmeixie409]

Great. Can you do a video on how to analyse and visulize the clean data in Power BI? That will be very useful for understanding survey results. Many thanks

[@jevudi6746]

Очень хорошее видео, и английский у тебя неплохой

[@pinakroy5130]

Please make a detailed video.

[@vasylsalyk165]

Hi, I will. If you'll let me know what details you need.

[@soms42]

This was a great video, makes python looks easier tho, hahah ;P kudos on making the video !!!

[@yenikacarlex484]

Thanks for this video. I am very much interested in seeing further how you continue to build a dashboard with this in powerBI or some other data visualisation platform.

[@TopFusionTv]

Keep this up. U got a subscriber

[@got1828]

Thank you for this Very useful video, please can you make some other videos regarding power query and power pivot it will be helpful. Thanks again lol

[@tesma-m7]

How can I do a 2:1 match and match for obvious characteristics , say for eg T3 and G1..... , its on the spreadsheet i created , as I need to do an internal match analysis for people with changes on t3 or g1 with start date of the treatment i am using ….need advice .

[@fakerrain]

This is really good! I've been looking for something like this. What resources did you use to learn Power Query/Power pivot?

[@vasylsalyk165]

Very first resource is (boring) official documentation. 2nd is the videos on KZbin. 3rd type or recourses are topic related forums.

[@asmaaljneibi6974]

Dear @Vasyl Thank you for this video it is really helpful! Everything worked well for me except for "grouping step" 11:51 I clicked ok but an error appeared saying "DataFormat.Error: Invalid cell value '#NAME?'." Please help me as soon as possible

[@anandbihari3135]

Did u try creating dashboard

[@KN-fk9lj]

If I wanted to know the question most answered. How do I do that? Ranking the questions most answered to analyse which question was more interesting.

[@joaopedrosenna1]

Is Power Query the best ETL tool? For a data engineer purpouses

[@10jit]

how to this on excel with just excel functions and not power query ?

[@ayanbose9626]

sir one request if possible please start teaching us power query and power pivot we you tube and world citizen will be grate full but if you don't that much time please at least suggest some playlist or channel to learn and master these Regards Ayan

[@vasylsalyk165]

I'm planning to record (and currently recording) some learning videos regarding Power Query techniques which are applicable for both Excel and Power Bi

[@NiambiAmina]

Hello…I need some assistance in exporting my data from survey monkey please

[@cyclingmc]

Is there a download of the raw file?

[@vasylsalyk165]

Here is the link to the source files github.com/kshashank03/Survey-Monkey-Tutorial/find/master

[@mcarwa]

нормально так шпаришь на инглише. по крайней мере, я всё понимаю) и чё норм можно зарабатывать аналитиком данных?

[@vasylsalyk165]

Привіт! Дякую за відгук. Так, аналітиком даних можна заробляти. Питання в тому, що для кожного "норм" це різні цифри )))

[@mcarwa]

@@vasylsalyk165 ну 4-5к зелени в месяц поднять получится?

[@vasylsalyk165]

@@mcarwa звичайно, все залежить від роботодавця

[@mcarwa]

@@vasylsalyk165 круто. и сколько вы уже в этой сфере крутитесь? вы программист изначально?

[@asmaaljneibi6974]

I would appreciate it if I can get a response from you :cccc