Data Visualization 101 for Social Change

This was blog was re-posted with permission from Emerging Practitioners in Philanthropy.  

“One page, that’s all you get,” I was told the first time I presented to the board. How is that possible, I thought? I had been running due diligence on this project for months, collecting several hundred pages of budget and proposal information with multiple rounds of revisions. Now I understand the one page limit. I was only working on one small grant out of hundreds that the board would debate – and that wasn’t even considering the documentation the board had to digest about larger strategic planning and operational issues.

The challenge of information overload is not unique to foundation boards. Non-profit staff also must present large volumes of information in a way that is quickly understood. At RFP time, foundation staff plough through and rank stacks of proposals. After a long day, those proposals begin to look the same and the non-profits that stand-out are those who make results jump to the reader’s attention.

But how can staff condense reams of paper and hours of research for upper-level decision makers? Data visualization is one tool that I have found helpful.

Data visualization represents complex data and statistics in informational graphics (“infographics”). Infographics are like the textbook charts and diagrams we all grew up with, pushed further. They use an array of new, eye-catching approaches that make data understandable at a glance.

One of my favorite infographics simplifies the complex relationship between different styles of beer: http://seekshreyas.com/beerviz/

Getting Started: Here are some basic starter tips and resources:

1. Figure out the message in your data.
2. Say it, and show it – Have a six to eight word “message” at the top of each graph.
3. Reduce the graph clutter – That means gridlines and everything else you can remove.
4. No default chart colors or 3D – default colors kill a customized look, 3-D distorts proportions.
5. Only one or two colors – Keep it simple with one color using a second only to emphasize a bar or line that supports your message.

 

My colleague, Ann Emery, showed a great example from a Canadian advertising campaign that illustrates these principles.

The reasoning behind these five tips will become clear as you read through these recommended resources and start making your own data visualizations:

• Cole Nussbaumer (formerly of google) – helpful site for those trying to use data in presentations and communications.
• Stephanie Evergreen and Ann Emery both have great tutorials on making excel visualizations.
• John Schwabish – great for the more advanced tools and policy related visualizations.
• Edward Tufte is consider a pioneer of data visualization and this book started it all.

Now you have all you need to ensure your work gets noticed in this world of 1000 word limits, elevator pitches, and time-critical decisions. 

______________________________________________

The Foundation Center collects and continuously updates data on philanthropy into searchable databases and visualizations for use by the field. These visualizations include Foundation Stats, an intuitive web-based platform that can be used by anyone to generate thousands of custom tables and charts on the U.S. foundation community, as well as custom web portals for funders on a variety of issues including black male achievement, and global water access, sanitation, and hygiene. These data visualization resources provide information on trends in the field, inform decision making at social sector organizations, and champion greater transparency in philanthropy. Foundation Maps, the Foundation Center’s new data visualization platform for philanthropy, will be launched later this year.