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 visualize your first table.
Work with international CO2 emission data and learn how to find the largest and smallest values in your data.
Learn when to use different types of charts, and how to transpose to prepare data for charting.
Filtering data is a common, yet powerful analysis technique. Learn how to filter by condition and by value to explore your data.
Group rows together in order to summarize large amounts of data quickly.
How much money came from out of state in New York governor Andrew Cuomo’s 2014 re-election campaign?
Different columns have different types: text, numbers, dates, locations, and so on. Some operations only work on specific types.
Advanced grouping techniques to summarize data in different ways.
Learn the difference between “long” and “wide” table formats and how to convert between them.
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.
Learn how to join tables and use the Consumer Price Index to compare dollar amounts from different years.