Keep it subtle, stupid: Differentiating data values in visualizations

January 25th, 2010

I’m not anything resembling a visual genius, but I like to believe I have enough of an eye that I can tell what works and what doesn’t.  The reason Tufte’s books are so helpful is that they tell me why something works, and give me rules so I know what I can and can’t do.  That’s why I have great appreciation for the Tufte chapter of the week: “The Smallest Effective Difference” in my ongoing exploration of “Visual Explanations.”  (I’m also reading his other books on the side, and more on that in the coming week.) (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.

Changes in the numbers of students majoring in programming and social sciences

January 19th, 2010

What is a traditional path to programming nowadays? It's a question I've been thinking about a lot, esp. in the realm of the journalist-programmer. So many people from the older school of journalism came through using databases as tools to help with reporting, not because they took a class in it. That's certainly encouraging for someone like me Read More...

Committing fact errors in visualizations

January 18th, 2010

At Medill, there's a wonderful tradition called the "Medill F."  Make a factual error of any sort, and you fail the assignment.  The sadistic part of me likes it -- a journalist's job is to tell the truth.  If you miss the mark, you've failed the public, and failed at your job for the day. Harsh but true Read More...

Collaborating with computers to parse “big data”

January 18th, 2010

Picture it: You've been given a new story assignment, and you have to leave for the interview in five minutes. You've got to have enough background to ask the right questions, but there's no time to do research.  Somehow pulling that all-nighter on an English term paper in college seems like a cakewalk Read More...

Data Delver: Ted Mellnik, Charlotte Observer database editor

January 12th, 2010

Computer-assisted reporting is important because of its potential for reporting and analysis.  Visualization is important to present the information to readers. They both fall under the responsibilities of Ted Mellnik, database editor at the Charlotte Observer. His passion for data is as clear from a conversation with him as it is from his work Read More...

Why technology matters: It’s about reporting

January 11th, 2010

"Figure out what you want to do, and get really good at it."  That's been the overarching advice I've heard in the past few weeks, as I seek to understand where I might fit in the "new media" world.  It all sounds fine, although the more I meet interesting people who've been looking at data analysis and web presentation for a long time, the more it becomes apparent that getting "really good at it" is a lifelong endeavor Read More...

Importance of combining data analysis with context (reflections on readings from week two)

January 11th, 2010

"Visual and Statistical Thinking: Displays of Evidence for Making Decisions," Edward Tufte, Visual Explanations This chapter gave practical examples of something I've been saying from almost the first day of my data analysis journey -- that it's absolutely fundamental that the decisions behind the analysis are shown to the reader/user Read More...

A list of 40 CAR-friendly news organizations
(my adventures in parsing the IRE directory)

January 11th, 2010

Sure, data-driven reporting investigations sound good, but how does an aspiring journalist know which organizations are most supportive of that kind of work? I don't believe there's one all-encompassing way to tell, but I would argue that one measure might be the number of Investigative Reporters and Editors-card-carrying members in a news organization Read More...

Which states have been hit hardest by unemployment in the last decade?

January 10th, 2010

For the past week, we've been hearing a lot of media coverage focusing on issues both encouraging and discouraging, looking with excitement at the beginning of a new decade. But what captured my attention most recently was the release of unemployment figures from the end of 2009. If you look at the glass as half full, it's got to go up from here sometime soon, and if you look it as half empty, we're not starting in a strong economic place Read More...