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.
☕ 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: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:
https://bit.ly/DecisionTreesWithPython
💻 Tuning Decision Trees with Python:
https://bit.ly/TuningDecisionTreesWithPython
💻 Logistic Regression with Python:
https://bit.ly/LogisticRegressionWithPython
💻 Cluster Analysis with Python:
https://bit.ly/ClusterAnalysisWithPython
#pythoninexcel #pythonexcel #pythonforexcel