Week 13: Cleaning data with Open Refine
As you’ve seen in the last two weeks, most of the work involved in data journalism involves getting data into a form you can use, either in Excel or in SQL o...
Posts by Category
weeks
Week 11: Finishing up with SQL
This week, we’ll be switching to a more robust platform that you can use for your database projects.
Week 10: More SQL
This week, we’ll be switching to a more robust platform that you can use for your database projects.
Week 9: Intro to SQL
Structured Query Language, or SQL, is commonly used to hold and query large, structured datasets. Instead of a single worksheet, a relational database system...
Classes 13 & 14:
NOTE Be sure to sign up for an account with Tableau, either the public version or the student Desktop version. If you plan to use your own computer for the w...
announcements
Remote classes
Beginning Tuesday, March 17, we’ll transition to remote classes via Zoom. I’ll be sending out more details on how this will work over the weekend, but for no...
Class zero
Don’t forget to check for your reading and prep before the first class.
future
Week 7: Public records sprint
Most of the week is a public records sprint, but we’ll also cover getting data out of pdf documents