How to transform data from SurveyMonkey with Excel, PowerQuery, PowerPivot.
ฝัง
- เผยแพร่เมื่อ 31 ก.ค. 2024
- 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: • Day in the Life of a D...
LinkedIn: / vasyl-salyk - วิทยาศาสตร์และเทคโนโลยี
![[ไฮไลต์] แบดมินตันชาย วิว กุลวุฒิ ไทย vs ฟินแลนด์ รอบแบ่งกลุ่ม | โอลิมปิก 2024](http://i.ytimg.com/vi/GIbeFO0tvnQ/mqdefault.jpg)
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!
This is some serious Excel :D thanks Vasyl for sharing
My mind is too blown! Please make more videos using excel. Wow.
Thank you very much for sharing. Your English is great, don't worry about it.
This is an extremely useful video! Thank you for sharing. Looking forwards to more of your videos!
Awesome job! Thanks for sharing! Really helped me! :D
Great job, Vasyl!
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.
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.
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
thanks a lot, this video really helpful, please continue this content in the future.
MIND BLOWING!!! SUBSCRIBED
Very good video, thank you so much
Amazing video!! Please do more video similar to this.. valuable content. Thank you and don't stop :)
I think this is better and very efficient thank you for sharing
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.
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.
Очень хорошее видео, и английский у тебя неплохой
Wow! Excel is STRONG!
Keep this up. U got a subscriber
This was a great video, makes python looks easier tho, hahah ;P
kudos on making the video !!!
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.
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
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.
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
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.
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 .
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
Please make a detailed video.
Hi, I will. If you'll let me know what details you need.
Did u try creating dashboard
Hello…I need some assistance in exporting my data from survey monkey please
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
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
Is there a download of the raw file?
Here is the link to the source files github.com/kshashank03/Survey-Monkey-Tutorial/find/master
нормально так шпаришь на инглише. по крайней мере, я всё понимаю) и чё норм можно зарабатывать аналитиком данных?
Привіт! Дякую за відгук. Так, аналітиком даних можна заробляти. Питання в тому, що для кожного "норм" це різні цифри )))
@@vasylsalyk165 ну 4-5к зелени в месяц поднять получится?
@@mcarwa звичайно, все залежить від роботодавця
@@vasylsalyk165 круто. и сколько вы уже в этой сфере крутитесь? вы программист изначально?
I would appreciate it if I can get a response from you :cccc