Registered: 1418378430 Posts: 18
Reply with quote #1
I am creating a few scenarios on what our revenue will be based on four variables with three different outcomes. For each combination I will calculate expected sales e.g. High product quality / Mid Sales Commission / Low marketing budget / Slow time to market = 10 MUSD sales. How would you visualize this? There are 3 x 3 x 3 x 3 = 297 combinations. (I use other variables in my calculation which are very sector specific but I think these are easier to understand) I want to highlight 3-4 scenarios to draw attention to the scenarios which are of most interest.
High Product quality Mid Low High Sales Commission Mid Low High Marketing budget Mid Low Fast Time to market Mid Slow Thanks Peter
Registered: 1138030229 Posts: 167
Reply with quote #2
Peter, not sure that I understand what you are doing ...
It looks like you're measuring net revenue where each Quality * Commission * Budget * Time combination produces a certain USD amount. If I have that correct, then I would calculate all combinations and plot the USD results in a descending order horizontal bar chart. To reduce the chart size, combinations that fall below required revenue could be plotted on one chart and those that meet or exceed on another.
Whatever it is that you come up with, please share your results. __________________ Bill Droogendyk
Registered: 1348995178 Posts: 181
Reply with quote #3
I think you are trying to display a simplified version of a multivariate analysis.
It was not clear for me that you have one or several revenue results for the same combination, my comment is based on the assumption that you have no more than one for each combination.
The fact you have only one variable as result and discrete values for a small amount of input variables you might consider Bill suggestion, a sorted horizontal bar chart. However I would enrich each bar (in label information area) with a parallel plot like single sparkline connecting the values for each variables of the current combination, where values can be conventionally considered 0=low, 1=mid, 2=high.
If you want to focus only on first few combinations, I would also try to design a parallel plot connecting variables conventional values (0=low, 1=mid, 2=high) with revenue value. I would also use a sequential color palette, with the most intense color connected to the highest revenue.