- 1
- 22 311
Vasyl Salyk
เข้าร่วมเมื่อ 31 ต.ค. 2013
How to transform data from SurveyMonkey with Excel, PowerQuery, PowerPivot.
I decided to create this video when I found a great video lesson from @Shashank Kalanithi on how to transform the data from the SurveyMonkey survey using excel, python, and Pandas library.
Link to the original video: th-cam.com/video/pKvWD0f18Pc/w-d-xo.html&
LinkedIn: www.linkedin.com/in/vasyl-salyk/
Link to the original video: th-cam.com/video/pKvWD0f18Pc/w-d-xo.html&
LinkedIn: www.linkedin.com/in/vasyl-salyk/
มุมมอง: 22 315
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.
I would appreciate it if I can get a response from you :cccc
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
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 .
Wow! Excel is STRONG!
Hello…I need some assistance in exporting my data from survey monkey please
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
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
Very good video, thank you so much
Amazing video!! Please do more video similar to this.. valuable content. Thank you and don't stop :)
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.
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.
how to this on excel with just excel functions and not power query ?
Очень хорошее видео, и английский у тебя неплохой
Is Power Query the best ETL tool? For a data engineer purpouses
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
нормально так шпаришь на инглише. по крайней мере, я всё понимаю) и чё норм можно зарабатывать аналитиком данных?
Привіт! Дякую за відгук. Так, аналітиком даних можна заробляти. Питання в тому, що для кожного "норм" це різні цифри )))
@@vasylsalyk165 ну 4-5к зелени в месяц поднять получится?
@@mcarwa звичайно, все залежить від роботодавця
@@vasylsalyk165 круто. и сколько вы уже в этой сфере крутитесь? вы программист изначально?
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.
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.
My mind is too blown! Please make more videos using excel. Wow.
Great job, Vasyl!
Did u try creating dashboard
Keep this up. U got a subscriber
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
I'm planning to record (and currently recording) some learning videos regarding Power Query techniques which are applicable for both Excel and Power Bi
MIND BLOWING!!! SUBSCRIBED
thanks a lot, this video really helpful, please continue this content in the future.
Is there a download of the raw file?
Here is the link to the source files github.com/kshashank03/Survey-Monkey-Tutorial/find/master
This is really good! I've been looking for something like this. What resources did you use to learn Power Query/Power pivot?
Very first resource is (boring) official documentation. 2nd is the videos on TH-cam. 3rd type or recourses are topic related forums.
This was a great video, makes python looks easier tho, hahah ;P kudos on making the video !!!
Please make a detailed video.
Hi, I will. If you'll let me know what details you need.
Awesome job! Thanks for sharing! Really helped me! :D
This is an extremely useful video! Thank you for sharing. Looking forwards to more of your videos!
I think this is better and very efficient thank you for sharing
Thank you very much for sharing. Your English is great, don't worry about it.
Thanks. I hope to see more videos from you. I am the 4th subs
Than you. If you have some cases related to data analysis for discussion in next videos, pls share with me.
This is some serious Excel :D thanks Vasyl for sharing
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!
Thank you for that opportunity. Since I'm learning both Python and R your video also was very helpful and inspiring!