8/14/2015

Hacker Month -- Tableau Public

French Presidential election in 2012


This month, Tableau Public launch the Hacker Month which promote out of the ordinary vizzes. I chose to remake an old viz I have done 3 years ago about the Presidential election. This viz was created during the "inter-rounds weeks" and the aim was to simulate the final result: who will be the next president ?!

The main trick is about parameters. Indeed, I used parameters to allow users to simulate final result in function of the transfer of votes between candidates. Users can type a value from 0 to 100 and give a little part to abstention. This trick is used to calculate the result for France and for each county. The parameters was inserted in calculations to provide a percentage corresponding to the candidate's result. Here is an example of the calculation:

(([% Voix/Exp HOLLANDE]+[% Voix/Exp BAYROU]*([BAYROU pour HOLLANDE]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour HOLLANDE]/100)+[% Voix/Exp ARTHAUD]+
[% Voix/Exp JOLY]+[% Voix/Exp MÉLENCHON]+[% Voix/Exp POUTOU])

/

([% Voix/Exp SARKOZY]+[% Voix/Exp BAYROU]*([BAYROU pour SARKOZY]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour SARKOZY]/100)+[% Voix/Exp CHEMINADE]+
[% Voix/Exp DUPONT-AIGNAN]+[% Voix/Exp HOLLANDE]+[% Voix/Exp BAYROU]*([BAYROU pour HOLLANDE]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour HOLLANDE]/100)+[% Voix/Exp ARTHAUD]+
[% Voix/Exp JOLY]+[% Voix/Exp MÉLENCHON]+[% Voix/Exp POUTOU]))*100

The first part of the calculation is the percentage for the left side candidate and the second part is the total. This calculation gives me a percentage used in a bar chart. The same method was used to create the map (the difference is that I chose voices quantity instead of percentage).
Moreover, I tried to create a map wich shows an overview of french counties in function of the political side. This map was different compared to the press. Indeed, this was not a map in function of political party and it tried to show a different view of french counties. For instance, it is not because a county chose UMP (right side) that the global trend is right side and vice-versa!

The last trick I used was to show bar charts in tooltips. This trick is really great because it allow users to know the distibution for each county. To do this a method is existing using special characters and formulas. Here is an example of calculation:

Left("██████████████████████████████████████████████████",ROUND([% Gauche carte 2nd tour]/2))

This calculation could be set in the tooltip to create a bar. In this case, the measure is relative (percentage) and divided by 2 because I used 50 special characters (and no 100 one). The result is a bar chart in the tooltip that we can customize (color, font...).



The last trick I used 3 years ago was a custom geocoding. Indeed, in 2012 counties for France was not available in Tableau Desktop. That is why I created a dataset allowing me to draw counties. If I had to remake it now, I think I will build the dataset in another way to make it easier to use.

Don't hesitate to leave a message or a note about this work.

Source: InsideAirbnb - Get the data
Thank you for the reading!

22 comments:


  1. It is beautiful article, In present days more opportunities on datavisualization,
    Tableau Online Training gives the best jobs

    ReplyDelete
  2. thank you for offering such a nice content.it is very unique content and very helpful for learners and professionals

    Tableau Online Training in hyderabad
    Tableau Online Training

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. i just go through your article it’s very interesting time just pass away by reading your article

    looking for more updates. Thank you for sharing. Best Devops Training Institute

    ReplyDelete
  5. We as a team of real-time industrial experience with a lot of knowledge in developing applications in python programming (7+ years) will ensure that we will deliver our best in python training in vijayawada. , and we believe that no one matches us in this context.

    ReplyDelete
  6. Thanks for sharing information, excellent article, keep continue this....
    CRT online training

    ReplyDelete
  7. Hey, Nice one information

    Online IT Software Courses Training ICT South Bopal - Ahmedabad

    Institute of Computer Training - ICT Bopal

    ReplyDelete
  8. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. Thanks for sharing your informative post on development.

    Tableau Training in Gurgaon

    ReplyDelete
  9. Our the purpose is to share the reviews about the latest Jackets,Coats and Vests also share the related Movies,Gaming, Casual,Faux Leather and Leather materials available Ghost Modern Warfare Jacket

    ReplyDelete
  10. Very Nice Blog…Thanks for sharing this information with us. Here am sharing some information about training institute.
    tableau online training in hyderabad

    ReplyDelete
  11. I love to recommend you Where can crawl Exciting Products latest Jackets, Coats and Vests Click Here Rip Wheeler Jacket

    ReplyDelete
  12. very pleasant say. I just found your weblog and needed to pitch that i've beyond question appreciated perusing your weblog posts. After each wiped out buy in on your feed and that I dream you compose inside a similar way as again rapidly! Wifi Hacking Online

    ReplyDelete
  13. You have accomplished an inescapable interaction upon this article. Its completely legitimate and strongly subjective. you have even figured out how to make it comprehensible and clean to get to. you have a couple of legitimate composing capability. much thanks to you subsequently much. Windows 10 Product Key Free

    ReplyDelete