Secrets from the Data Cave: March 2014
Welcome to CRCs monthly series of articles on all things techie: Secrets from the Data Cave! (For those who dont know, the title references our room fondly referred to as the bat cave where data staff can geek out in an isolated setting.) Here well be offering you a fascinating sneak peek into the cave, with the latest updates & tips on what were implementing here at CRC!
March 2014: I Am Going to S P A C E
Earlier this month, while looking for some new and interesting data visualizations, I came across this nifty website that gives a spatial representation of the distance between planets in our solar system1. After thoroughly enjoying the learning experience (along with the witty interjections, as I patiently scrolled though the empty space signifying millions of miles), I visited the creators blog page, where he explained his motivation to undertake this project:
I kept trying to describe the distance using metaphors like if the earth was the size of a golf ball, then Mars would be across the soccer field etc., but I realized I didnt really know much about these distances, besides the fact that they were really large and hard to understand. Pictures in books, planetarium models, even telescopes are pretty misleading when it comes to judging just how big the universe can be. **Are we doing ourselves a disservice by ignoring all the emptiness? **2, (emphasis mine)
It got me thinking: we put a premium on space use in data visualization when it comes to things like BI dashboards, infographics, or even paper reports. We typically want our data spread across as few pages as possible, so that we can process related information simply by shifting our gaze, as opposed to shuffling/scrolling through multiple pages. We might also want to see the same data represented as numbers in a table and as a chart or graph, so it makes sense to try and squeeze multiple representations of the same data onto one page.
But the question remains: as convenient as it is to see everything at once without scrolling across a screen, what do we lose in impact when we choose to condense large datasets into small visual representations? Even when we keep those representations relatively true to scale, how much is lost?
Take, as another example, epidemiological data on different countries AIDS-related deaths in 2001 and 2011 (UNAIDS3). This dataset has been condensed to include a few example countries:
The graph generally conveys the message that AIDS-related deaths in Kenya have dropped substantially in the last 10 years, while the number of such deaths remained about the same in the USA and United Kingdom, and that Kenya has many more deaths, overall, than the other two countries. But its still very difficult to wrap ones mind around the magnitude of so many deaths just from the chart above.
For that reason, I created an alternative visualization of Kenyas 130,000 estimated AIDS deaths in 2001 that, like the outer space example, involves a lot of scrolling. You can find it as a PDF here.
Now, I live in the real world. I get that we all need to consider limitations on space when creating data visualizations, especially when they will be printed. (Save some trees!) I also recognize that comparing sizes using the scrolling model is difficult because we can only hold so much precise measurement in our memory once it is out of our line of sight. This is why I only included data for one country and one year, rather than comparing all three in one visualization. But, my point remains that condensing as a visualization strategy does not always make comprehending data easier, especially when very large numbers are involved. There is something to be said for a visual representation of data that takes up a lot of space, when the data it represents is larger than life. And for that reason, going forward I plan to space my data visualizations out as much as I can, whenever possible and applicable.
Do any of our readers have any input on this topic? Leave a comment and let us know!
- Do We Really Need to Write (and Read) another Lengthy Evaluation Report?
- Is Your Data System Free….Like a Puppy?
- Should You Break Up with Your Spreadsheet? Maybe…..maybe not
- Our Impact Blueprint Can Save You Time, Money, and Heartache on Your Next Data Project
- Alternatives to Microsoft Access Databases
- Give Us Your Tired
- Never Endure Another Data Migration
- Data Visualization Design Tip: Using a Style Guide
- Understanding Data Integration
- Why Nonprofits Fail to Make the Most of Their Donors
- Tools to Make Data Cleaning Easier
- Evaluating Accessibility and Inclusion
- 5 Mistakes That Kill Survey Data (and How to Avoid Them)
- Ask These 5 Questions Before Changing Databases
- What is Sketchnoting and Why Should You Try It?
- Data Cleaning in Excel 101, Part 8: Final Summary & Data Cleaning Guide
- Data Cleaning in Excel 101, Part 7: Managing Blank Cells
- Data Cleaning in Excel 101, Part 6: How to Remove Duplicates
- Data Cleaning in Excel 101, Part 5: Numbers That Don't Act Like Numbers and Leading Zeros
- Data Cleaning in Excel 101, Part 4: More Uses for Flash Fill
- Business Operations
- Crc Team
- Customer Loyalty
- Customer Satisfaction Research
- Data Management And Databases
- New Album
- Technology And Customer Service