If you have decided to start doing Data Journalism, here is an array of ideas, tools and resources useful for helping you to succeed. Recently, I had the opportunity to share them with the students of the Faculty of Communication in Ankara University, Turkey, and hope this tool box can help you, and motivate you, to improve the quality of the journalism you are practicing.
Using Excel to do precision journalism (tutorial and data examples to download)
Journalism in the age of data (Video report, Stanford University)
SQL (Programming language designed for managing data)
R (Statistical software)
Berkeley School of Journalism (maps, interactive animation, audio edition)
Cleaning data and analysis
Import.io (Scrapping/data extraction)
Open Refine (Cleaning data; transforming it from one format into another)
Tabula (liberating data tables locked inside PDF files)
Data Wrangler (Cleaning data)
Document cloud (Analysis)
Books and manuals
Best practices in examining the data
The New Precision Journalism by Philip Meyer.
Post series about Ethics in data journalism by http://onlinejournalismblog.com :
- Privacy, user data, collaboration and the clash of codes
- Protection of sources, leaks and war
- Automation, feeds, and a world without gatekeepers
- Accuracy in visual journalism & Be vigilant about presenting data accurately.
A Mathematician Reads the Newspaper by John Allen Paulos
Doing Data Science: Straight Talk from the Frontline by Cathy O’Neil, Rachel Schutt