What is Excel Power Query AND Why it Matters to You!
Vložit
- čas přidán 5. 09. 2024
- 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.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
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
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 czcams.com/video/xIXymabyFIM/video.html
Why have you stopped posting?
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!
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.
It's like you read my mind. I was just thinking of how to use PQ for the cluster analysis video you had made
Awesome! Glad you liked the video.
Oh, I believe you! Changed my life forever!
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! 😊👍
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. 😁
What a great idea for a video. K means vie power query. Excellent content, well done and thanks.
Awesome setup for the series David.
Thank you! I was wondering how folks might react to my thoughts on Power Query. 😁
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?
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: czcams.com/play/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w.html
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?
Thanks sir for power query videos
As I recall, you were one of many requesting this series! 😁
@@DaveOnData yes sir
thanks , we miss you
Thank you. I've been suffering from CZcams burnout as of late due to trolls. I plan to be back soon with more videos.
@@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.
U r the best
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!
Doesn't appear that Excel for Mac has all the Power Query functionality as of yet.
Check out this video for some insights: czcams.com/video/OZQfkvu7MS0/video.html
@@DaveOnData Hopefully can get more features soon. Thank you
Another video was published yesterday and there will be another Thursday morning US time.
Please. Is it Microsoft 360. You are using. ?