SQL vs. Power Query – The Ultimate Comparison 15x5g

On the left side, we have a veteran warrior with...

On the left side, we have a veteran warrior with 37 years of data battle scars and  redundant six pack.  They call him SQL.
On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query.
Who is going to win this battle?!?

I have been using SQL for 25 years and Power Query since it came out in early 2012. And in this article, let me share my views on how SQL compares with Power Query. If you prefer to listen, check out the podcast episode – SQL vs. Power Query. 
Listen: SQL vs. Power Query Podcast Episode SQL vs. Power Query - The Comparison SQL Power Query What can you do? 
All CRUD operations (Create, Read, Update, Delete)
Only Read the data
What kind of data?
Usually single source from a database or warehouse
(ex: SQL Server)
Can access data from anywhere and combine data from multiple sources too.
How do you use it?
You need to “WRITE” queries to use SQL. 
You “BUILD” Power Queries using the UI buttons and menu options.
Where can you use it?
Works almost universally. You can use SQL with most database systems and programming languages. 
Only with Microsoft stack of products, primarily with Power BI, Excel and Fabric.
Who can use it?
By default, you need permissions / special software to use SQL.
Almost anyone can use Power Query as it comes packaged with Excel and Power BI.
How fast is it?
Built for performance and scalability. You can use SQL to access data quite efficiently.
Can become slow and tedious as your data grows. 
Resources for Learning SQL SQL Basics
50 SQL examples for Excel folks
Resources for Learning Power Query What is Power Query and how to use it?
Learn Power Query in 15 minutes
My Power Query Essentials Course
What do you think? Have you used both or either of these technologies? What do you think? Leave a comment with your thoughts.
The post SQL vs. Power Query – The Ultimate Comparison appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

05: Interview with MrExcel – Bill Jelen (on his incredible work ethic) 1 año 38:19 Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast) 1 año 26:33 02: Six Tips to get a Six Figure ($100,000+) Data Job 1 año 30:17 03: The Ugly Truth About Power BI (actually, 4 of them) 1 año 21:47 056: So which formulas you should care to learn? +1 año 35:26 Ver más en APP Comentarios del episodio u722y