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

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!

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!

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!

That is all on Data

Contact Me
Milan, Italy
image