Python in Excel Makes Power Query a MUST-HAVE in 2024!

Power Query and Python in Excel are like chocolate and peanut butter - better together! Skills with Power Query are a must in 2024 if you want to supercharge your analytics.

The combination of Power Query and Python makes Excel a complete technology stack for doing data science.

For example, sourcing 300,000 rows from a database so that you can craft new and powerful insights using Python in Excel.

--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:22 Sizing the Data
05:59 Loading All the Data
08:54 Visualize the Data with a Count Plot
10:20 Visualize the Data with Histograms

--------------------------------------------------------------------------------------------
FREE MACHINE LEARNING CRASH COURSES
--------------------------------------------------------------------------------------------
If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses!

Here's what you get with any of these courses:
1️⃣ On-Demand: Watch the course when it fits your schedule
2️⃣ PDF of all slides
3️⃣ All Python code as a Jupyter Notebook
4️⃣ All data so you can experiment
5️⃣ Resources to continue your learning.

Machine learning with Python in Excel. You've got this if you want it:
💻 Decision Trees with Python:

💻 Tuning Decision Trees with Python:

💻 Logistic Regression with Python:

💻 Cluster Analysis with Python:

#pythoninexcel #pythonexcel #pythonforexcel

[pkrempf]

Thank you for the demo : really cool !

[oscarpeters]

Hey David, love the step-by-step explanation, definitely something I will be investigating more.
One tip: I see you growing and shrinking the formula area in the formula bar. Therre is a shortcut for that: Ctrl+Shift+U.
Once you have set the height you need using the mouse, using the shortcut will shrink it to the original single line size; using it again will re-grow it to what you set it previously.

[peteolesen]

Dave, Excellent video and very helpful. I am using Powerquery quite a bit now and find it to be a useful tool, along with PowerBi. Python does some things that Powerbi or Excel can't do or can't do well. Keep em' coming.

[engineeringinspectionsirel]

Hi David. You've got a new subscriber and fan. Cheers .

[michaelt]

I absolutely LOVE Power Query and that is 95%+ of my income.

[jayraldtajale]

Thanks for sharing this. But I think I might stick with Power BI for now. But it’s nice to finally have an idea how to use python in excel.

[hamidsajjadi]

Thanks for your video. But you know, i am really wondering what is the advantage of creating charts using phyton over creating using pivot chart. I think using pivot chart along side with many slicers and defining measures is by far more flexible.

[RedCloudServices]

PRIEST!! 🤟🏻 I wish the opposite was possible, to transform with Power Query then load to PostgreSQL via excel.

[spilledgraphics]

Hi David, have you hit the limits on Python in Excel when it comes to loading data to the cloud? If so, how big the dataset was? Amazing video mate!

[rpopecpa]

David, thanks for this video! I was waiting to see the connection between SQL and Python. Next, I am waiting to see the benefits of using Python. So far, I don't see the advantage.

[perrinms]

Very helpful video! Can you say if the 100MB data limit is per python query or is that the total for the whole workbook's python code?

[abdullahtammour]

Does power query have the same limitations of 1 million row of data? In case i want only a connection and don’t want to load the data into an excel sheet

[victor_wang_]

How does the connection only query refresh? Doesn't a query need to be loaded somewhere to be refreshed if the data is updated?

[rwno]

Would Python in Excel be useful for trading the furures market (Dow Nasdaq ect.)?

[richardbryanesq]

This topic isn't even remotely related to my profession. But I love it anyway!

[memolingvo]

How to install the Python libraries which are missing in the Python for Excel?

[DIGITAL_COOKING]

question: do we need to study power query m code or pandas or both of them ?
because I mean if we can use pandas in power query why do we just study pandas

[MarcelLindner]

does python in excel only run with the windows insider program?

[abdo]

The problem is EXEL and acsses are limited .

[TomaszBI]

I don't know. PQ is so slow, that even in dataflows and PowerBi it kinda suck. In at time that I have to spend waiting for query to spit out results, I can learn python.😆