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