Data Mining Clustering Example in SQL Server Analysis Services SSAS

Problem

Where can one find a simple example utilizing the data mining clustering capabilities in SQL Server Analysis Services?

Solution

The solution presented here creates a two dimensional data table with clearly observable clusters. Next, this data is read into the clustering algorithm in SSAS where the clusters can be determined and then displayed.

The first step is to create a table and load it with data using the T-SQL sample below.