Data visualization is a fascinating area. As part of my constant learning through it via Tableau I took the challenge to build a viz based on any dataset that I could find in Wikipedia. And look what I found:
For those who don’t know the series (basically all single people out there) it is basically a competition between a realtor (David) and a contractor (Hilary). The goal for the realtor is to make the family sell their house and move to a new one; for the contractor the goal is to renovate the current house so they will love it and stay.
To start my visualization I first tested selecting, copying and pasting the data from Wikipedia straight to Tableau and it worked!
From (Wikipedia):To (Tableau):
After that I had to do use the pivoting features in Tableau basic pivoting in the data to create the Host dimension that will help me with my analysis. And it was as simple as selecting two columns on the Data Source screen, right-click and Pivoting:
Next I’ve added a nice name to the column (Host) and changed the aliases from “Hilary wins” to only “Hilary”; the same with “David wins” to David. My data was just looking as good as I need:
From this I was able to get the first element for my viz: who has more wins overtime. But at this time I realized that I really needed data for all episodes so I can give more detail about the competition. So I got the data for all episodes also from the same Wikipedia page, but this time I put them in an Excel where each victory was represented by the number 1.
Now it was time to search for inspiration so I found this great viz from Matt Chambers about the history of NFL:
In order to reproduce this concept I had to figure out how to make bars on top for Hilary victories and down for David’s. So I told Tableau do this:
IF [Pivot Field Values] = 1 AND [Host] = “Hilary” THEN 1
ELSEIF [Pivot Field Values] = 1 and [Host] = “David” THEN -1
Translation to humans: Tableau, if you have Value 1 and Host Hilary, make this represent 1; on the other end, if Value 1 is related to Host David, then make it -1.
Next I had to put the series number to column (so tableau adds one bar for each episode) and the result of the above calculation (which I called “Love or List”) into rows. The result was what I wanted!
I applied a color to each host to make it clear which bar represented their respective victories.
The rest was basic viz designing and I found a picture for each host, a logo for the show and so on.
And here is the final product:
And the best part is this one. On first week of January 2017 the show was starting a new season so I took the chance to tweet the hosts with the viz. And it was amazing that I got some unexpected replies 🙂
So what do you think about this viz? Do you love it? Or would you list it?