Discussion


Note: Images may be inserted into your messages by uploading a file attachment (see "Manage Attachments"). Even though it doesn't appear when previewed, the image will appear at the end of your message once it is posted.
Register Latest Topics
 
 
 


Reply
  Author   Comment  
peter_mikael

Registered:
Posts: 23
Reply with quote  #1 
Hi

I would like to visualize the roles different distribution channels (e.g. store, online) play for a number of different products. I have defined a number of different roles and I have assigned an arbitrary scale 0-5 to describe to which extent the channel should fulfil this role for the products, see the below table.

  sfew.PNG 
The channel should for instance not focus on recruiting new customers for product 1 but instead activate inactive customers for product 1.

Any ideas on how to visualize this?

Thanks

Peter

sfew

Moderator
Registered:
Posts: 827
Reply with quote  #2 
Peter,

For what purpose do you need to display this information in a more visual way? The values can be displayed visually rather than as numbers, but that isn't necessarily an advantage. Let's begin by determining if the table is lacking in some way and a visual expression of the values would improve its use. What is the table lacking?

__________________
Stephen Few
peter_mikael

Registered:
Posts: 23
Reply with quote  #3 
I think that it is hard to see which are the focus areas (i.e. Value = 4 or 5) and which areas are unimportant (value 0 or 1).
sfew

Moderator
Registered:
Posts: 827
Reply with quote  #4 
Peter,

Will you only be displaying information for eight products and four roles, as you've illustrated?

__________________
Stephen Few
peter_mikael

Registered:
Posts: 23
Reply with quote  #5 
Eight products but 12 roles.
sfew

Moderator
Registered:
Posts: 827
Reply with quote  #6 
Peter,

If there is a good reason to reduce the time that's required to identify the products that need the most attention, a simple heatmap would work well and would be easy to create. In other words, rather than displaying numbers in the cells of the table, display colors that range in intensity from lightest for a value of 0 to darkest for a value of 5. Use a single color (e.g., shades of gray). Almost any product that's capable of displaying values in tables, as you've illustrated, can represent the values as colors. For example, this is easy to do in Excel using conditional formatting. If you do this and post the result here, I and others can give you additional suggestions regarding its design.

__________________
Stephen Few
peter_mikael

Registered:
Posts: 23
Reply with quote  #7 
Hi

This is my suggestion. Any ideas on how to improve it?

Thanks

Peter
heatmap.PNG 



sfew

Moderator
Registered:
Posts: 827
Reply with quote  #8 
Based on your description and what I can tell from your example with fake data, this works well. It is a simple heatmap matrix (a.k.a., tabular heatmap). The only potentially useful change that comes to mind is to remove the orange color behind the column headings because it causes the headings to pop visually to an excessive degree.
__________________
Stephen Few
peter_mikael

Registered:
Posts: 23
Reply with quote  #9 
Thanks for your advice.
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.