ECG de Paris : les voies ferrées irriguent la ville
L'arrivée de Tableau 10.5 en ce début d'année amène son lot de nouvelles fonctionnalités. Parmi les quelques innovations de Tableau Desktop 10.5, on peut apprécier le déploiement du nouveau moteur d'extraction (Hyper) et aussi, la tant attendue, fonctionnalité d'insertion de graphiques dans les infobulles !! Ce billet de blog va se concentrer sur ces deux fonctionnalités. Je ne parlerais pas de Tableau Server Linux qui lui mériterait un billet de blog complet tant c'est une nouveauté attendues (depuis 2014 pour ma part...). Vous êtes prêts ?!
This is currently the hurricane season in the North Atlantic. As everyone knows, Harvey, Irma, Jose and Maria hit the Carribeans and the USA between July and September. When I saw a lot of reports about the damages in the news and in my Twitter timeline as well, I wondered if 2017 was a special year or not. I also wondered if this perception of 2017 being a “special” year was due to the media and the Internet, making us more aware of this kind of severe weather than before.
So I told myself: "Try to find some data about Hurricanes and go check it!!" First, I thought I would find all that I wanted on the NOOA website. Indeed! There is a lot of content on this website (especially very interesting shapefiles, and you know how I love geographical data...). But, I was actually looking for more detailed datasets. That is why I used the Unisys website and this one was a real mine of information! This website allowed me to download all the tracks of almost all the hurricane since 1851! And here is the beginning of my journey about hurricanes!
La semaine dernière a eu lieu la traditionnelle Tableau conference On Tour à Londres. Ce fut l'occasion pour une partie de la #SynalTeam (Hélène "Bibiche" Trouvé, Franck "Chicken" Nguyen et Jonathan "Poulidor" Trajkovic) de se déplacer dans la capitale britannique afin de voir ce qu'il en est. Comme mes chers camarades l'ont déjà expliqué, il y avait plein de choses à voir : des keynotes, des sessions, des formations, des cafés, des smoothies... bref, moult animations et autres présentations dignes d'une grande kermesse des écoles à la sauce Tableau.
De mon côté, j'ai eu la chance juste 2 semaines avant ce grand rassemblement d'être retenu pour disputer la finale de la première compétition IronViz européenne ! (Pour rappel, voici en quoi consiste l'IronViz). La compétition avait lieu le dernier jour en début d'après-midi, soit en réalité quasiment la dernière session avant la fin de la conférence. Tout ceci prenait place dans la salle accueillant les keynotes et rassemblant plus de 1000 personnes - ça fait un paquet de yeux qui vous regardent faire une viz pendant 20 minutes...
Comme vous avez pu le remarquer, la première session de l'IronViz est ouverte ! OUAAIIIIS SUUUUPEEEEER !! ... Bon... tout ça c'est bien beau mais : qu'est-ce que l'IronViz ?! Eh oui !! Eh bien chaque année, Tableau organise un concours de visualisation de données se déroulant en plusieurs phases avec à la clé un voyage complet pour la conférence Tableau aux USA. l'IronViz, c'est ça ! C'est pas beau, hein ?!
Tableau 10.2 est arrivé il y a environ 2 semaines et avec cette nouvelle version des fonctionnalités toutes neuves font leur apparition ! Parmi toutes celles qu'on retrouve sur ce magnifique article web, mon cœur a déclaré sa flamme, belle et pure, à l'intégration des fichiers géospatiaux. Eh oui, Mesdames, Mesdemoiselles, Messieurs, Tableau lit ENFIN les fichiers géospatiaux et comprend, a fortioti, la géométrie !! Si c'est pas un progrès de "déglingos" ça ?!
Vous imaginez tout ce qu'il est possible de faire en terme de cartographie dorénavant ? On n'a pas les communes de France ? PAF, le shapefile provenant d'Open Street Map. On veut présenter les tracés des lignes de chemins de fers et c'est pénible de les redessiner en "custom polygons" ? BIM, un géojson qui va bien issue d'Open Street Map ou du portail Open Data de la SNCF ! On est sportif et on a une envie de faire une visualisation "Quantified Myself" ? CRAC, le fichier kml de mes itinéraires de footing... Ah la la, que c'est beau, mais que c'est BEAU !! A croire que Tableau cherche à nous simplifier la vie ! Bon ce ne sont pas les idées qui manquent mais concrètement, comment ça marche ? Et, est-ce que ça fonctionne bien ? C'est ce que nous allons essayer de voir ensemble, durant les 5 prochaines minutes de lecture de cet extraordinaire billet de blog.
Currently I am lucky because I have some time to create vizzes with Tableau 10. I am very curious about Device Designer efficiency and use. That is why I did a couple weeks ago a viz about french wine. This week, I used Open Data about subway in Paris (again!). Since my first wiz about Paris' subway, I want to show visualisation about time and trip. that is why I chose GTFS files (all data are available here : GTFS files).
Après de bonnes vacances d'été, le temps est arrivé de retrouver notre sérieux. C'est pourquoi j'ai choisi comme sujet les vins AOC/AOP en France. Les données sont issues du portail gouvernemental Open Data data.gouv.fr ainsi que de Wikipedia et d'un site spécialisé sur le vin Wine Searcher. Donc soyons sérieux : parlons vins !
Tableau 9.3 est à peine arrivé que la version 10 est déjà en beta test... La beta 1 est en effet sorti il y a à peine une semaine. Cette nouvelle mouture de Tableau a vraiment des atouts intéressants. Pour le moment seules quelques évolutions sont disponibles, en attendant les prochaines itérations de la beta, mais ce que nous avons pu tester nous a vraiment séduit.
April is the #FoodTipsMonth and time for the first IronViz (about food of course).for IronViz on Tableau Public. So I decided to do a small vizualisation about food. Moreover, one of the datasources for IronViz contest is Open Food Facts.
I was working for a customer since December on a really big project. During development, they ask me to show training journey with an original chart (they had a prototype but it was not really understandable). They also saw several charts really interesting among which Network one. That is why I try to do it!
This is an analysis of Twitter's hashtags after the week-end. I used a website (www.takwalker.com) to get the data. The dataset is aggregated for each hour of each days from Friday 13rd November 2015 to today. I chose to try to tell the story with Twitter's data.
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 ?!
After my last blog post about The Social Progress Index, I had a question about the creation of a radar chart. I will try to answer the question clearly during this blog post. On my own, I think radar chart is intersting if you want to compare members of a dimension in function of several metrics (you can also use Parallels coordinates). For example, when you want to buy a smartphone you can compare several devices with a radar chart (metrics: battery, camera, memory...). Let's try to explain how to create this in Tableau.
Trigonometry, my best friend ever!
To create a radar chart, I have to use trigonometry formulas... You remember the circle with Pi and number and stuff like that... ?
Well... It is important to use it to create axis and it depends on number of metrics you want to display. Indeed, if you want to display 5 axis (= 5 metrics) you have to use differents formulas than 6 axis chart. In my case I used a 12 axis chart so I had to use several formulas (as on the image above).
Thanks to Internet I was able to find the different formulas and create a calculation in Tableau for X axis and Y axis.
Calculation for [Xaxis]
case [Dimension]
when "Member 1" then 0
when "Member 2" then [Value] *(1/2)
when "Member 3" then [Value] *(sqrt(3)/2)
when "Member 4" then [Value]
when "Member 4" then [Value] *(sqrt(3)/2)
when "Member 5" then [Value] *(1/2)
when "Member 6" then 0
when "Member 7" then [Value] *(-1/2)
when "Member 8" then [Value] *(-sqrt(3)/2)
when "Member 9" then [Value] *(-1)
when "Member 10" then [Value] *(-sqrt(3)/2)
when "Member 11" then [Value] *(-1/2)
end
Calculation for [Yaxis]
case [Dimension]
when "Member 1" then [Value]
when "Member 2" then [Value]*(sqrt(3)/2)
when "Member 3" then [Value]*(1/2)
when "Member 4" then 0
when "Member 5" then ([Value])*(-1/2)
when "Member 6" then [Value]*(-sqrt(3)/2)
when "Member 7" then [Value]*(-1)
when "Member 8" then [Value]*(-sqrt(3)/2)
when "Member 9" then [Value]*(-1/2)
when "Member 10" then 0
when "Member 11" then [Value]*(1/2)
when "Member 12" then [Value]*(sqrt(3)/2)
end
It is very important to have the same [Value] scale for each [Dimension] members! Indeed, the 12 axis have to be the same. In my case the scale was from 0 to 100.
Build the radar to detect everything
After the creation of calculations, I had to build the chart. To do this, I just have to drag and drop the [Yaxis] on the lines shelf and the [Xaxis] on the columns shelf.
You can note that I use the aggregation Average (because Sum will returns a wrong result). Here I have only 1 point. To create the radar I have to use several dimensions (in my case, [Country] and [IndexType]). The [IndexType] allows me to draw 12 axis because this is a dimension with 12 members; [Country] allows me to draw 1 radar by country. If I want to draw the average radar chart, I can remove the [Country] field. To have several points I add [IndexType] on the Mark shelf as a Level of Detail.
After I can change the Mark to draw a polygon and add [Country] as a quick filter.
To have a beautiful radar, the last things to do are put [IndexType] as a Path to follow and Fix axis between -110 and 110 (or whatever you want to have enough space between borders and chart).
Some Formatting and "Voilà"!
To give some design to my chart, I chose to remove grid lines, Zero lines and borders, and to hide headers. Moreover, I chose to give some trnasparency and a border to my polygon in order to have a more beautiful chart.
Finally, I drew a background image to have reference axis in order to give some visual impact. Indeed, I think it is better if you know where the maximum is.
To add beautiful tooltips, it is important to put AVG([Value]) on the Mark shelf and to configure the tooltip like this:
Two weeks ago, I was browsing the Tableau community forum and I found an interesting question about reference line. The question was about to create a band reference line but just for few members in a dimension (Here is the question). This question drove me to an other question: Is it possible to create a "dynamic" reference line?
To answer it, I chose a dataset about Social metrics in the world: The Social Progress Index. With this dataset I tried to create a "dynamic" reference line.
As you can see in the visualisation below, when you click on a country on the map the reference line in the distribution graphic shows the average gap. The average gap is represented by a grey band calculated when the user click on a country. My idea was to show the gap when a country is highlighted and the average line in the other hand. To do this I used th LoD. It was just my second time with LoD... and it was very interesting!
The formula used in the LoD calculation allows me to calculate the general average: { EXCLUDE [Country]: avg([Value]) }. To build the reference band, I chose the average for each country as the end and my LoD calculation as the begin. The 9.0 version of Tableau allows me to show re-calculated reference lines when a mark is selected so I used it to redraw the reference band! Because in fact, the band is equal to 0 when no selection is provided. After this I chose to add some other graphics such as the radar graph to show the shape of each country and a map to allow the selection.
Feel free to leave a message or a note about this work!
Thanks to Jewel Loree from Tableau Public, I found a dataset about Airbnb. The timing was excellent because I had to choose an Airbnb accomodation for a training in Luxembourg a few weeks ago. When I discovered the website Inside Airbnb, I was suprised to find a lot of CSV files concerning several cities around the world. As a French, I chose to start my analysis with Paris but actually, I downloaded all the files to build the visualisation below.
IronViz time is here! This post is about my entry for the Wiki Contest. I have to admit that it was difficult to find a topic. First, I told me that it was too difficult to find a good and interesting topic with enough data and enough time to prepare these data... but in fact I found a topic yesterday evening during the Tableau User Group in Paris. During a conversation with co-leaders, they told me that we have to tell everybody : "French people do Tableau too !" That is why I choose to do a viz about The Eiffel Tower. I think it is a great construction and a great symbol for France!
You can find the viz just below. I tried to tell a story with the data of Wikipedia. I tried to present information about visitors, about the construction and the replicas. I put the sources just after the viz.
This post will be updated soon with more information about the method and the data.
This second post is here to relate you my IronViz in Seattle. Already one month and I can tell this was a dream !! Indeed, 3 weeks before the #DATA14, I would not able to predict this journey. That was an unbelievable adventure. For me and my wife (she accepts to be with me in a conference linked to my job !) it was my first time to the United States of America !! And it was amazing ! Each person I met in Seattle was gentle and lovely. I can espacially thank Tara Walker, Jewel Loree and Ross Perez from Tableau Software, and Jeffrey Shaffer and John Mathis my contestants for their welcome. They were very gentle with me in spite of the language !
Here is my first blog post about Tableau Software, my job tool. This blog will try yo present and explain my work with Tableau Desktop with customers and Tableau Public with Open Data. I will try to give some tips about Tableau and to explain some tricky vizzes.
This first blog post comes after #DATA14, the Tableau Conference which took place in Seattle a month ago. I had a chance to be a part of this story thanks to my qualification for the IronViz contest. This post will try to give an answer at this question: how did I win the Storytelling Viz Contest ? I am going to explain my viz (Les Accidents de la route en 2012).
