All IT Courses 50% Off
Tableau Tutorials

Clustering in Tableau

Cluster analysis or clustering in Tableau divides a data set into segments or clusters with relevant data values. Clustering helps us to conduct a comparative analysis of data. A cluster comprises of similar data values of a dimension, i.e., the cluster values are related to each other more than the data in other clusters. Therefore, clustering is done using specific clustering algorithms where similar values are kept together as a part of the group. We can also have a cluster of up to seven color shades or codes at a time.

For example, if we have sales data for a product for different types of consumers/buyers and we want to analyze the purchasing capacity/trends of consumers. We can create clusters for this where we can segregate consumers based on their purchasing capacities. Now that we can unveil and analyze consumers’ purchasing or spending capacities, we can develop strategies to maximize sales.

In Tableau, the clustering algorithm is used to create clusters on a Tableau worksheet and is known as the K-means clustering algorithm. The reason behind it being called K-means is that this algorithm divides a data set into K clusters or segments based on the similarity metrics. Then it calculates the mean for each cluster that gives the Centroid of a cluster.

After it calculates the centroid value for each cluster present, it arranges them in such a way that the total sum of the distance between the centroid and concerning members in a cluster is minimum or as small as possible. In this way, the K-means algorithm also gives us closely packed clusters, each made of closely related/similar values.

How to Create Clusters in Tableau?

As a prerequisite to make a cluster in Tableau, we have first created a scatter plot for sales.

Clustering in Tableau

Step 1: For creating a cluster, go to the Analytics tab and then select Cluster from the Model section.

Clustering in Tableau

Step 2: Hold the option Cluster and then drag and drop it on the data visualization area, as shown below.

Clustering in Tableau

Step 3: A dialog box Clusters will open containing two columns: Variables and Number of Clusters. In the Variables column, you can add dimensions or measure fields to be included in the cluster. Moreover, from the Number of Clusters section, you can enter the numeric value of the clusters you want.

Clustering in Tableau

Once you are done setting up all the cluster settings, you will have a cluster of data values formed in the visualization area. On the extreme right, you can see each cluster name with their corresponding colors. Here, it shows four clusters named as (Cluster 1, Cluster 2, Cluster 3, and Cluster 4) as we have set the Number of Clusters value as 4 in the previous step.

Clustering in Tableau

Step 4: On the left panel, we have the Cluster (1) showing where we can explore and manage a cluster’s properties further. For accessing the drop-down menu, click on the arrow given right next to Cluster (1). To see the description of the selected cluster, click on Describe clusters… option.]

Clustering in Tableau

It will open a detailed description window for the active cluster containing two tabs: Summary and Models. The summary tab gives a detailed summary of the cluster made, giving information about the variables, level of detail, number of clusters, scaling, number of points, and the total sum of squares along with information on each cluster. The Models tab describes the cluster model type.

Clustering in Tableau

Step 5: You can also change the shape of each cluster point from the Shape card present on the Marks section, as shown below. This option will give you a range of different shapes to select.

Clustering in Tableau

Step 6: You can also change the color scheme of the cluster by clicking on the Color option present in the Marks section. From the window that opens, you can see the current color scheme, select a new color palette, and assign it to the cluster.

Clustering in Tableau

The color scheme of the cluster has now changed.

Clustering in Tableau

Clustering Conditions in Tableau:

There are certain conditions where you cannot use the clustering option in Tableau.

  • Clustering is not available for authors on the web such as on Tableau Online, Tableau Server, etc. Instead, it is available on the Tableau Desktop.
  • Clustering is not available while using a cube data source.
  • Clustering is not available when a blended dimension is available in the view.
  • When you do not have fields that you can use as variables or inputs for clustering in the view.
  • Clustering is not available when no dimensions are present in an aggregated view.
  • When the data have field types such as table calculations, Blended calculations, Ad-hoc calculations, Generated latitude/longitude values, Groups, Sets, Dates, Bins, Parameters, Measure Names, and Measure Values, these cannot be used as variables or inputs for clustering.
Facebook Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Articles

Check Also
Back to top button

Get Python Course
worth 499$ for FREE!

Offer valid for 1st 20 seats only, Hurry up!!

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

H2kinfosys Blog will use the information you provide on this form to be in touch with you and to provide updates and marketing.