TALKIN' ABOUT DATA

I AM

image
Hello,

I'm Filippo Mastroianni

Data Driven Journalism, Data Visualization, dashboards and analytics.

Tableau Desktop 10 Qualified Associate, Tableau Ambassador, Former Tableau Featured Author.

As Tableau/Alteryx Consultant, Filippo helps organizations make data driven decisions. He worked in different sectors, helping clients make sense of their data and embraces a new analytical culture. He has also several years of experience in online and print media as data journalist, designing engaging graphics and writing news stories for Il Sole24Ore and other media organizations. He has ability to pitch and write balanced, informative and compelling news stories to tight deadlines, remaining calm under pressure. Filippo uses Alteryx for ETL, data cleansing and data manipulation.

Filippo knows how to find stories and value in data and how to visualize them, trying to give voice to the numbers and the stories they have to tell. Even if his analytical background is important, his design skills help him to communicate his intuitions to others in an effective way.


Education
Università degli Studi

Bachelor degree of Science in Communication

Politecnico di Milano

Architectural Engineering

Liceo Scientifico A.Banfi

A-Level Scientific Lyceum


Experience
Tableau/Alteryx Consultant

The Information Lab Italia

Data Journalist

Il Sole24Ore

Marketing Specialist

AudioNova Italia


My Skills
Data Visualization
Tableau
Alteryx
Data Analysis

6

Viz of the Day

89

Vizzes on Tableau Public

Several

Dashboards published on Il Sole24Ore

Several

Illustrations Made

WHAT CAN I DO

Analytics

I help organizations make data-driven decisions.

Business Consultancy

I use Tableau and Alteryx to help companies make sense of data.

Dashboard Design

I create valuable and engaging dashboards.

Data Journalism

I write news stories and design dataviz suitable for use in Journalism.

Illustrations

I use graphic software to improve my viz with icons and illustrations.

It's All About Data

Everything revolves around data, and more so every day. My work too.

SOME OF WORK

Viz in Tooltip: advice on use and visual value


The first time I sat in front of my laptop with Tableau 10.5 installed, more than any other thing I was impatient to try a new feature that I waited for a long time: Viz in tooltip! 

As my colleagues know, I'm just obsessed with design and I always try to customize my viz the more I can. Viz in tooltip gave me this opportunity. What are they? Essentially a chart inside another chart. Obviously they can have a wider range of use. For me viz in tooltip means to have a new power in my hands. The power to simplify and make my viz clean and neat, adding details without any limitation to my creativity. How I used this feature in the first months of its life? Let's see! 

You can click on the screenshot to see the interactive viz and try all the tooltips.


SAVE SPACE AND TIME 

SAVE SPACE 
The first work in wich I used viz in tooltips was a visualization about italian universities. I analysed courses and subjects in every italian university from north to south. Fist and maybe most obviuos use for a chart in a chart: add more details to save space in the dashboard. This is what I did with the first of two different viz in tooltip in the viz.



For every university I add the number of courses and the icons of the different subjects in the tooltip. Less space to use in the dashboard means more cleanliness. 


SAVE TIME 
Second idea. I would like to customize the tooltip for every single city in my dataset. Maybe with a picture of the city...or what else? How much time I needed to find and save all that pictures in my tableau repository to use them as shapes? A lot of time I presume. So that's the second use for my viz in tooltip. 

I created a sheet in which I mapped the italian cities, using a shapefile downloaded from Istat. No more pictures, but maps! 





Here's another example of this use case: mapping the bloom of cherry blossom in Japan. 



ADD DETAILS: LOGOS AND CHARTS

Sometimes it's possible to save time with maps. Other time a picture of your dimension is exactly what you need to make you tooltip catchy. This was the case of the following viz, that try to ask the question "how much money big companies make in 1 second?" Nothing is bettere than its logo to make a company recognizable. Logo and text, a simple tooltip to give more informations to the public.





Maybe the most common use, really useful also in executive dashboards, is to put a different chart in the tooltip, to give a new point of view to the final user. For example visualize a trend from a single value, to understand how (and when) the total  number printed in the dashboard was built. Also in this case adding details means at the same time save space. 

That's what I did for the visualization below, in which I visualised the story of the Winter Olympic games. When and how the countries reached their medals? The trend in the tooltip can answer the question!



MULTIPLE SHEETS FOR A CATCHY TOOLTIP

Going ahead with my work and practicing with this feature, I started to create tooltip more and more complex. One of the main trick I absolutely like is to have lines that I can use as a sort of frame in my tooltip.




In the example below I used 3 different sheet in my tooltip. The first one with the movie poster, the second with informations about rating. And what about the third? It was only a sheet with a fake measure to create a bar. Exactly the line that I needed for my tooltip:




I find it pretty nice to customize the tooltip, also with different colours based on a specific dimension. Here's other tooltip made with the same trick:




ZOOM

Recently I geocoded all the beaches that won a blue flag in Italy this year. Mapped all the points my only issue was to give to the users the name of the beach and other informations more specific about the location. As I always done also with the previous Tableau releases, I added these informations in the tooltip. But in a nicer manner.

A beach and a big umbrella to give the impression of a zoom and of a postcard in a postcard. 





See you soon for another viz in tooltip 

and a new blog post!

Wimbledon's Champions

A higher step of all, to grow in the heels of tennis. The last Wimbledon tells that Roger Federer is the tennis player with the highest number of titles won in the oldest and most prestigious Grand Slam tournament.

I created this viz before the last final, writing an article on Info Data - Il Sole 24 Ore. You can read the article here: 
http://www.infodata.ilsole24ore.com/2017/07/16/wimbledon-tennis-campioni-le-finali-tutti-numeri-contano/

Click below and go to the interactive Viz!

North Atlantic Hurricanes and Storms (1900-2015)

In recent days it seemed that Irma could overcome Allen, the worst hurricane ever, that in 1980 blew up to 189.9 mph (about 305 km / h), causing hundreds of deaths and damage to $ 1.4 billion in time. According to the data Allen remains the strongest hurricane that has ever crossed the North Atlantic.


I collected data from NOAA, analyzing informations about all the hurricanes and tropical storms that hit the United States from 1900 to 2015. In total, the registrations were 1443. In the graphic I tried to tell in a visual way 100 years of hurricanes and storms in the North Atlantic.


This Viz was finally published on Info Data - Il Sole24Ore, at this link: 
http://www.infodata.ilsole24ore.com/2017/09/11/clima-un-secolo-uragani-nelloceano-atlantico-la-mappa/

Click below and go to the interactive Viz!

That is all on Data

Contact Me