This entry level course will teach you how to answer questions with data in a transparent and reproducible manner, without the need to code.
You will learn how to filter, group, create charts, fix common data formatting issues, and combine different data sets. You’ll also learn about useful calculations like per capita rates, percentage change, and adjusting for inflation.
Along the way, you'll work with data that journalists commonly use, including campaign finance, crime, housing, and environmental data.
Learn about the first questions you should ask your data before starting your analysis, and create your first chart.
Finding the largest CO2 producers
Work with international CO2 emission data and learn how to find the largest and smallest values in your data.
Column and line charts
Learn when to use different types of charts, and how to transpose to prepare data for charting.
Filtering data about public housing
Filtering is a powerful analysis technique. Learn how to filter by condition and by value to explore your data.
Grouping rows (pivot tables)
Group rows together in order to summarize large amounts of data quickly.
Cleaning and analyzing campaign finance data
How much money came from out of state in New York governor 2014 re-election campaign?
Introduction to data types
Understanding data type is essential. Some operations only work on specific types.
Grouping by dates
Dates can be used to group events in time frames: Per hour, day, month, quarter..
Long and wide format
Learn the difference between “long” and “wide” table formats and how to convert between them.
Calculating per capita crime rates in the U.S.
Many numbers are best interpreted by comparing them to the overall population, giving a per-person rate.
Learn three common types of comparisons and how to calculate them: difference, ratio, and percentage change.
Joining tables to adjust teacher salaries for inflation
Use joins and the Consumer Price Index to compare dollar amounts from different years.