SQL vs. Power Query – What You Should Use for Python in Excel in 2024!

Using SQL or Power Query is the best way to get high-quality data for your Python in Excel analyses. However, choosing which is best isn't straightforward. In this video, I discuss choosing between SQL or Power Query based on your situation.


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:03 Power Query Introduction
06:09 SQL Introduction
11:00 Power Query Pros & Cons
14:22 SQL Pros & Cons
18:15 Which You Should Use


--------------------------------------------------------------------------------------------
MY FAVORITE POWER QUERY BOOK
--------------------------------------------------------------------------------------------
https://www.amazon.com/Collect-Combin...


--------------------------------------------------------------------------------------------
MY SQL FOR EXCEL USERS TUTORIAL SERIES
--------------------------------------------------------------------------------------------
Part 1 - Overview:    • Introduction to SQL Programming for E...  
Part 2 - Basic Tables:    • Introduction to SQL Programming for E...  
Part 3 - Basic Filters:    • Introduction to SQL Programming for E...  


#pythoninexcel #pythonexcel #pythonforexcel