In this video I will teach you how to perform a Kmeans cluster analysis with Excel. Cluster analysis is a wildly useful skill for ANY professional and Kmeans a great first clustering algorithm no VBA code required!

Cluster analysis is used in all areas of business:

In HR analytics for understanding similar employees
In marketing analytics for customer segmentation
In supply chain management to optimize logistics

The list goes on.

The great news is that you can perform Kmeans clustering in Excel using simple tools like VLOOKUPs and a tiny bit of Power Query.

This video is a fairly indepth tutorial on Kmeans clustering, so feel free to jump around if a full tutorial experience is not what you need.


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


★★★ My online data analysis courses ▶ https://school.daveondata.com



Video Resources

Get the Excel workbook & Notepad file for this video:
https://github.com/DaveOnData/DataAna...


Learning R programming is easy!
Conduct powerful cluster analyses with R:
   • Learning R Programming Is Easy! (Full...  


Example of a scree plot for choosing the number of clusters:
https://rstudiopubsstatic.s3.amazon...



Excel Analytics Training

‍‍ Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
   • Introduction to Business Analysis wit...  



Stay healthy and happy data sleuthing!

#KMeansClusterAnalysisWithExcel #KMeansClusterAnalysis #ClusterAnalysis #KMeans