In this video I will teach you how to perform a K-means cluster analysis with Excel. Cluster analysis is a wildly useful skill for ANY professional and K-means 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 K-means clustering in Excel using simple tools like VLOOKUPs and a tiny bit of Power Query.
This video is a fairly in-depth tutorial on K-means 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/DataAnalysisWithExcel
💥 Learning R programming is easy! 💥
Conduct powerful cluster analyses with R:
📺 https://youtu.be/MNpsyjSuR20
💻 Example of a scree plot for choosing the number of clusters:
https://rstudio-pubs-static.s3.amazonaws.com/476207_937ae346a91442fdb6b84c840092f441.html#selecting-number-of-clusters
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 https://youtu.be/xIXymabyFIM
Stay healthy and happy data sleuthing!
#KMeansClusterAnalysisWithExcel #KMeansClusterAnalysis #ClusterAnalysis #KMeans