Is there a stored procedure in SQL server that allows you do perform clustering/kmeans clustering?

Tianqi Luo 1 Reputation point
2020-08-24T18:22:42.983+00:00

My boss is giving me a bunch of data to analyze by using clustering/kmeans methods. Is there a stored procedure in SQL server that allows me to do that??

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,481 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2020-08-25T06:34:04.683+00:00

    Hi TianqiLuo-5398,

    You can use data mining or machine learning services (Phython and R) to create K-Means Clustering model.
    Please refer to the following articles which might help:
    Microsoft Clustering Algorithm Technical Reference(data mining)
    Microsoft Clustering in SQL Server(data mining)
    Tutorial: Develop a clustering model in R with SQL machine learning(machine learning service)
    Perform customer clustering using R and SQL Server ML Services(machine learning service)

    Best Regards,
    Amelia