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
Options for Row-Level Security in Tableau Now that you know you need Row-Level Security (RLS) and you are familiar with the basic concepts and building blocks, we can take a ...
Row-Level Security Basics in Tableau In this blog, we will run through fundamental concepts and building blocks for Row-Level Security (RLS) solutions. This will include: ...

See more from this author →

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


Love our blog? You should see our emails. Sign up for our newsletter!