Tap to unmute

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

  Рет қаралды 13,222

David Langer

David Langer

Күн бұрын

Пікірлер: 33
@DaveOnData
@DaveOnData 9 ай бұрын
Stuck waiting for Microsoft to grant you access to Python in Excel? Don't wait! Check out my video on how you can start building skills NOW: kzbin.info/www/bejne/Zpq5ZXmqpbiln7s
@ankursharma6157
@ankursharma6157 9 ай бұрын
Gratitude!
@DaveOnData
@DaveOnData 9 ай бұрын
Thank you! I am so glad you enjoyed the content.
@ninjakaplumbag
@ninjakaplumbag 9 ай бұрын
In my opinion, the problem with M and power query is that if you know python/sql and have access to these tools then power query becomes obsolete. You can do whatever you want to do in sql/python
@DaveOnData
@DaveOnData 9 ай бұрын
This is 100% true for professionals that have the option of accessing databases and/or Python. However, I work with many clients where IT policy precludes this. In these situations, Power Query is what they have to work with.
@WillyKillya
@WillyKillya 5 ай бұрын
So it sounds like the two technologies are appropriate for different audiences. SQL, and python for it IT professionals, and power query for anybody else.
@kevinsotorecabarren5674
@kevinsotorecabarren5674 9 күн бұрын
Great video and explanation! thanks 😁👍🏻
@michaelt312
@michaelt312 9 ай бұрын
It is funny how many people even know about Power Query. Really powerful when they find out about it. Another advantage of Power Query is that it is what PBI uses to clean data. And another great video. So glad I found your channel.
@DaveOnData
@DaveOnData 9 ай бұрын
Agreed! I've always thought it's a crying shame that Microsoft hasn't done a better job marketing Power Query to Excel users. Glad to hear that you are still enjoying my content.
@mannylabrinos1963
@mannylabrinos1963 9 ай бұрын
Excellent Explanation!
@DaveOnData
@DaveOnData 9 ай бұрын
Thank you! Glad you enjoyed the video.
@shout-style
@shout-style 6 ай бұрын
Amazingly well explained. love your videos. You should have a lot more views!!!
@DaveOnData
@DaveOnData 6 ай бұрын
Thank you! Oddly enough, I think this about my videos as well. 🤣
@crispindeleon1930
@crispindeleon1930 4 ай бұрын
I subbed. But for now and will be chasing after anything sql related. Thanks a bunch bro!
@DaveOnData
@DaveOnData 4 ай бұрын
You are welcome! I hope you find my content useful.
@crispindeleon1930
@crispindeleon1930 3 ай бұрын
​@@DaveOnData of course man! Every single one of them. Ty very much!
@aleksandrm.4922
@aleksandrm.4922 9 ай бұрын
David, thanks! Great comparison of the tools, but IMHO the topic wouldn't be fully covered without mentioning about Query folding - a mechanism of translating M code into SQL. It passes data processing from a client machine to a server side
@DaveOnData
@DaveOnData 9 ай бұрын
Thanks for adding this to the conversation! I will admit, unfortunately, what I see is that Power Query is very rarely used. In those rare instances where it is used, it is mostly used for cleaning up vagaries in Excel data formatting. It's too bad, really. Power Query is so powerful.
@Ugk871
@Ugk871 9 ай бұрын
I tried to explain the difference of SQL and Excel (Power Query) to my boss today. He can’t understand that why the two technologies have different methods of extracting data. He has good motivation but He wants SQL to behave like Excel. 😂
@DaveOnData
@DaveOnData 9 ай бұрын
It's actually a great question, IMHO! For example, why couldn't the Power Query GUI just as easily generate SQL? For whatever reason, M was Microsoft's choice and it is here to stay. 🤣
@Ugk871
@Ugk871 9 ай бұрын
@@DaveOnData true. But, I’m not Microsoft owner 😅 so there are certain things I cant change even if I want to. 😆
@jasongins
@jasongins 9 ай бұрын
I have access to the ERP database, but it is not an SQL database. Rather, it is a ProvideX database (Sage 100). Thus far, I've gotten by with exporting tables via ODBC connection to power query or MS Access. I am interested in learning SQL, is it possible to use MySQL or similar with a setup like this? I have been learning some Python as well ( with your series if course,).
@DaveOnData
@DaveOnData 9 ай бұрын
If you're interested in learning SQL, can I suggest my tutorial series? It uses Microsoft SQL Server which has a free Developer Edition. Here's my SQL series playlist: kzbin.info/aero/PLTJTBoU5HOCSrExoOVTjDG33lFpDvmz2w
@jimmychangtiunnkunui7877
@jimmychangtiunnkunui7877 3 ай бұрын
Pure SQL skill might be limited to the various data sources. However, mostly SQL users also know how to do ETL.
@christophernazareno9114
@christophernazareno9114 6 ай бұрын
If I may ask, is SQL faster in refresh rate than PowerQuery?
@DaveOnData
@DaveOnData 6 ай бұрын
Can you elaborate on what you mean by "refresh rate?"
@goodyearspokane
@goodyearspokane 9 ай бұрын
In Power Query I really miss the SQL CASE statement but Power Query is so much better than SQL if you have to pivot the data especially dynamic pivot
@DaveOnData
@DaveOnData 9 ай бұрын
I hear you! In my work building features for advanced analytics, the combination of GROUP BY and CASE WHEN in SQL are my bread and butter!
@JoseCastillo-yp1fn
@JoseCastillo-yp1fn 9 ай бұрын
Do you thing Python will be available inside Power Query for Excel anytime soon as seen in Power BI.
@DaveOnData
@DaveOnData 9 ай бұрын
I'm not sure, but my Spidey Sense tell me not likely. Power BI had access to Python and R relatively early on. Based on my experience, and client discussions, I think this is how the Excel stack is going to look for advanced analytics: 1 - Data acquisition and wrangling is going to be SQL and/or Power Query. While data wrangling can certainly be done using Python (e.g., pandas), given the current architecture, it's best to send cleaned/wrangled/filtered data up to Azure for Python to process. 2 - Excel will be used to the max (e.g., PivotCharts) for exploratory data analysis (EDA). While EDA can certainly be done in Python, there are advantages for using out-of-the-box Excel functionality when you can. The exception will be things like data visualizations that are difficult, or not possible, to do with Excel features. 3 - Python in Excel will be used for modeling and complex processing (e.g., text analytics).
@markk364
@markk364 9 ай бұрын
I dont understand the title: SQL works with databases, PowerQuery is unique to MS's attempt to corner the market on data flow.
@DaveOnData
@DaveOnData 9 ай бұрын
And both can be used with Python in Excel. I have been asked by Excel users unfamiliar with these technologies which one should they use with Python in Excel.
Python in Excel Makes Machine Learning a MUST-HAVE in 2024!
16:17
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 94 М.
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
Next.js 15 Tutorial - 11 - File Colocation
2:53
Codevolution
Рет қаралды 1,3 М.
Python in Excel vs. VBA - What You Should Learn in 2024!
10:05
David Langer
Рет қаралды 74 М.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]
23:52
10 awesome Power Query tricks you NEED to know! | Excel Off The Grid
15:44
Excel Off The Grid
Рет қаралды 55 М.
Python in Excel. This changes EVERYTHING!
9:47
Excel Dictionary
Рет қаралды 24 М.
Python in Excel Makes Power Query a MUST-HAVE in 2024!
13:19
David Langer
Рет қаралды 47 М.
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41