LAUREN OWEN
  • HOME
  • BLOG
  • CONTACT

Tableau Data Vizualization and Treemaps

2/22/2022

0 Comments

 
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. ​
  • The mustard yellow products represent the lowest performing products, gray represents around the average for the store, and purple represents the most profitable products.
  • The size of the boxes indicates how well that item sells compared to other items, so that we can know how popular an item is to our customers.
Dynamic, interactive chart:
https://public.tableau.com/app/profile/lauren.owen8138/viz/charts_16455784432710/treemap2
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

    Archives

    March 2022
    February 2022
    October 2021
    January 2021
    August 2018

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • HOME
  • BLOG
  • CONTACT