Own AI. Own Your Future.
Build real-world AI skills that have business impact.
Learn cluster analysis with Python.
Real-World AI in 2025. Will You Be Ready?
“Python in Excel is intended to empower everyone (and we mean everyone now that we also have Copilot in Excel with Python) to do data analysis in an easy, secure, and compliant way.”
-Keyur Patel, Principal Program Manager at Microsoft
Learn One of the Most Valuable Data Science Skills
Cluster analysis is an OG data science skill that is valuable to ANY professional.
If you are unfamiliar with it, cluster analysis mines your data for hidden groups. You can think of it working like this.
Each row of your dataset is assigned a number (i.e., a cluster assignment).
Rows with the same cluster assignment are more alike than rows of data with different cluster assignments.
Sounds simple, doesn’t it? Maybe it's too simple to be useful?
Nothing could be further from the truth.
Cluster analysis is battle-tested and is used across every business domain to craft new insights:
Marketing professionals use cluster analysis to segment customers, optimize ad creative, and campaign personalization.
Finance professionals use cluster analysis in risk assessment and fraud detection.
Healthcare professionals use cluster analysis to segment patients, analyze disease outbreaks, and optimize resource allocations.
Product management professionals use cluster analysis to prioritize feature enhancements and better understand user segments.
And this list goes on!
My self-paced online course will teach you the cluster analysis skills I’ve successfully used as a hands-on data scientist and analytics consultant for years.
Learn With Help From Your AI Tutor
Let me introduce you to Virtual Dave, your AI tutor. Virtual Dave is a customized and curated AI designed to help you learn cluster analysis fast. More importantly, Virtual Dave is available 24x7 to help you apply what you learn at work to make more impact and stand out from the crowd:
Virtual Dave is an AI service I’m integrating into all my self-paced online courses.
You’ve Got This if You Want It!
I’ve successfully taught 1000s of professionals real-world data science skills. Professionals from all kinds of roles and backgrounds. I can teach you cluster analysis.
But I don’t expect you to believe me. I like to let my content do the talking.
Check out this video and I’ll teach you how k-means clustering works - no math required.
Be an “AI Professional” for Real
Employers will grow to expect that any professional can do data science because of AI.
The future is clear. With AI, most data science won’t be done by Data Analysts and Data Scientists.
My Cluster Analysis with Python online course is the same training I give at national conferences and to my corporate clients.
Check out the job titles of these DIY data scientists and what they have to say about how I can empower you:
IT Manager and DIY data scientist
Business Analyst and DIY data scientist
Andrew and Adam are far from unique. I have successfully trained 1000s of professionals who have built DIY data science skills and are having more impact at work.
If they can do it, why not you?
What’s Inside
I teach only the techniques I use in my real-world work.
I’m going to be honest. I’ve only needed two cluster analysis techniques to get the job done.
The best thing about these techniques is that they are accessible to ANY professional.
No math beyond high school is needed. No calculus and no statistics.
-
Welcome!
Cluster Analysis with Copilot in Excel
Installing Python on Windows
Installing Python on Mac
Introducing Cluster Analysis
Iris Dataset
Hand-Written Digits Dataset
Heart Dataset
-
Clustering Algorithms
Cluster Types
-
The K-Means Algorithm
K-Means by Example
K-Means Math
Dealing with Outliers
K-Means with Python
Visualizing the Clusters
Standardizing the Data
Real-World K-Means
-
-
Evaluating Clusters
Calculating Cohesion
Evaluating Cohesion
The Elbow Method
The Silhouette Coefficient
Copilot in Excel AI Prompts
-
-
The DBSCAN Algorithm
DBSCAN by Example
DBSCAN with Python
DBSCAN Results
Real-World DBSCAN
-
DBSCAN Hyperparameters
Choosing EPS
Finding Nearest Neighbors
eps Elbow Method
Optimized DBSCAN Results
Copilot in Excel AI Prompts
K-Means vs. DBSCAN
-
-
Dimensionality Reduction Intuition
Principal Component Analysis (PCA)
PCA with Python
Copilot in Excel AI Prompts
-
-
The Problem With Categories
One-Hot Encoding
Factor Analysis of Mixed Data (FAMD)
FAMD with Python
Copilot in Excel AI Prompts
-
-
-
Greetings! I’m Your Instructor, Dave Langer.
Author | Microsoft Excel MVP | LinkedIn Top Voice
I’m not your typical data science instructor. I believe ANY professional can (and should) build DIY data science skills. To succeed in this mission, I have to do one thing and do it well.
I have to make learning data science fun.
Yes, you read that correctly.
I won’t lie. Many find the idea of applying cluster analysis intimidating. It shouldn’t be. It’s a skill like any other. You get better with practice.
Making learning data science fun makes getting started less intimidating.
You’ve got this if you want it.
What DIY Data Scientists Have to Say
The same top-rated training I bring to conferences and corporate clients.
“MIND BLOWN…not by the difficulty of the class, but by how EASY Dave makes machine learning within the reach of aspiring Data Scientists.
Easily the highlight of this year’s conference for me. I feel empowered to bring this material back to the job, put it to use, and teach it to others.”
— Chet Phelps, Health Solutions
“Fantastic intro ML course that’s presented in an engaging way. The content was easy to understand and the labs were easy to follow along. I’ve left the course wanting to dive deeper into the topic.”
— Jessica Liu, O-I Glass
“Very good course as an intro to machine learning. I feel that with what I learned today I can put these skills into practice at work.”
— David Green, EMWD
“Best training and instructor I’ve had. Organized, clear, good pace, helpful examples, and an engaging and fun instructor.”
— Alex Kurtz, Sourceability
The Escape Hatch
What if the course isn’t right for you?
My goal is to help you build valuable DIY data science skills for the age of AI. If this online course isn’t right for you, send me an email within 30 days of purchase, and I will issue a refund—no questions asked!
Frequently Asked Questions
-
Yes! All the Python code you learn in this course is 100% compatible with Python in Excel.
-
No! While the math of k-means and DBSCAN is covered for completeness, there are three things you need to know:
The level of math is high school-level and no knowledge of calculus or statistics are required.
If you choose, you can ignore the math sections and still be effective.
You can always watch the recordings later if you would like to brush up on the math.
-
This online course assumes skills with Python and Jupyter Notebooks.
Alternatively, you can use Python in Excel for this course.
My Python in Excel Accelerator online course will teach you what you need.
-
Assuming that you already know enough Python, you can be ready to use cluster analysis in a single weekend.
-
The goal of Virtual Dave is to provide an interactive experience as close to speaking with me in person as possible. Of course, this is not perfect given the current state of AI technology.
So, I continually monitor and curate Virtual Dave conversations to ensure the best possible experience for you.
Virtual Dave is an external AI service that I’ve integrated with this online course. As long as I offer the Virtual Dave service, course students will have access for no additional charge.
-
Send me an email within 30 days of your purchase and I will issue you a refund.
No questions asked.
-
This online course is the same content I deliver to my corporate training clients.
If you need team training, please contact me to discuss your needs.
Be Ready for the AI-Driven Future
Cluster Analysis with Python
5+ hours of video lessons
5 hands-on labs
Clustering case study
Copilot in Excel AI prompts
Access to the Virtual Dave AI Tutor
Refund within 30 days of purchase if you’re not happy
I will teach you how to apply cluster analysis to your data fast.
Payment plans are available