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

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

Scraping Tools
OutWit Hub
Chrome extension Scraper
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

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)
Tableau Public

Maps (Beginner to Intermediate)
Making Maps with Google My Maps and Fusion Tables
Google Fusion Table tutorial (Google News Lab)


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your 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