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

The DataJournaLIST - week8


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

FOOD AND AGRICOLTURE

1. FAO


14% of the 's food is lost after harvest and before it can reach the retail level. You can learn about where and why food loss and waste occurs in FAO’s SOFA2019 Report and find out what you can do to take action. Statistics, visualizations, illustrations, video and animations. Some cool graphic and serious concerns for humanity in this interesting report.

ENVIRONMENTAL POLLUTION

2. EL DIARIO

It all started in 2011. This is the interactive story on how the Mar Menor was contaminated. The largest salt water lagoon in Europe, after decades breaking the law, and an underground chaos of canals, desalination plants and uncontrolled spills. A longform full of informations on the topic.


WOMEN AND WORK

3. WALL STREET JOURNAL

Where exactly the gender disparities start? The “broken rung” is the biggest obstacle that women face—and it’s just ONE of the key takeaways from this study published on The Wall Street Journal. A preview of the statistics: Though women and men enter the workforce in roughly equal numbers, men outnumber women nearly 2 to 1 when they reach that first step up. You can understand better looking istograms, pies and more!

BREXIT

4. REUTERS GRAPHICS

Every week it's impossible to exclude Reuters Graphics from the list! Even we're not talking about real data journalism this time, I can't not admire this wonderful piece of graphic journalism, that combine perfectly storytelling and nice illustrations. One of more chapters, this is also an interesting resource to understand better what's happening on the border between Eire and Northern Ireland.


CANADIAN ELECTIONS

5. THE GLOBE AND MAIL

We have a new entry in our list! Globe and Mail has been working for years with data. This time the team tried to visualize how canadian party leaders organize their campaign to win. They have to be pretty ruthless about spending their time, and their money, travelling to where they can win seats. Tracking where the leaders go can give you a good sense of how they are doing – and what they are fighting over.

The DataJournaLIST - week7


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

VOTE ON CLIMATE CHANGE

1. THE GUARDIAN


The climate emergency is still on the list. One of the main topic during the last weeks is addressed by The Guardian from a new perspective. With an interactive tool you can explore MPs’ records on 16 climate votes between 2008 and 2018.

AUTO EMISSIONS

2. THE NEW YORK TIMES

Did you know that transportation is the largest source of planet-warming greenhouse gases in the United States. You can discover how much is rising in USA city by city with a very detailed emissions map.

IT'S AUTUMN!

3. WASHINGTON POST

In the most colorful period of the year, here's one of the most colorful piece of data journalism!  This is the period for leaf peepers, wind and snow are coming and the forest are changing. Forest types and foliage colors along USA are told through illustrations, maps and visualizations. 

MOVEMENT AND MIGRATION

4. EL CONFIDENCIAL

Do you know how many people have come to your city from other provinces in the last 30 years? And how many have left? El Confidencial developed an amazing search engine that has all the data. So if you're spanish now you know! If you're not you can however explore this interactive tool.

TRUMP IMPEACHMENT

5. FIVETHIRTYEIGHT

FiveThirtyEight is the Bible of opinion poll analysis, political, economics and sports related. This time the team starts tracking impeachment polls with the usual attention to data and visualization.

The DataJournaLIST - week6


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

CHINA AND MYANMAR

1. FRONTIER MYANMAR


The first new entry of this week is Frontier Myanmar. I think this is one of the first data story for the team, but it come out a superlative data-led reporting. The exploration of Myanmar's economic relationship with China is a longform with different digital elements. Pictures, videos and dataviz. A map analyzes the production of energy in Myanmar and how much energy would stay in the country. It's possible to scroll and see the map follow the story. But there's a lot more to analyze chinese investments and how they are related to Myanmar export growth.

VOTES AT UN

2. AL JAZEERA

Second time in the list for Al Jazeera. The team analysed 6,112 roll-call votes from the UN General Assembly from 1946 to 2018. In the piece you can explore the biggest issues facing the planet and see how they have evolved. In an interactive and colorful form!

AMAZON RAINFOREST

3. REUTERS GRAPHICS

We already talked about the Amazon Rainforest in the LIST of the week 1. Reuters Graphics is going ahead, trying to go deeper in the analysis of Bolsonaro's politics. The President is preparing to pave a road deep to the forest. Many fear it would be an ecological disaster. Reuters analyzed deforested areas within a 20 km buffer on both sides of each of the three roads in each state. 

RACIAL RIOTS

4. MALAYSIAKINI

I found this piece after a while, as you can see. But I really like the way they put togheter historical pictures and newspapers pages with maps and interactive visualization to explain what happened that day hour by hour. Malaysiakini is an award-winning independent news provider. And from now another new entry in the list!


HEALTH CRISIS

5. MÉDOR MAG

Médor is a quarterly Belgian magazine and cooperative investigative and narrative, founded in 2015. The last new entry of the week. But not the least for the use of data visualization. The United States is experiencing a serious health crisis. Painkillers with excessive prescription cause millions of addictions and thousands of deaths. Médor creates a wonderful analysis of Belgium in pain, to understand the consequences of more than a million Belgians who ate an opiate in 2017. Scroll, interact and enjoy!

The DataJournaLIST - Climate Change Edition


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

CLIMATE CHANGE

1. LA NACION


The climate emergency  will mobilize millions of people in more than 160 countries. Young people from all over the world will occupy the streets and demand from their rulers concrete and immediate actions to curb the devastating effects of the climate and species crisis suffered by our planet. La Nacion mapped all the climate events around the world.

2. REUTERS GRAPHICS

More than a third of the indians lives in water-stressed areas. An increasing population and inadequate surface water is fast depleting the country of its groundwater resources. Reuters Graphics visualized in a longform the use of groundwater by district in India. More than 100 districts used more groundwater than what was replenished by both natural and artificial processes, a measurement known as groundwater “recharge”.


2. WASHINGTON POST

Across America, climate change is already disrupting lives. US are 1.8 degrees Fahrenheit warmer than a century ago and americans are affected by it. This is the story of the Rio Grande, its farmers and growndwater.

4. FINANCIAL TIMES

It seems that sea levels are rising faster than scientists had predicted. The Financial Times team started from the Intergovernmental Panel on Climate Change and the UN climate summit in New York to analyze the meltwater from Greenland, Antarctica and glaciers and their effects to the sea levels.

5. BBC NEWS
Why are more fleeing home than ever before? This is not an article completely related to the climate change. But alongside violence, persecution and human rights violations, natural disasters are increasingly forcing people to flee. They often seek refuge to urban areas, but the world's biggest cities themselves are also at risk from rising global temperatures. Another effect of the climate change.

The DataJournaLIST - week4


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

RENEWABLE ENERGY

1. BLOOMBERG


In 2010 coal supplied nearly half of America’s power. And renewable energy? Not an option at that time. Bloomberg analyses how solar and wind energy is growing along the country.

SOUTH SUDAN

2. AL JAZEERA

In South Sudan many journalists are denied access to or even barred from reporting within the country. This is why this project is interesting: how to find data?. For this reason Al Jazeera used a mobile phone survey to gather information from those in places traditional journalism cannot reach. That data was then verified against other reporting tools, including satellite imagery, on-the-ground interviews, public records, and submitted photos.

SOUTHEAST ASIA FIRES

2. REUTERS GRAPHICS

Animated maps, circle maps, satellite images. Indonesian farmers are again burning huge swathes of forest and peatland, creating a blanket of smoke that clouds the skies over large parts of the region. Visualize fire hotspots detected in the area is a good way to understand the phenomenon and its consequences.

RUSSIAN CINEMA

4. RIA NOVOSTI

I know that the article is difficult to understand for those unfamiliar with russian. But the combined use of visualizations and illustrations is perfectly balanced in this story of the russian cinema by Ria Novosti.

NETFLIX

5. FINANCIAL TIMES

The Financial Times data team worked hard to develop this interactive news. Especially to create a "draw your own" valuation tool. With this tool you can guess how much you think Netflix is worth.

The DataJournaLIST - week3


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

SPEECHES IN BUNDESTAG

1. ZEIT ONLINE


This is not the first time I found good data stories on the Zeit Online. After 3 year of work, in 2014 the Zeit has established a senior editorial team to drive big stories, partnering with the rest of the newsroom and acting as a hub for investigations. The results are amazing. In this project the team has made all speeches in parliament since 1949 graphically analysable and published in a long-form. It's possible to explore when and which topics were debated, how language has changed and a lot more. Data visualization means also exploration and here's the best example. Scrolling and looking at the interactive visualizations is a wonderful trip.

DONALD TRUMP

2. FIVETHIRTYEIGHT

I'm sure a lot of people already seen this project of FiveThirtyEight. An updating calculation of the president's approval rating, accounting for each poll's quality, recency, sample size and partisan lean. The polls are weighted based on their methodological standards and historical accuracy. It's also interesting to compare the approval (and disapproval) rating of the actual president to the one of the past prasidents, looking at an interactive small-multiple trend line.

3. REUTERS GRAPHICS

The conflictive story of Israel and Palestine has a new chapter with Donald Trump's presidency. Reuters tryed to show it visually. Since Trump took office in 2017, the White House has taken a series of steps that have outraged the Palestinians and delighted Israel. For example in December 2017 Trump recognized Jerusalem as Israel's capital. Maps tell us all the steps toward Israel angered the Palestinians. Trump has so far not embraced the two-state solution, even if the United Nations and most nations around the world back it. Reuters shows which UN states endorse palestinian statehood and who support the two-state solution.

HOMELESS

4. LOS ANGELES TIMES

Los Angeles is considering banning homeless people from sleeping in different parts of the city. The Los Angeles Times analysed all these sites. With a huge work on maps it's possible to see the impact by neighborhood. It's important to consider that we're talking about a 15,000 homeless population and the ban is specially focused on streets and sidewalks within 500 feet of schools, parks and day-care facilities. A great piece to read and a fascinating graphic presentation.

THE GREAT FLOOD

5. THE NEW YORK TIMES

The New York Times is still on the list! Their graphic department is always full of ideas and interesting project. This week they present the story of the flooding that devastated large swaths of the Midwest and the South this year. They made it with a giant composite map. The team ooked at the flooding as a massive, interconnected disaster to take readers beyond day-to-day coverage. Using roughly 2 terabytes of satellite data to produce a single composite image, they created a tour of a very wet nation. The results is (also this time) fascinating to explore.

The DataJournaLIST - week2


WHAT'S NEW THIS WEEK IN THE WORLD OF JOURNALISM AND DATA? CHECK OUT THE WEEKLY LIST OF THE BEST ARTICLES AROUND THE WORLD!

HOT TOPIC OF THE WEEK

MASS SHOOTINGS & GUN CONTROL

1. THE WASHINGTON POST

The people who were killed came from nearly every imaginable race, religion and socioeconomic background. Their ages range from the unborn to the elderly; 191 were children and teenagers. The Washington Post has visually recostructed a list of all the victims, the weapons used and the locations of the mass shootings in United States.


2. THE NEW YORK TIMES


The National Rifle Association has significantly fewer allies in Congress than it did a decade ago. The New York Times analyses the decline and N.R.A.'s political position, that is becoming precarious, and the republican and democratic allies.



BREXIT & IRISH BORDER

3. THE GUARDIAN

The Guardian chooses to use a map to show border crossing in real time over the busiest hour of an ordinary Monday, 2 September 2019. The backstop is maybe the most controversial protocol in the Brexit withdrawal agreement. Understand how much impact could have this point is really important. In particular the impact it may have on the economy and people of the island were customs or immigration checks to be put in place at the border. We can guess the importance of this point if we consider that the Deputy Prime Minister of Ireland, Minister for Foreign Affairs and Trade, responsibility for BREXIT in Irish Government tweeted the article.

4. THE IRISH TIMES

Also The Irish Times published something about the Irish Border. If you want to know more about the fascinating history of these lands this is the link for you. The border runs for 499 km (310 mi) from Lough Foyle in the north of Ireland to Carlingford Lough in the northeast, separating the Republic of Ireland from Northern Ireland. Each mile has a lot to tell. Read and explore the border!


5. BLOOMBERG

These days were essentials for the Brexit in the UK Parliament. Bloomberg summarized the vote with graphic and hex maps. Here's how members of Parliament voted to block no-deal Brexit and a snap election. 

The Data JournaLIST - week1

HOT TOPIC OF THE WEEK

AMAZON RAINFOREST
Thousands of fires are ravaging the Amazon rainforest in Brazil - the most intense blazes for almost a decade. I'm sure you read a lot of pieces about this topic and you had many questions about the fires. Several media organizations worked on the Amazon fires, trying to collect some of the answers. Click on the orange link to read the articles.

1. THE GUARDIAN

 Amazon fires: what is happening and is there anything we can do? 
The Guardian worked on the topic to understand why people should be worried about the blazes and increased deforestation in Brazil. With data and mapping you can easily understand the scale of the problem. With an intuitive comparison beetween the forest and London. Did you know that an area of London that stretches from Hyde Park to Tower Bridge was cleared every day?



2. THE NEW YORK TIMES

  What Satellite Imagery Tells Us About the Amazon Rain Forest Fires  
Scientists studying satellite image data from the fires in the Amazon rain forest said that most of the fires are burning on agricultural land where the forest had already been cleared. The analysis on The New York Times shows month-by-month pattern of fires across the Amazon rain forest in Brazil each year since 2001. The increase in fires every August to October coincides with the season when farmers begin planting soybean and corn. Maps are very useful in this piece to tell the story of the forest.

3. BLOOMBERG

 Here’s Where the Amazon Is Burning and Why It’s Going to Get Worse 

With the use of maps and charts the Bloomberg's team explains how the rate of deforestation in the Amazon jumped 73% from 2012 to 2018, even if indigenous lands had largely been effective barriers against deforestation. Bloomberg cross-reference with data about Brazilian soy exports and beef production is one of the most interesting things of the piece.


4. BBC

 The Amazon in Brazil is on fire - how bad is it? 
Like others, BBC worked with maps and visualization to tell the story of the deforestation. But there's something more. BBC looks also at the smoke and carbon that is travelling along the Atlantic Coast. If you want to know more about the carbon monoxide emission you can read the article.



5. LA NACION

 Resumen visual de los incendios que avanzan sin control en el Amazonas 
La Nacion published a wonderful visual resume of what's happening in Brazil. From the map to the CO2 emissions with interactive viz. Here's the story from a point of view really close to Brazil.

That is all on Data

Contact Me
Milan, Italy
image