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.

Contact Me Tableau Public

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.


WHY FREE DATA

"Freedom is the freedom to say that two plus two makes four. If that is granted, all else follows"

___ George Orwell, 1984 ___

WHY DEVELOP NEW SKILLS

“Every skill you don’t have leaves a whole class of stories out of your reach. And data stories are usually the ones that are hiding in plain sight.”

___ Scott Klein ___

BE A JOURNALIST IN A DATA DRIVEN WORLD

"But having an open data portal doesn’t automatically make you a haven of freedom – even Bahrain and Saudi Arabia now have open data portals. [...] This is where data journalists come in – by exposing and interrogating the data, we can test how accurate it is, mash it up with other datasets to produce results that tell you something new about the news.

___ Simon Rogers ___
SOME OF WORK
All on the blog Il Sole 24 Ore Viz of the Day Tableau Tutorials Datablog

50 years of The Good, the Bad and the Ugly

For InfoData - Il Sole 24 Ore I customized one viz I created weeks ago, about The Good, The Bad and The Ugly. The movie was released for the first time in Italy on December 23, 1966. It was is 50th birthday and I thought to publish a tribute to the movie, in memory of Sergio Leone. 

 The Good, the Bad and the Ugly was marketed as the third and final installment in the Dollars Trilogy, following A Fistful of Dollars and For a Few Dollars More. The film was a financial success, grossing over $25 million at the box office. 

 This is my new dataviz, published on InfoData at this link: http://www.infodata.ilsole24ore.com/2016/12/23/buono-brutto-cattivo-compie-50-anni-quello-dovete-sapere/?
Click below and go to the interactive Viz!

How parties voted the proposed Constitution

After the first exit polls, Prime Minister Matteo Renzi announced on a midnight press conference his resignation the next day. In his speech, Renzi assumed a full responsibility for the referendum defeat.

 In accordance with Article 138 of the Constitution, a referendum was called because the constitutional law had not been approved by a qualified majority of two-thirds in each house of parliament in the second vote. The constitutional referendum rejected the law by 59.11% of the votes, meaning the constitutional reform will not come into effect.

But how we arrived to the constitutional referendum?

The proposals passed both the Chamber of Deputies and the Senate six time, three for each house. After that Renzi announced that he would hold a referendum to secure the endorsement of the Italian people for the change.

This is how italian parties voted the proposal.
Click below and go to the interactive Viz!

History of italian referendum

Today is the day. We are going to vote on the costitutional referendum in Italy. I decided to create some datavizzes on this occasion. The first one is a brief history of italian referendum, from 1974 to the last one on oil and natural gas drilling, that was held in Italy on 17 April 2016.

 I'm very proud because this is the first dataviz I can publish on the site of one of the main italian newspapers. I'm talking about Il Sole24Ore, an Italian national daily business newspaper. With is InfoData Blog, Il Sole24Ore is trying to give a space to data journalism. This is the link: http://www.infodata.ilsole24ore.com/2016/12/04/litalia-referendum-dal-1974-oggi-tutti-numeri/

Waiting for the results of this key moment for my country, this is my dataviz about italian referendum.
Click below and go to the interactive Viz!

How States Have Shifted Over the Past Decades

It's been a while since I've seen my first flow diagram. I always wanted to create one, using the Sigmoid Function, to try something new. I never had the right idea. But this week I thought to represent how states have shifted over the last decades and Us elections.

I looked for the data I needed and I created the dataviz below. It was an hard work, also because it needed several Calculated Field, for curves, colors and other. 

This is my tall Sankey diagram. The size of every state is related to his electoral votes. The coloured lines represent the states that have shifted between two consecutive elections. 

Here it is. Enjoy!
Click below and go to the interactive Viz!

US Presidential Election 2016 Results

The Election is over. Donald Trump is the 45th President of the United States. Those who believed in little chances for Trump were wrong. Journalism misundertood what was happening. We have now our results and I visualized them on a new dataviz. Nothing more than an Election Viz, with all the numbers about this election.

I need to mention a great tutorial, written by Matt Chambers on his blog Sir Viz-a-lot. With his help I created the cartogram below, one of the best way to visualize election results in Usa.

Click below and go to the interactive Viz!

Oldest US Presidents at Inauguration

Tonight is the election night in the United States. The 50 states and Washington DC vote across six different time zones throughout Tuesday, 8 November. Donald Trump or Hillary Clinton. One of them will be the 45th president. They have to win 270 electoral college votes to become president. Trump faces a much more difficult path to victory. This is because Democrats start from a stronger position. There are 18 states plus DC that have voted for a Democrat for president in every election since 1992. There are only 13 states that have voted for a Republican in every election since 1992. Those states carry just 102 electoral votes. 

 Whoever wins between Trump and Hillary, will be one of the oldest presidents in the history of the United States, as shown below, in my last dataviz.

Update: Donald Trump wins presidential elections. He is the oldest president in the history of the United States (70 years and 220 days old at inauguration).

 At the day of Donald Trump Inauguration this dataviz with my article was published by InfoData Blog - Il Sole 24 Ore at this link: http://www.infodata.ilsole24ore.com/2017/01/20/donald-trump-arriva-alla-casa-bianca-sara-presidente-piu-anziano-sempre/
Click below and go to the interactive Viz!

Numbers in The Good, the Bad and the Ugly

Cinema is one of my great passions. For this reason I decided that the topic of my last dataviz would be one of the movies I loved the most. I choose The Good, the Bad and the Ugly, a 1966 Italian Spaghetti Western film directed by Sergio Leone, starring Clint Eastwood, Lee Van Cleef, and Eli Wallach in the title roles respectively. Ennio Morricone composed the film's score, including its main theme, and the themes of the three characters, you can listen choosing one of them in the dataviz. 

 The Good, the Bad and the Ugly is now seen as a highly influential example of the Western film genre and one of the greatest films of all time.
Enjoy!
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!

Hayao Miyazaki's Movies Infographic

Cartoonist, animator, screenwriter, director, film producer, animator. Hayao Miyazaki has also worked on series of very famous anime, as Lupin, Heidi, Anne of Green Gables and Future Boy Conan. Something more than just cartoons for kids and teens. The movies of Miyazaki have everything you want to find.

That's all (or almost) Miyazaki in the dedicated infographic.

Cinecomic: Marvel vs DC Comics at the box office

One of my greatest passions are cinema and movies. I'm also a contributor and journalist for Cinefilos.it, a website that deals with this topics. One of my post on my blog was about the fight at the box office between Marvel and Dc Comics, in a world increasingly characterized by cinecomic.

One of my infographic concerned how much the superheroes earned at cinema. This visualization is dated November 11, 2014.



Robin Williams' career in an infographic

Robin Williams died on August 11, 2014. He was a great actor, comedian, screenwriter, capable of reaching the highest award, the Oscar, in 1998, with his performance in the film Good Will Hunting. An Academy Award for Best Supporting Actor, but alsothree nominations for Best Actor, as well as three Golden Globe Awards and numerous other awards.

I  retraced his career with an infographic.


Islamic State of Iraq and Syria (ISIS) Infographic

My second infographic was about the Islamic State of Iraq and Syria (ISIS). I am really interested in Geopolitics, and i needed a visualization to summarize an article on this terroristic organization. The infographic is nothing special. Is a simple summary of what I wrote in my piece, analyzing the phenomenon of Islamic terrorism. Also this infographic is made with the help of Easel.ly, Infogr.am and Gimp. 


My first (raw and ugly) infographic

My first approach with visualization was more then 2 years ago, when I was looking for a graphic to assist an article about all the wars around the world at that time. The most important thing was to map (also very vaguely) events, to show the most dangerous places in the world. At that time I was never been interested in visualization, and I had never heard of softwares like Tableau.

The first open source tool I used was Easel.ly, where is possible to create and share visual ideas in a simple way. This is what I created the first time I tried to visualize something. I don't like it now, obiouvsly. But I want to share it.

My first, raw and ugly infographic!


That is all on Data

Contact Me
Milan, Italy
image