Summing and grouping in SQLite
The second session in the SQLite workshop will build up your SQL muscles, adding some common tasks that journalists need every day: getting counts and sums, munging the text of your data to make it more useful and structuring your data in a way that will make you more confident in the conclusions you reach.
This is the second of three SQL sessions using SQLite, but attendance at the earlier session is not required.
Troy leads a distributed team of data analysts and developers working in newsrooms across The Associated Press to tell stories using data. His current obsession is data-driven newsroom collaborations. Ask him about SunshineHub or AP's data distros. Troy is based in New Orleans and, like most New Orleanians, probably talks about it too much.
No tipsheets have yet been uploaded for this event.