How the Baltimore Sun used flawed FBI crime statistics to scrutinize the handling of sexual assault cases by the Baltimore Police.
These links contain material that I refer to in class but in self-contained article/aggregate/tutorial form.
How the Baltimore Sun used flawed FBI crime statistics to scrutinize the handling of sexual assault cases by the Baltimore Police.
Pivot tables are an effective tool for quickly summarizing the facts from a mass of records
A walkthrough of basic spreadsheet and pivot table usage (Part 1 of 3) We have a lot of ways to easily create beautiful, elaborate visualizations. But let’s see what we can do when we prioritize the story of the data over its visual presentation.
A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)
A walkthrough of using Pivot Tables to summarize earthquake data across two dimensions, allowing for even more insightful histograms (Part 3 of 3)
Use pivot tables to summarize San Francisco crime data
Use pivot tables to compare year-over-year crime data
Pick 5 data stories from a wide selection, write five short summaries
More pivot tables:
Today's dataset: San Francisco police incidents for August 2014 and 2015
Download the data here: usgs-north-america-quakes.csv
Let's try to do better than this map:
A list of public and easy-to-get (but not easy to analyze) datasets. They are all too big for easy spreadsheet work, but that’s why we’ll be learning about databases…