Data Journalism
Data journalism: Resources to help reporters get started collecting and analyzing data
Helsingin Sanomat provides guidelines to journalists on use of open data
Data Driven Journalism: The Series Begins…
25 great links for data lovin’ journalists
John Keefe’s blog on being a protojournohacker
Top 10 things for getting started in data journalism
Data Journalism or Computer Assisted Reporting (CAR)
Tools, Slides and Links from NICAR12
Get Data
Data Resources
List of dates when council and police authority accounts are open to view
Zanran (PDF/spreadsheet/table search engine)
Scraping
ScraperWiki CIJ workshop in blog form
Dollars for Docs data collection guide
Scraping guide: dates and times
ScraperWiki tutorial screencast for non-programmers
Making data more usable with ScraperWiki
Open Data
How The Open Data Movement Could Benefit From Using A Marketing Approach
UK Government Open Data Pledges
API
Google Charts – See Getting Started With Charts and Interactive Charts. There are also samples in the Google Visualization API Gallery.
Adding geographical information to a spreadsheet based on postcodes – Google Refine and APIs
How to grab useful political data with the They Work For You API
Beginner’s guide for journalists who want to understand API documentation
PDF Conversions
http://www.guardian.co.uk/technology/askjack/2010/feb/15/convert-pdf-to-excel?CMP=twt_gu
http://datadrivenjournalism.net/resources/getting_text_out_of_an_image_only_pdf2
Yahoo Pipes
Learn How to Build a Pipe in Just a Few Minutes on Yahoo!
Discovering Co-location Communities – Twitter Maps of Tweets Near Wherever…
Clean and Analyse Data
Excel
Manual on Excel for data journalists
Visualizing Toronto’s water usage: a tutorial
SQL
A Gentle Introduction to SQL Using SQLite
Introducing SQL for Lightweight Data Manipulation
Structured Query Language (SQL): an introduction
Google Refine and Data Wrangling
How journalists can use Google Refine to clean ‘dirty’ data sets
http://googlerefine.blogspot.com/
Cleaning data with Google Refine
Combining data with Google Refine
Geocoding
How to: convert easting/northing into lat/long for an interactive map
Google Docs
How to collaborate (or crowdsource) by combining Delicious and Google Docs
Asking questions of a webpage – and finding out when those answers change
R
Try R for Statistics: First Steps (PDF) by Peter Aldhous, Hands-on R, a step-by-step tutorial (PDF) by Jacob Fenton, and the project’s own An Introduction to R.
The R Statistics blog has a number of visualization samples.
Power Tools for Aspiring Data Journalists: Funnel Plots in R
Generating Twitter Wordclouds in R (Prompted by an Open Learning Blogpost)
Visualising Twitter User Timeline Activity in R
Network Analysis
Download this detailed free NodeXL tutorial (PDF) or these basic step-by-step instructions on analyzing your own Facebook social network (PDF).
Following the money: making networks visible with HTML5
Make Data Pretty
Mapping
Try this OpenLayers Simple Example. A good sample is Ushahidi’s Haiti map.
There are other JavaScript libraries for overlaying information on maps, such as Polymaps. And there are a number of other mapping platforms, such as Google Maps, which offers numerous mapping APIs; Yahoo Maps Web Services, with its own APIs; the Bing Maps platform and APIs; and GeoCommons.
How To Build an Interactive Map with Open-Source Tools
Making maps, part 1: Less interactivity
Augmented Reality
Processing
Tutorial: Processing, Javascript, and Data Visualization
Fusion Tables
What options exist for displaying icons, lines and polygon colors on the map?
How to map in Fusion Tables: a basic tutorial
How to combine multiple Fusion Tables into one map
Answering some FAQs about Fusion Tables
Tableau
Making Table Calculations work in Tableau
Show Me! – When less is definitely more
Preprocess shapefile for Tableau Tutorial Video
Hey! Your Tableau Public Viz is Ugly *and* Confusing
App Makers
Timelines
TimelineSetter: A New Way to Display Timelines on the Web
Coding
Ruby
Python
CSS
Javascript
Other
Semantic Search
If Then Commands
