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

French Elections 2017: First Round Results

The second dashboard of my French Election's data visualization story handled the analysis of the first round results.

Following the layout and design of the last dashboard (you can find it here), I created five little maps, which reflected the results of every candidate. The bigger one was instead coloured following the first-placed candidate by department. This second French Election's Viz was also elected as Viz of The Day on Tableau Public. 

This Viz was published on Info Data - Il Sole 24 Ore, at this link: http://www.infodata.ilsole24ore.com/2017/05/04/elezioni-francia-cosa-prevedono-gli-esperti-dati-secondo-turno/

Click below and go to the interactive Viz!

Age of Walls

My last dataviz analyses how 67 countries have erected fences or walls on their borders in the last years.
Last January 25, the president of the United States, Donald Trump, has signed an executive order to start the design of the wall on the border with Mexico, already promised in the election campaign. The aim would be to stop illegal immigration. But this isn't the only wall designed or built in the last years.

According to a study published in 2016 by the experts of the University of Quebec, Elizabeth Vallet, Zoe Barry and Josselyn Guillarmou, when the Berlin Wall was torn down, a quarter of a century ago, there were 16 fences around the world. Today there are even 63, affecting 67 states, completed or in the planning stage.

Here's my dataviz, published with my article on InfoData - Il Sole 24 Ore at this link:
http://www.infodata.ilsole24ore.com/2017/02/10/la-mappa-delle-barriere-dividono-mondo/

Update: On February 13, 2017, this dataviz was selected as Viz Of The Day by Tableau Public

Click below and go to the interactive Viz!

50 Years of italian Republic

In this dataviz I analized the last 50 years of italian Republic. We've seen alternating at Palazzo Chigi 21 different Prime Minister and 43 governments, one every 1.16 years.

Silvio Berlusconi, with 3312 days as Prime Minister, is the politician more present at Palazzo Chigi, overcoming one of the leading actor of the history of the Republic, Giulio Andreotti.

Andreotti is the politician with the largest number of offices. Seven times Prime Minister. Andreotti served as the 41st Prime Minister of Italy from 1972 to 1973, from 1976 to 1979 and from 1989 to 1992. Andreotti was also Prime Minister of the "National Solidarity" government with the support of the PCI, wich refrained the vote of confidence.

The government ended on December 7 is the fourth longest in the republican history, with 1019 days. Matteo Renzi is ranked tenth among the Prime Minister for the task duration.

This dataviz was published with my article on InfoData - Il Sole24Ore http://www.infodata.ilsole24ore.com/2016/12/12/tutti-premier-della-repubblica-degli-ultimi-50-anni-volto-del-governo/

On december 14, 2016 this visualization received a mention as Viz Of The Day by Tableau Public. 

On january 6, 2017 it was added to the Greatest Hits gallery by Tableau Public.

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