What is Excel Power Query AND Why it Matters to You!

[@DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68

[@minecraftmike5193]

Why have you stopped posting?

[@UlyssesHaq]

Power Query is INSANELY powerful, and most Excel users and enthusiasts don't realise that this amazing tool sits right under their noses! M-code is powerful. DAX is powerful. PowerQuery consolidated files work HARMONIOUSLY with PowerBI and cloud bases MS apps. So much potential is unlocked. I hope this video spreads far and wide. Loving the channel and the content. Thank you!

[@DaveOnData]

Thank you for offering your experience to the conversation! Haven't gotten into DAX myself as of yet, but Power Query is a game-changer for Excel-based analytics scenarios.

[@dapperlink]

Oh, I believe you! Changed my life forever!

[@tubeampsrule1]

It's like you read my mind. I was just thinking of how to use PQ for the cluster analysis video you had made

[@DaveOnData]

Awesome! Glad you liked the video.

[@VKjkd]

What a great idea for a video. K means vie power query. Excellent content, well done and thanks.

[@hiteshpandharkar4631]

Awesome setup for the series David.

[@DaveOnData]

Thank you! I was wondering how folks might react to my thoughts on Power Query. 😁

[@jamesbedro2281]

i love your videos david, there is soo much information and enthusiasm in it. Im studying analytics right now and i would like some advice if i would need to study the basics of excel or jump in to power query?

[@vijayarjunwadkar]

Thank you David! I chanced upon your channel, when I was looking for Advanced Analytics using Excel and I am really glad I did! Now looking forward eagerly for the Power Query series which I am sure will help many get the best out of Excel analytics! Great going! Cheers! 😊👍

[@DaveOnData]

Thank you so much or the feedback! My goal is to create a collection of resources that allows ANY professional to take their data analysis skills as far as they need. Including all the way from Excel pivot tables to machine learning. 😁

[@shebapriyanka7617]

Hi David, I like your channel and the way you are explaining clearly from the perspective of advanced analytics. Can you do a video series on SQL for data analytics too?

[@DaveOnData]

Glad you like the content! I already have a tutorial series for SQL on my channel. It is specifically designed for Excel users to learn the most important parts of SQL for data analysis. Here's the playlist: kzbin.info/aero/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w

[@aks1008]

Thanks sir for power query videos

[@DaveOnData]

As I recall, you were one of many requesting this series! 😁

[@aks1008]

@@DaveOnData yes sir

[@abdullah_alhathloul_]

thanks , we miss you

[@DaveOnData]

Thank you. I've been suffering from KZbin burnout as of late due to trolls. I plan to be back soon with more videos.

[@bernatvicens8026]

@@DaveOnData Sorry to hear Dave. The bad part of the internet is that idiots have it easier to spread their poison. If I can give you my 2 cents, is better to concentrate attention in the larger % of those who are neither trolls or idiots. Thanks for your videos.

[@AlterAgs]

U r the best

[@jjtan5408]

Thank you David for the awesome video, I am a Macbook user, is there anyway for me to get access to Excel Power Query?Thank you! Cheers!

[@DaveOnData]

Doesn't appear that Excel for Mac has all the Power Query functionality as of yet. Check out this video for some insights: kzbin.info/www/bejne/hYu0l56sqpyAiZI

[@jjtan5408]

@@DaveOnData Hopefully can get more features soon. Thank you

[@DaveOnData]

Another video was published yesterday and there will be another Thursday morning US time.

[@koulibalynamissasoundiata8845]

Please. Is it Microsoft 360. You are using. ?