Skip to main content Skip to complementary content

Clustering (k-means) analysis

Show clusters of measures associated with a dimension using a statistical algorithm.

Clustering (k-means) clusters data points aggregated by similarities from two measures over a dimension using a machine learning k-means algorithm.

Clustering (k-means) analysis

Clustering (Kmeans) analysis showing City clustered by the average cost of sale and average gross profit.

Creating clustering (k-means) analysis

  1. In Assets, click Analysis.

  2. Drag and drop Clustering (k-means) into the sheet.

  3. Click Add dimension and select a dimension.

  4. Click Add measure and select a measure.

  5. Click Add measure and select a second measure.

  6. Optimally, to customize the clusters, do the following:

    1. In the properties panel, in Analysis properties, change Clusters from Auto to Custom.

    2. After Number of clusters, adjust the slider to set the clusters.

    3. After Normalization algorithm, select the algorithm to use. The following are available:

      • zscore: Z-score normalization normalizes data based on feature mean and standard deviation. Z-score does not ensure each feature has the same scale but it is a better approach than min-max when dealing with outliers.

      • minmax: Min-max normalization ensures that the features have the same scale by taking the minimum and maximum values of each and recalculating each datapoint.

      • none: No normalization.

  7. Optionally, to add an analysis period, do the following:

    1. In the properties panel, under Analysis properties, turn on Analysis period.

    2. Under Calendar period, select the calendar period to use.

    3. Under Period, select a specific period to use.

    Information noteAnalysis periods requires calendar periods in the logical model. For more information, see Defining analysis periods with calendar periods.
  8. Optionally, in the properties panel, under Appearance, adjust the appearance of the analysis.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!