Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Where is the hierarchical clustering?

Is there a reason why Alteryx does not include hierarchical clustering?

 

Well it's sort of slow especially with huge data sets, computation effort increases cubic, but then when you need to do two step clustering,

"creating more than enough k-means clusters and joining cluster centers with hierarchical clustering" it seems to be a must...

 

P.s. Knime, SPSS modeler, SAS, Rapidminer has it already...

9 Comments
SeanAdams
17 - Castor
17 - Castor

Just bumped into this now, while doing the second-last assignment on the Udacity Nano-degree.    Not sure if anyone responded to you on this @Atabarezz or if this is a genuine gap in the product?

Atabarezz
13 - Pulsar

No response at all... Thanks for paying attention Sean.

 

This method is available as an R package but not as a tool in Alteryx...

https://www.r-bloggers.com/hierarchical-clustering-in-r-2/

 

When this method is used in conjunction with K-means clustering tool

Alteryx will become an even more powerful tool providing more accurate segmentation

Atabarezz
13 - Pulsar

Here is a nice blog post from analytics vidhya explaining k-means (available in Alteryx)

vs. hierarchical clustering (not available in Alteryx);

 

https://www.analyticsvidhya.com/blog/2016/11/an-introduction-to-clustering-and-different-methods-of-...

clustering-6

 

 

 

Atabarezz
13 - Pulsar

By the way if you combine two methods;

 

  • a very detailed (high number of K's) K-means or medoids model (which is always a fast algorithm)
  • with a hierarchical model (normally it's slow with big data but for a managable number of K-means clusters it's fast as well)

you basically get a two-step clustering algorithm that already exists in SPSS Modeller...

 

here is a link to the relevant IBM SPSS modeler algorithm guide: https://www.ibm.com/support/knowledgecenter/en/SS3RA7_15.0.0/com.ibm.spss.modeler.help/clusternode_g...

Community_Admin
Alteryx
Alteryx
Status changed to: Inactive
 
Community_Admin
Alteryx
Alteryx

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

Balders
11 - Bolide
I would love to see a tool for this
iyoob
7 - Meteor

It will good to have hierarchical clustering in Alteryx with the standard clustering methods including Ward's.  

SaiKrishna2589
8 - Asteroid

11 likes now :)