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.
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 is a 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 2014 re-election campaign?
Understanding data type is essential. Some operations only work on specific types.
Dates can be used to group events in time frames: Per hour, day, month, quarter..
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.
Use joins and the Consumer Price Index to compare dollar amounts from different years.