K-means Cluster Analysis With Excel - A Tutorial

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/DataAna... 💥 Learning R programming is easy! 💥 Conduct powerful cluster analyses with R: 📺    • Learning R Programming Is Easy! (Full Webi...   💻 Example of a scree plot for choosing the number of clusters: https://rstudio-pubs-static.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 with Exc...   Stay healthy and happy data sleuthing! #KMeansClusterAnalysisWithExcel #KMeansClusterAnalysis #ClusterAnalysis #KMeans