Quantified Office: Samoa That Cookie Data


Quantified Office: Samoa That Cookie Data

We are back with the next installment of InterWorks’ Quantified Office, thanks to another tasty delivery from Tracy. This time, she gifted us with five wonderful brands of chocolate coconut cookies, known to many as Samoas. Willing to bear the burden of finding the best cookies around, we decided to engage in another blind taste test.

The rules from our Thin Mint taste test remained the same:

  1. No one would know the brand of the cookie.
  2. Everyone would close their eyes while eating so as to not be influenced by other people’s reactions.
  3. Pinky promise.

I personally oversaw the random assignment of cookie brands as a neutral third party; I did not participate because I am #ThinMintsTilIDie

The main point of the dashboard is, of course, the ratings assigned to the cookies. For this data, I decided to look into different methods used for displaying survey data and settled on a Likert Scale view on a diverging stacked bar; you can learn how to build a Likert Scale view from many different YouTube videos.

Is the Brand Worth the Buck?

One of the unique facets of our setup was that we had InterWorkers also guess which brand they thought each cookie was. This means that we can compare what people thought each brand was worth vs. its actual worth. In the dashboard, I accomplished this with a pop-out view driven by a parameter action. The parameter in this case was a list of the different brands, and the action resulted in a calculated field evaluating whether the parameter matched a brand or a brand guess in the respective views. If you did not want to read that, here are some pictures:

I also used a couple Viz in Tooltips—one in the score bubble in the Likert Scale and one in the guesses chart in the bottom-right corner—to give some additional detail without overpopulating the dashboard. These are great for saving space and/or giving additional context to views already on your dashboard. Remember, if you use a Viz in Tooltip, keep it simple. Tableau is filtering the embedded view each time, so the more complicated it is, the more lag you will get when hovering over your views.

Go ahead and check out the view below. Reach out if you have any questions!

More About the Author

Grant Eisenmenger

Analytics Consultant
Introducing InterWorks Translate, Our DataDev Hackathon Project At InterWorks, we have always been a group of tinkerers. Near the end of last year, we had the opportunity to launch the Amazon ...
How to Wrangle Date Logic in Tableau TL;DR Build as much date logic into your calculations as possible, as opposed to using the Filters Shelf. Put your reference date (e.g. ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072