Grouping or Clustering by Employee Count

Hello,

I need assistance with grouping and statistics.

End State (what good looks like): 3 or 4 groupings by employee segments based on a statisitcal methodology that is based on vertical (SIC), potential, and propensity to buy (higher value customers are more likely to purchase). For example, grouping employees from 1-15, etc.

I have sample data attached. I am stuck on best way forward. I have tried Tile and K-means Clustering with Alteryx, but still need assistance. Any methodology or process to help me progress is greatly appreciated. I am a new user with Alteryx.

Data&colon;

Company Sales, Sales revenue, Total employees, Employees_Here, Number_of_Family_Members, Industry Code, Potential, Propensity to Buy

Many thanks

Test Data.xlsx

Predictive Analysis

Accepted answers

JohnJPS

I'm not sure I completely understand the question, but could you do multiple Tile tools? For instance, send data input into both a tlile on Potential, and a tile on PropensityToBuy; then join these back together by record position; then add the "TileNum" outputs together and sort descending on the sum? Just a thought - see attached workflow for detail.

DoubleTile.yxmd

RodL

As @JohnJPS said, I'm not sure I understand your question.

Typically with clustering/segmentation, you are segmenting on the observations (e.g., stores, customers, or in the case of your data, companies).

The way your data is set up, you have individual companies with attributes for each one. For this data it would normallly be used to segment out companies into like groups.

I have attached how you would do this in Alteryx with the clustering tools. The Cluster Diagnostics workflow tests the data to determine the optimum number of clusters based on the K-Means cluster method. A PDF of the results is attached. Based on those results, it looks like the "best" cluster solution would be 6 clusters. (BTW, it takes about 25 minutes to run with the settings in the workflow.) Then the Cluster Analysis workflow shows how you would use those settings to run a model and assign the appropriate cluster to each company. Another PDF shows the results of that.

Of course, looking at the results, I might filter out the 'zero employee' companies as "exceptions", but it really depends on what the purpose of your segmentation is.

Cluster Analysis.pdf

Cluster Analysis.yxmd

Cluster Diagnostics.pdf

Cluster Diagnostics.yxmd

All comments

JohnJPS

DoubleTile.yxmd

RodL

As @JohnJPS said, I'm not sure I understand your question.

Typically with clustering/segmentation, you are segmenting on the observations (e.g., stores, customers, or in the case of your data, companies).

The way your data is set up, you have individual companies with attributes for each one. For this data it would normallly be used to segment out companies into like groups.

Of course, looking at the results, I might filter out the 'zero employee' companies as "exceptions", but it really depends on what the purpose of your segmentation is.

Cluster Analysis.pdf

Cluster Analysis.yxmd

Cluster Diagnostics.pdf

Cluster Diagnostics.yxmd

Smcleod2

Thanks John, this is great. Thank you for the reply and help.

Smcleod2

Thank you Rod for the help. I did not know about the Render output. The one concern is the time is takes for clustering. This was just a very small data sample as I tried a large sample and after an hour I stopped it. Thank you for the reply

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703