Resources

Finding data sets
Finding data sources
10 Tips for Smarter Google Searching
Interviewing data: Questions to ask of your data
Don’t Be Duped by Data: 10 Things to Question in Your Data Set

Excel and Spreadsheets
Excel Tips – Part 1: Format, sort, filter, total
Excel Tips – Part 2: Math formulas and functions
Interviewing data with Excel
Making pivot tables in Excel
Pivot Table/Reporting Exercise

Newsroom Math
Basic newsroom math and statistics
Statistics Every Writer Should Know
Newsroom Math crib sheet (pdf)
Tips for Writing with Numbers

Scraping
Common Data File Types
Intro to scraping
How to Scrape PDF Table Using Tabula

Scraping Tools
Import.io
OutWit Hub
Chrome extension Scraper
Scraperwiki
Tabula (scraping pdfs)
If This Then That

Cleaning (Beginner)
Intro to Cleaning Data
4 common ways to clean data in Excel
10 more ways to clean your data in Excel
Intro to cleaning data (UC Berkeley School of Journalism)

Cleaning (Advanced)
Open Refine
Open Refine tutorials

Infographics
Key concepts of data visualization
Charts and Graph Thought-Starter

Chart, Graph and Infographic Tools
Intro to out-of-box Infographic Makers
Google Sheets
Google charts – this is a more robust version of Google Sheets (See chart gallery)
Infogr.am
Silk
Plot.ly
Tableau Public

Maps (Beginner to Intermediate)
Making Maps with Google My Maps and Fusion Tables
StoryMap

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s