Data Delver: Paul Monies, The Oklahoman

April 11th, 2010

In journalism, we talk a lot about the concept of the "one-man band." The idea often refers to multi-platform journalism -- it means being able to deliver a story in print, video, audio or online format. You must be able to do it all, and do it all well. But in the CAR world, plenty of data teams remain a one-man band operation, but in a different sense Read More...

Self-teaching data and programming skills

March 25th, 2010

So, you think data journalism and programming are some valuable skills you'd like to learn.  Unfortunately, your school doesn't offer this as a track, or maybe you're not even in school anymore.  You know people will help you, and you think it all seems cool, but it can be difficult knowing just where to start Read More...

How to “Group By” in Excel

January 20th, 2010

Random time-saving Excel tip.  Want to condense a long column to only display unique entries?  Go to the Data menu, select Filter and Advanced Filter.  Voila, a check box labeled "Unique records only".  Don't know why I never noticed this before. Or, you know, you could use Group By in SQL.  But no need to import databases just for filtering.