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

Подписаться 75 тыс.

Просмотров 13 тыс.

50% 1

Excel Power Query is a must-have skill for ANY professional wanting to have more impact with Excel-based analytics. In this video I cover what is Excel Power Query and why it matters to you.
This will be the first video in my tutorial series on using Excel Power Query for advanced analytics.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📺 My tutorial on K-means cluster analysis with Excel:
• K-means Cluster Analys...
-----------------------------------------------------------------------------------------------------------------------
Additional Power Query Tutorial Videos
-----------------------------------------------------------------------------------------------------------------------
Excel Power Query - Add Column From Examples (Part 2):
📺 • Excel Power Query Tuto...
Excel Power Query Tutorial - Add Custom Column 1 (Part 3):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Conditional Column (Part 4):
📺 • Excel Power Query Tuto...
Excel Power Query - Grouping Tables of Data (Part 5):
📺 • Excel Power Query Tuto...
Excel Power Query - Transforming Nested Tables (Part 6):
📺 • Excel Power Query Tuto...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video: • Learning R Programming...
Stay healthy and happy data sleuthing!
#ExcelPowerQuery #PowerQueryTutorial #WhatIsPowerQuery

Наука

Опубликовано:

28 июл 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 27

@DaveOnData 3 года назад

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html

@minecraftmike5193 2 года назад

Why have you stopped posting?

@UlyssesHaq 3 года назад

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 3 года назад

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 3 года назад

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 3 года назад

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 3 года назад

Awesome setup for the series David.

@DaveOnData 3 года назад

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

@vijayarjunwadkar 3 года назад

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 3 года назад

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. 😁

@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?

@AlterAgs 2 года назад

U r the best

@shebapriyanka7617 3 года назад

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 3 года назад

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: ru-vid.com/group/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w

@aks1008 3 года назад

Thanks sir for power query videos

@DaveOnData 3 года назад

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

@aks1008 3 года назад

@@DaveOnData yes sir

@abdullah_alhathloul_ 2 года назад

thanks , we miss you

@DaveOnData 2 года назад

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

@bernatvicens8026 2 года назад

@@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.

@koulibalynamissasoundiata8845 Год назад

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

@jjtan5408 3 года назад

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 3 года назад

Doesn't appear that Excel for Mac has all the Power Query functionality as of yet. Check out this video for some insights: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OZQfkvu7MS0.html

@jjtan5408 3 года назад

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

@DaveOnData 3 года назад

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