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

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!

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!

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!

That is all on Data

Contact Me