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

Education and Foreign Languages

I created a new dataviz from Eurostat data, where you can find the average of languages studied for each European country and the percentage of English, French and German students.

Pencils represent the average number of foreign languages learned for pupils in secondary education (ISCED 2 and 3). The classrooms, on the other hand, represent the percentages of all upper secondary pupils (ISCED 3) who are learning English, French or German. Percentages refer only to general and non-vocational education in countries where English, French, or German are described as foreign languages in the curriculum or other official document.

You can read my article correlated on Info Data - Il Sole 24 ore: http://www.infodata.ilsole24ore.com/2017/06/22/europa-linglese-la-lingua-piu-studiata-italia/

Click below and go to the interactive Viz!

Wages and Retributions

According to data published by Istat on April 27, regarding collective bargaining and contractual wages, the contractual hourly wage index shows an increase of 0.1% in March compared to the previous month. A percentage that grows up to 0.4% compared to March 2016. Overall, after the first three months of the new year, the average hourly wage is 0.4% higher than the corresponding quarter last year.

I Analysed these data from Istat with a new viz, published on Info Data - Il Sole24Ore. You can read the entire article at this link:
http://www.infodata.ilsole24ore.com/2017/05/07/scopri-cambiati-gli-stipendi-negli-ultimi-due-anni-tutti-settori/

Click below and go to the interactive Viz!

French Elections 2017: Second Round Results by Department

New chapter for my data visualization story of the last French Election. After the second round Emmanuel Macron conquered the Palais de l'Élysée with 66.1%, 3 percentage points more than the optimistic predictions.

Marine Le Pen was stopped at 33.9%. As shown by the graphics, Macron conquered most of the French departments. Only Pas de Calais and Aisne are colored in blue, both conquered by Marine Le Pen with percentages between 52 and 53%.

The predictions for this election were the least predictive of French history. For a reason other than that recorded in Trump and Brexit cases. Emmanuel Macron's victory was largely underestimated. In actual results, the gap has expanded around 32 percentage points. An error in the forecast of about 10 points.

This dataviz was also published on Info Data - Il Sole24Ore, at this link:
http://www.infodata.ilsole24ore.com/2017/05/10/elezioni-francesi-2017-previsioni-risultati-finali-confronto/


Click below and go to the interactive Viz!

French Elections 2017: Second Round Polls

After the first round polls and the first round results my data visualization story of the French Elections obviously grew with the second round polls.

Here's the dataviz, published also on Info Data -  Il Sole24Ore, at this link:
http://www.infodata.ilsole24ore.com/2017/05/10/elezioni-francesi-2017-previsioni-risultati-finali-confronto/

Click below and go to the interactive Viz!

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!

French Elections 2017: First Round Polls

Every time there's an election, data people are excited to work on it! 

I made a lot of work for the last French Elections, trying to figure it out what was going on, analysing polls and results to create a data visualization story of this important democratic event. 

The first dashboard of this story was about the first round polls. The graphics focused on the top five candidates, those who had the potential to reach significant percentages. According to data collected by OpinionWay, independent candidate Emmanuel Macron was in charge of polls, with a 23%, ahead Marine Le Pen of a single percentage point.

The dashboard, with my article, was published on Info Data - Il Sole 24 Ore, at this link: http://www.infodata.ilsole24ore.com/2017/04/22/elezioni-francesi-cosa-dicono-sondaggi/

Click below and go to the interactive Viz!

Travels and holidays



It's time for vacations and travels!

I analysed the report on travels and holidays in Italy and abroad, published by Istat on March 31.

During 2016, for the first time after seven years, the number of trips and overnight stays made by residents in Italy increased. 66 million and 55 thousand of travels, with a positive change compared to the previous year ( + 13.7% ).

Italians travels has been decreasing since 2007. A trend that has affected not only leisure trips, but also trips for work reasons. 

In the Viz the most visited locations are organized on the "Tourist Line" (green) and "Workers Line" (red), in descending order. The trips to the Italian regions are compared inside the left box, that to European countries inside the right box. The percentages are calculated on the total travel for each respective sector. The percentages relative to the Italian regions compared to 100% of trips to Italy, those of the European countries compared to the total travel to European countries and so on about the rest of the world.

This Viz was published on Info Data - Il Sole 24 Ore, at this link: http://www.infodata.ilsole24ore.com/2017/04/15/viaggi-turismo-lavoro-italia-estero-ci-spostiamo/

Click below and go to the interactive Viz!

UK workers at risk of being replaced by robots

According to a report by PricewaterhouseCoopers (PwC), an international network operating in 158 countries, about 30% of UK jobs will be potentially threatened in the coming years by innovations in the field of artificial intelligence (AI). Lower than that of the United States and Germany, respectively 38% and 35%, but higher than that of Japan, to 21%.

Andy Kriebel and Eva Murray gave us an interesting dataset during the MakeOverMonday's week 14, about the situation of millions of UK workers at risk of being replaced by robots in the next years.

I used a simple trick to create this Viz, but I don't want to talk of this now. Since September I will update this blog with some Tableau tutorials, tips and tricks.

Also this Viz was published with my article on Info Data Blog - Il Sole 24 Ore, at this link:

The article was also chosen for the Top Ten #ddj: The Week’s Most Popular Data Journalism Links selected by the Global Investigative Journalism Network.

On October 3, 2017 this Viz has been included in the Information is Beautiful Awards longlist: https://www.informationisbeautifulawards.com/showcase/2411-which-uk-workers-are-most-at-risk-of-being-replaced-by-robots

Click below and go to the interactive Viz!

Trump Bans and terrorism

In this simple dataviz I wanted to answer a question: Do Trump's bans serve to fight terrorism? and after this first question, How many terrorist attacks in the US have been carried out by immigrants from 7 banned muslim countries?

So I created 3 maps: one for the electronic ban, the second about the immigration ban. The last one refers to the nationality of the terrorists who perpetrate an attack in US.

You can read my article (in Italian) or look at the Viz to answer these questions. The article was published on Info Data Blog - Il Sole 24 Ore, at this link: http://www.infodata.ilsole24ore.com/2017/04/09/scopri-la-correlazione-bandi-trump-gli-attacchi-terroristici/


Click below and go to the interactive Viz!

That is all on Data

Contact Me