What’s the global data journalism community tweeting about this week? Our NodeXL #ddj mapping from March 4 to 10 finds a host of intriguing tools and feature releases: @FinancialTimes‘ chartmaking tool, @datavized‘s data sonification tool, and a new feature on @Microsoft‘s Excel app that converts printed tables into editable spreadsheets, plus @alice_corona on building 3D data experiences and @alyssafowers coining the term “hedgehog maps.”
Create Charts. Fast.
Last week, The Financial Times soft-launched FastCharts, a chart-maker touted as simpler-to-use than Excel or Google Sheets. The idea to create this tool for the newsroom came about when the FT realized that it took too long to create one simple chart for the web and its print equivalent.
Exciting #dataviz news!
We’ve just soft-launched a public version of the @FT’s in-house, in-browser charting tool, FastCharts™
Head to https://t.co/wpIMSZ12uL to use it, and leave any suggestions in the feedback form
Here’s a GIF showing how to make a chart in under a minute: pic.twitter.com/d9j3LYArtK
— John Burn-Murdoch (@jburnmurdoch) March 5, 2019
Make Beautiful Music With Data
Just launched: TwoTone, an open-source data sonification tool created by Datavized Technologies with the support of the Google News Initiative. TwoTone turns your data into music. It could open a new world of possibilities to make data accessible for the visually impaired. Google’s Data Editor Simon Rogers writes about the tool here.
What does the weather sound like on Mars? Listen to this sonification I made of the Mars Insight Mission Daily Weather report at Elysium Planitia. Created with https://t.co/6SRJRiaPaR #Moon2Mars #NASA #data #sonification #datavized #googlenewsinitiative https://t.co/KrzIfCk1vC pic.twitter.com/inTv85JF7a
— Debra Anderson (@debraeanderson) March 11, 2019
Building 3D Data Experiences
Data journalist Alice Corona writes a two-part article about data “physicalizations.” She highlights the participatory nature of 3D data experiences for audiences and offers several examples to inspire journalists to create their own data-driven news installations. Read Part 1 and Part 2.
Part two is here,with 4 more inspiring reasons why #journos could use #dataphys –> Great data physicalizations, and what journalists can learn from it — Part 2 https://t.co/tC2eG5hPOx • Examples by @dariorodighiero @jdfaviz @thegreeneyl @frescogamba Yvonne Jansen and more!
— Alice Corona (@alice_corona) March 7, 2019
Introducing the Hedgehog Map
Alyssa Fowers, a PhD student studying statistics, research methods and data viz at the University of Miami, just coined a term for maps using arrows to indicate change: hedgehog maps. She cites US election maps as an example, where the base of the arrows show the location of the change, the length depicts the magnitude of the change and the angle indicates the direction.
Today on Data and Dragons, I describe a elusive species of #dataviz that emerges after elections: the hedgehog map.https://t.co/tY3U4jzJit
— Alyssa Fowers (@alyssafowers) March 8, 2019
Turn Pictures of Tables into Editable Spreadsheets
Good news! Excel mobile app users will soon be able to take photos of printed data tables and convert them to fully editable tables in the app. The feature is powered by image recognition technology.
Microsoft Excel will now let you snap a picture of a spreadsheet from an iOS or Android phone and import it into a fully editable table. Very useful feature. Details here: https://t.co/NjRAe4LZ4c pic.twitter.com/qGDvBrPIlT
— Tom Warren (@tomwarren) March 1, 2019
NICAR19 Data Blitz
The annual NICAR gathering is the mother of all data journalism conferences. Sponsored by our pals at Investigative Reporters and Editors, the annual event wrapped last weekend after four days of sharing datasets, GitHub repos, tools and knowledge. Check it out: There’s lots to digest in Sharon Machlis’s collection of tipsheets and IRE’s collection of session materials from the conference.
IT's DATA BLITZ time! #NICAR19
The Costs of U.S. Wildfires by @esagara https://t.co/7UVJYXHPyw
A collection of daily situation reports on large federal wildfire. Locations, damages, estimated costs, vegetation destroyed etc #NICAR19 #ddj
— Daniele Palumbo (@Danict89) March 8, 2019
Pitch the Next #PanamaPapers
The International Consortium of Investigative Journalists is known for its massive cross-border investigations by large collaborative teams of some of the best investigative journalists in the world. Now you can help: ICIJ is reaching out to the public for more world-changing stories. Send in your pitches!
Journalist amigos: This is your semi-annual reminder that @ICIJorg is open to your great story ideas. Pitch to us! The next 8,321 tweets explain why you should.https://t.co/zdGDoUraGo
— Ben Hallman (@ben_hallman) March 7, 2019
Google Data Studio
Are you late to the Google Data Studio party? In January, the Data Studio team released a number of new features including interactive charts, search filters and the ability to embed external content.
Using Google Data Studio? -> Exploring the rich interactivity in Data Studio (that was just released in January). Includes interactive charts, search filters, and embedding external content https://t.co/ikFv4iRr0d pic.twitter.com/vKg1eNA9D9
— Glenn Gabe (@glenngabe) January 30, 2019
When Headlines Contradict Data
Alberto Cairo, Knight Chair in Visual Journalism at the University of Miami, calls out The New York Times for publishing a headline on migration records in the United States that was misleading and contradicted its own data.
I just wrote a blog post about that terrible NYT headline and the data and charts that contradict it https://t.co/1fR1SGAGou #dataviz #infographics #ddj News organizations need to be careful with headlines; very often is the only thing people see and read pic.twitter.com/n7VahNtQ1t
— Alberto Cairo (@albertocairo) March 6, 2019
Investigating Data Using R and Spark
SRF Data reporter Timo Grossenbacher writes a detailed breakdown of how he investigated a 900 GB+ dataset of Swiss password leaks. He describes his process from pre-processing to filtering and searching using R and Spark, and finally his analysis. Some advice and a funny cat GIF are included.
How I investigated the 900GB+ #Collection1-5 password leaks – using #RStats and Spark. https://t.co/Egv7JDuERH #ddj #DataScience #BigData pic.twitter.com/jF5SRE7Tt1
— Timo Grossenbacher (@grssnbchr) March 8, 2019
Thanks, once again, to Marc Smith of Connected Action for gathering the links and graphing them.
Eunice Au is GIJN’s program coordinator. Previously, she was a Malaysia correspondent for Singapore’s The Straits Times, and a journalist at the New Straits Times. She has also written for The Sun, Malaysian Today and Madam Chair.