Suggestions for Demographic Analysis

Question

Hi All,

I'm a fairly basic Alteryx user so apologies for the simple question.

My company has access to the Experian Mosaic Demographic data.

In my sample data I have linked the total local demographics by group to each store with the total Revenue. (I do have other variables linked to each store but this data is sensitive)

I'm now struggling with which tools I can use to start a deeper analysis. My main outcome is to find the best Demographic group mix to determine the best revenue.

Which predictive / prescriptive tools would you suggest would help me reach my end goal / gain a more in-depth insight.

All suggestions are welcome.

Many Thanks,

Kyra

Sample Demographic Data.xlsx

AngelosPachis · Accepted Answer

Hi @Kyra88 ,

I think the first think you would like to look for is creating groups (or clusters) of stores with similar demographics. That you can do using the predictive grouping tool palette with the K-Centroids Diagnostics, Cluster Analysis tools.

You can watch the following videos that will act as a good intro to the topic.

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Predictive%20Grouping

There is also the Demographic Analysis tool palette that might be useful, but I have no experience of working with those tools.

Regards,

Angelos