TALKIN' ABOUT DATA

I AM

image
Hello,

I'm Filippo Mastroianni

Data Driven Journalism, Data Visualization, dashboards and analytics.

Tableau Desktop Certified Professional, Tableau Ambassador, Former Tableau Featured Author.

As Data Visualization Specialist, 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
Senior Consultant
Data Visualization Specialist

The Information Lab Italia

Data Journalist

Il Sole24Ore

Gazzetta dello Sport

Marketing Specialist

AudioNova Italia


My Skills
Data Visualization
Tableau
Alteryx
Data Analysis

11

Viz of the Day

124

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!

#MakeOverMonday: Employment Growth in G7

For the first time I was involved in a weekly social data project called MakeOverMonday. Each week they post a link to a chart, and its data, and then you can rework the chart. The curiosity is to see if someone else can retell the story more effectively, or find a new story in the data.

What I liked the most of this week is the challenge to make something esthetically pleasing and creative from a little dataset. Proving that we don't necessarily need a lot of data to create something beatiful and carry out significant informations.

This one was the dataset:


I choose to use a waffle chart to visualize this data. I was tired of cake charts and bar charts, and I've never used this kind of graph. So I looked at this post of Andy Kriebel, and downloaded the template for the grid layout here.

At the end I modified the first dataset a bit, to add the lines in the middle of my Viz.
This is the dataset modified:


The dataviz was published on InfoData - Il Sole 24 Ore at this link:
http://www.infodata.ilsole24ore.com/2017/02/06/la-crescita-delloccupazione-nellera-obama-batte-quella-delle-economie-del-g7/

Here's the result of my first #MakeoverMonday.


Click below and go to the interactive Viz!

Us Presidential Elections History (1916-2012)

While we are waiting to know the name of the next US President, I created this data visualization to give a brief and easily searcheble story of Us Presidential Elections. This viz goes from 1916, when Woodrow Wilson triumphed over the republican Charles Evans Hughes, to the rielection of Barack Obama in the 2012. There have been several landslide presidential elections in US history, as this viz shows. In 1936, FDR carried 46 states, and in 1964, LBJ carred 44 states. Both Richard Nixon and Ronald Reagan carried 49 states, in 1972 and 1984, respectively. 

Who will be the next? Hillary Clinton or Donald Trump? 

This viz was also shared by Tableau Software, togheter with other beatiful #ElectionViz at this link: https://www.tableau.com/election2016?hootPostID=2867061b245ada87b26a38934a5aee51#landslide

Click below and go to the interactive Viz!

DatArt - Visualizing American Painters

This project was quite important for me. I was looking for a topic in the humanities, to create a dataviz for my thesis. Speaking of data in the humanities is problematic and controversial. In most cases the humanistic information relies on records, whether newspapers, books, magazines, articles, schools, colleges, maps. Any record of human experience can be a source for humanistic scholar, in contrast, for example, a scientist. That's why the humanities information is so peculiar. Must often deal with analog data, not discrete, they need to be translated into digital format to be used and processed. Moreover these data are usually part of a semiotic system that transcend physical measures.

Looking for a purely cultural topic for this dataviz, the first inspiration is actually came from an element I always had in plain view. The wallpaper chosen on my pc's desktop. Nighthawks, a painting by Edward Hopper, realized in 1942 and considered the most famous work by the American artist. So the idea was to explore the life, works, and as much as it were possible, of the American painters.

The first thing to do was to select the American artists to include in my viz. After some research the selected artists were: Andy Warhol, Edward Hopper, Paul Jackson Pollock, Roy Fox Lichtenstein, Franz Kline, Mark Rothko, Keith Haring, George Wesley Bellows, Georgia O'Keefe, Grant Wood, Thomas Hart Benton, Charles Sheeler, John French Sloan, Winslow Homer, Richard Diebenkorn and Frederic Sackrider Remington. Secondly it was essential to define what information was necessary to built the dataset with Excel. It was important to enable users to be able to really explore the viz and discover little by little interesting information on painters, as in the tradition of any good data visualization. The goal was not only to present graphs and simple data. Nothing is more representative of a painter unless his works. This is why I felt it was important to leave a space even to their paintings, in an attempt to create a kind of small interactive museum.

The central area of ​​the viz is dedicated to the auctioned pieces. The chart type I chose is a scatter plot. The idea of ​​using the brush stroke (with different colors according to the author) as indicative form of various pieces is a decision that must be justified. In a static viz this kind of chart would lose much of its effectiveness, making informations of the paintings sold at the lowest price virtually unreadable. I privileged the aesthetic appearance, aware that the tooltips and the table next to the chart, showing the title, price and author of all the pieces, would allowed to remedy this shortcoming.

The dataviz was then saved and published on Tableau Public, so that can be downloaded and shared by anyone. It received a mention as Viz Of The Day by Tableau Public, and is so inserted in the gallery section of the site and publicized online on September 15, 2016.

This is the description of my viz, made by Tableau Public: 
Filippo Mastroianni's viz shows off American Painters and their works, covering auction prices, artist birthplaces and life spans, and even shows self-portraits of the artists themselves. What a masterpiece!
Click below and go to the interactive Viz!

TolkienData - Mentions in Lord of the Rings

My mind often travels to the Middle Earth. For this reason I decided to create a dataviz ispired by Lord of the Rings and J.R.R. Tolkien's books. I looked at the frequency of characters mentions in Lotr. I created three bar charts to show the frequency in each chapter of the trilogy. Than I realized other 3 charts, trying to make them similar to a book (just for an aesthetic choice). In these graphs I reported the mentions in every single page of the books, so that it looks immediatly the presence of the characters throughout the story. 

In addition to this I showed all my 22 characters the best I can, underlining some of their attribute, like name, race, culture. On the right you can also read the first quote of the trilogy in which the character was mentioned. 
Take a look and have a nice trip in the Middle Earth!


Click below and go to the interactive Viz!

Offshore Drilling Operations in Italy

In Italy we voted for the referendum on Environmental Law, which regulates offshore drilling operations, on April 17, 2016. Consultation was wanted by 9 regions, concerned about the environmental consequences and the possible repercussions on tourism. Basilicata, Campania, Calabria, Liguria, Marche, Molise, Puglia, Sardinia and Veneto.

The question was related only to transactions already in place within 12 miles, because it was already forbidden to start new activities within this limit with the Legislative Decree no. 152.

I realized this graphic starting from data released by the Ministry of Economic Development. I wanted to point out all the marine platforms and similar structures present in Italian seas, paying attention to the 12-mile limit.

Click below and go to the interactive Viz!

Journalist in Russia: numbers of a dangerous job

Be a Journalist in Russia is not as in many other countries. Wars, crimes, terrorism, political assassinations. These are all the dangers that a Russian journalist (or a foreign correspondent in Russia) must face. 

The Committee to Protect Journalist collects data on journalists disappeared in the various corners of the world. The organization is independent, nonprofit and promotes press freedom worldwide. They defend the right of journalists to report the news without fear of reprisal. My analysis was concentrated on Russia. The dataviz tells a country full of contradictions and reporters' stories that have lost their lives in recent years.

This dataviz has some mistakes in graphic choices. It's one of my first projects, and I was not yet aware about visualization and its rules. For example a treemap is not the best choice to represent small numbers. But I want to observe my evolution, also with my mistakes.

Click below and go to the interactive Viz!

Mapping the Central Italy earthquake (2016)

An earthquake, measuring 6.2 ± 0.016 on the moment magnitude scale, hit Central Italy on 24 August 2016 at 03:36:32 CEST (01:36 UTC). Its epicentre was close to Accumoli, approximately 75 km (47 mi) southeast of Perugia and 45 km (28 mi) north of L'Aquila. There were severe damage especially in the town of Amatrice, near the epicentre, and in Accumoli and Pescara del Tronto.

That sad day I tried to quickly map the earthquake with a simple map. I dowloaded the data that I needed on INGV's site (Istituto Nazionale di Geofisica e Vulcanologia). Here you can find a costantly uptated list of all the shocks. You can choose the area in which you are interested, between Italy, Mediterranean and World. This site is particularly useful in case of italian events. 

I used the Tableau's mapbox service to customize my map, in an attempt to show all the comunes involved the best I can. This dataviz is really simple. A map in which every circle means a shock and is size the magnitude of the shock.

Click below and go to the interactive Viz!

Middle East and Oil Production

This is one my first projects, related to Middle East and Oil Production in this area. I wasn't good enough with tableau at that time, but I tried to visualize a dataset created starting from a file downloaded from Eia portal (U.S. Energy Information Administration). I realized that more than half of the world's proven reserves of hydrocarbons are concentrated in the Persian Gulf, which produces a third of the total production of oil and two-thirds of world exports.

This dataviz was created to support an article about Middle East and is geopolitical importance. The piece traces the history of oil exploitation, with a focus on the activity of Enrico Mattei, who  believed that the Italian development has been held back by US companies. The article can be read at this link: http://www.uskebasi.com/2016/03/medio-oriente-petrolio.html

Click below and go to the interactive Viz!

That is all on Data

Contact Me