Process of Data Journalism
Inverted Pyramid of Data Journalism

Finding data sets
Finding data sources
Tips and Tools for Smarter Searching
Advanced Search tutorial (Google News Labs)
Interviewing data: Questions to ask of your data
Intro to FOIA
Everything you need to know about FOIA (Washington Post)
Don’t Be Duped by Data: 10 Things to Question in Your Data Set

Data File Types
Common Data File Types

Excel and Spreadsheets
How to Import Excel into Google Sheets
Excel Tips – Part 1: Format, sort, filter, total
Excel Tips – Part 2: Math formulas and functions
Interviewing data with Excel
Intro to 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
Tips and resources for Journalists working with math and statistics (Journalist’s Resource)

Common Data File Types
Intro to scraping using Google Sheets
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

Visualization 101 (Visage + Hubspot)
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
Storyline JS

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

Putting It All Together
How to Make Dope Shit – Part 1: Working with Data (The Pudding)
How to Make Dope Shit – Part 2: Design (The Pudding)

Leave a Reply

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

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

Google+ photo

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

Connecting to %s