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-Combine-Transform-Business-Skills/dp/1509307958/ -------------------------------------------------------------------------------------------- MY SQL FOR EXCEL USERS TUTORIAL SERIES -------------------------------------------------------------------------------------------- Part 1 - Overview: https://youtu.be/g1h-9VSjawY Part 2 - Basic Tables: https://youtu.be/otzlxjKCJ38 Part 3 - Basic Filters: https://youtu.be/CLAESLlHjgk #pythoninexcel #pythonexcel #pythonforexcel