For this fictional Superstore, I wanted to know what products returned lower than average profit margin. My goal was to discontinue products that returned less than average profit (4.7%) and see how this might impact our popularity.
Dynamic, interactive chart:
Action: Based on a quick visual look, you can see that Machines, Tables, and Binders are the smallest (less popular) of the less profitable items. These should immediately be considered for discontinuation.
Other Notes:
I only showed contrasting colors between a profit rate of 1.7% and 7.7%. However, the true range is between about -24% and 19%. Contrasting the middle gives us a good idea of where the cut off should be for some products. Mustard yellow: the left side of the legend, the strongest hue is down to 1.7% and even lower in this bucket. Gray: around 4.7% profit. Purple: the right side of the legend, 7.7% and even higher.
Notes about the graph:
The average profit margin of these sales is 4.7%. I showed the contrast 3 percentage points above and below, which tosses things into contrasting buckets. While a pie chart might best work with 3 or fewer segments, a treemap works well with many. People would have trouble seeing the many tiny slivers of pie chart and comparing them.
0 Comments
|