Transparency

For last week’s #MakeoverMonday the topic was land used for the production a single gram of protein for different food types. While my mission to try a new Tableau feature continues, I chose transparent charts this week, which, at least I think, is befitting to the topic, as this data visualization aims to create some transparency in what the real cost of our food is.

The environment is a very prevalent issue on my mind. Admittedly I’m not the biggest advocate, but I try to do my part. It is for this reason that I found this topic so interesting. But of course, the fact that over 68% of land usage goes to the rearing of cattle, lead me to other questions, such as, what is the usage of other resources, like water, and how does this relate to what we actually pay for our produce?

What I saw, by comparing a few different data set, all from ourworldindata.org, is that, of the food produces measured, beef has the lowest value for money. It also uses the highest amount of land for the production of one single gram of protein. In addition to this, it has one of the highest usage of water for the production of that one gram of protein, this probably also has to do with the irrigation of the fields that the cows graze on. So, not only does beef cost the most from our wallets, it also has an extremely high cost to the planet. For the meat lovers, pork and chicken are more sustainable, while fruit and vegetables may use up quite a bit more water, all in all, they are a more earth friendly option.

Transparency – of course, I chose the simplest of simple new Tableau tricks for this week. And once I figured out where to click, it really was super simple. It’s just a matter of selecting the chart you’d like to make transparent, right licking, selecting the format options from the data pane, selecting the pain bucket and changing the worksheet colour to ‘None’. And now you have a chart with your image as the background!

trans

And of course, here is the viz if you would like to explore. Clicking on the image will take you to the Tableau Public Link.

Screen Shot 2018-12-16 at 22.36.50

Happy Holidays!

Bump Charts

How to make a bump chart in Tableau (with a side of politics)

 

Finished product

 

Recently the Netherlands held their general elections. This was a tense time of year for me, having watched the UK vote to leave the EU and seeing Trump become president. Maybe I’m a bit of a hippie or an idealist, but I am not very much a fan of the current popular xenophobic opinions. Sure, the world is going through some uncertain times, but wouldn’t it be better if we just worked together?

I thought I’d have a look to see how the political climate has changed in The Netherlands over time. The results I found still a little alarming, the, what some may call the “racist” PVV party, has gone up in rankings, but luckily, has not reached the top!

Enough of that, it’s time to viz. So what I wanted to do with my viz, was see how each of the political parties ranked over the years. I got my data from the almighty Wikipedia. They have a page for each election year, showing how many seats each party has won. I copied and pasted these into an excel file. Simples!

Now to make the bump chart:

  1. Bring the measure (or dimensions) you want to splits your ranks by (in my case the year) to columns as a discrete field.
  2. Bring the field containing the members you want to rank to colours. In my case this is the ‘Party’.

steps 1 and 2

  1. To apply the ranking, you will need to create a calculated field for the measure you want to rank. To do this I’ve used the Rank Unique function.

 

Step 3

  1. Bring this new rank field to the rows shelf. This will look a little messy to start with.
  2. You now need to change the ‘Compute Using’ to your dimension of choice, which for me is ‘Party’. In case you aren’t sure how to do this, click on the triangle on the right-hand side of your rank pill and select, compute using, then your field.

step 4

  1. Almost there! To create the “bumps” you will need to make this a dual axis chart and change one of your marks to a circle. Done!

 

step 6

  1. Format etc. to your liking!

See the final viz here!