The Pies That Bind

Rather than provide you with a tip, I thought I’d start this holiday week by offering you a little hope instead. It’s pie season, and folks are searching for pie recipes on Pinterest. According to this Food & Wine article, Pinterest analyzed recent internal search data to discover the most common pie recipe search terms in each state. I took that data and mapped it. As you can see below, pie preferences do not appear to fall along regional, ideological, or even agricultural lines. Minnesotans love lemon pies, and Floridians love pumpkin pie, although I’m guessing that more lemons are grown in Florida and pumpkins in Minnesota. Some states were idiosyncratic in their searches. Hello West Virginians who love no-bake peanut butter pies and Kentuckians who love pies made with cushaws, a type of squash I’d never heard of. But most states shared pie interests with other states. So this Thanksgiving, let’s be thankful for our shared love of pie. Scroll around on the vizes below and Happy Thanksgiving!


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Ideas You Should Steal From This Viz (Installment 5)

Today I offer up yet another steal-worthy viz that I came across in the Tableau Public Gallery. Take a look:

Source: Vignesh Suresh on Tableau Public

Source: Vignesh Suresh on Tableau Public

The goal is to highlight the mismatch between the percentage of websites using a language and the share of the world’s population speaking that language. As we can see, there’s a mismatch for all languages except Polish. Using partial shapes for each of the two metrics works so well. It’s easy to see where there is more or less of a mismatch.

Creating such a chart in Tableau involves some varsity-level skills including the trigonometric functions of sine and cosine. But if you are just as happy with diamonds as circles, you can easily steal the basic idea for this chart and create a much simpler chart in Tableau. The example below compares the percent of residents in a community in need of a particular service and the percent of program slots providing that service. Want to know how I did it? Check out these instructions which assume basic knowledge of Tableau.

 

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Ideas You Should Steal From This Viz (Installment 4)

“Every artist gets asked the question: ‘Where do you get your ideas?’ The honest artist answers, ‘I steal them.’ . . . What a good artist understands is that nothing comes from nowhere. All creative work builds on what came before.” —Austin Kleon in Steal Like An Artist.

Today I offer up another steal-worthy interactive viz that I came across in the Tableau Public Gallery. Scroll down for ideas to steal from this viz.


Source: Ethan Lang on Tableau Public


Here’s what I suggest you steal from this viz:

  • Side-by-side comparisons. It’s simple to compare states to one another since they are arrayed alongside each other.

  • Good news/bad news colors. The red/blue color coding makes it easy to discern states with decreased rates of homelessness from those with increased rates both in the national map and in the individual state charts.

  • Easy look up. If you want to dig into one state’s data, you can select it on the map and get more detail on the charts in the upper left hand panel.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Easily Visualize Where Your Funds Are Coming From and Going

Here’s a helpful, easy, and even fun way to show where your organization’s money is coming from and where it’s going. It’s called a Sankey diagram. Creating a Sankey diagram with data viz tools that don’t have an express Sankey option (like Tableau) can be daunting. However, there are various websites that allow you to create them quite easily, including Flourish, which is where I created the diagram below for free. Give it a go by scrolling over the chart and using the filter.

I started by selecting a Sankey diagram template. Then I simply replaced the data in the template with my own data, which included three columns: funding source, program, and value. Flourish provides various options to customize the look of the diagram (font, color, etc.) And it gives you an embed code so that you can share it on your website.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


More Fun Chart Hacks in Canva

I bring you more chart hacks in Canva!

Canva has a number of simple chart designs that you can adapt to your needs. After starting a design in Canva, click on “Elements” and then type in “chart” in the search window to see the chart options shown in the image to the right. Each allows you to customize the chart by entering in a few data points.

HERE are some ways that I have shared in the past to use other options in Canva to hack out some fun charts. And below, you’ll find a few more ideas.

Chart Hacks

Start a design in Canva by clicking on the “Create A Design” button (upper right corner of screen), selecting a size (such as presentation), and then try one of my hacks.

HACK 1: Place a chart in a landscape: For this bar chart hack, find a landscape by searching in “Elements” (on left side of screen). Landscapes with large, cloudless skies work best. Drag the image onto a page and size it as you like. With the image selected, click on “Edit Image” in the upper left corner of the design area and then use the Background Remover tool to remove the sky. Now create a chart using the chart tools (see above). With the chart selected, click on “Position” in the the upper right corner of the design area and select “Backward” to put the chart sligtly behind the landscape image. (See how the bottoms of the bars in the image below are behind the hills?) Finally, find a sky image by searching in “Background” (on left side of screen) and add it to the design.

HACK 2: Show change over time in a chart “notebook.” For this chart, I created a series of donut charts using the chart tools (see above). Then I found a notebook graphic in “Elements.” I made several copies of the graphic and added the charts and labels to each page of the notebook.

HACK 3: Use number frames to label a key data point. For this chart, I created a line graph using the chart tools (see above). Then I searched for “number frames” in “Elements.” I added the relevant numbers to label the key data point on the graph and then dragged and dropped photos into the the number frames. Note that you can upload your own photos to Canva or use photos from their vast library of free photos in “Elements.”

HACK 4: Use videos to label a key data point. For something like the chart shown below, create a line graph using the chart tools (see above). Then type in “speech bubble” in the “Elements” search window. Limit the results to only photos by selecting the “Photos” option below the search window. Drag a speech bubble onto the design (and pointing to the key data point) and, with the speech bubble selected, click on “Edit Image” in the upper left corner of the design area and then use the “Shadows” tool to add a shadow to the speech bubble image. Now drag a video to the design and size it to fit inside the speech bubble. Note that you can upload your own videos to Canva or use videos from their vast library in “Elements.”


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Mock Up Your Dashboards (Easily)

When I’m starting a new dashboard, I usually make some sketches to help me think about what charts to include, how I’m going to lay it out, how the pages are going to relate to each other, etc. The problem is that my sketches aren’t so good. I end up scratching out a lot and then not being able to interpret it later. Recently, I started using Canva whiteboards for my mock-ups. This free tool has a bunch of features that I like:

  • Large virtual “canvases” with the ability to zoom in on particular items or zoom way out to see the whole thing.

  • Various whiteboard templates which can easily be adapted to data dashboard design or just start with a blank board.

  • Virtual post-it notes, lines, arrows, circles and other elements to annotate the design.

  • Lots of free chart images to use as placeholders.

  • The upload feature which allows you to bring in images of dashboards you might want to riff on.

  • The ability to share and collaborate with others on a design.

Check out this mock-up I created which includes design ideas for various pages of a data dashboard.

CYDI Mock Up by Amelia Kohm World!


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Viz Makeover: The Clustered Bar Chart

I rarely find clustered bar charts to be enlightening. Take this one I recently came across in an article about Chicago’s Auburn Gresham neighborhood. Take about 5 seconds and see what you extract from it. Then scroll down.

My guess is that you didn’t extract much. By the time you’ve read the title and figured out which colors relate to which geographic areas, your 5 seconds are up. Below is my makeover. Take another 5 seconds to review it and then scroll down.

I hope you at least got this from your 5-second review: Auburn-Gresham’s residents were much less likely to have a college degree than residents of the city/metro area in general. Here’s what I did:

  • Aggregated the groups into just two larger groups: those with and without college degrees. And I distinguished the groups with labels and colors. What makes a clustered bar chart confusing is the requirement to review multiple groups and compare the bars within each one of them.

  • Retained the subgroups but de-emphasized them so that they do not distract the viewer from the larger story. Each subgroup is represented by a shade of orange or blue and the exact percent of residents in each group is available on demand by scrolling over the bar segments.

  • Converted to a diverging bar chart to allow the viewer to more easily compare the size of the college and no-college groups.

  • Changed the title to a question to clarify what the viewer can learn from the chart.


To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Pop Quiz: Guess What This Chart Shows

Go ahead and make a guess from the options below. Then scroll down to see how your response compares with others’ and what the answer is!

Keep scrolling!

The answer: The decline in child poverty in the U.S.


As recently reported in The New York Times, “the sharp retreat of child poverty represents major progress and has drawn surprisingly little notice, even among policy experts.” Read the article (and view the detailed line chart) to learn more about the role of government aid in lifting children and families out of poverty.

I share this chart with you—in this way—for a couple of reasons:

1) It’s an engagement strategy you can use. Rather than present a list of stats to your audience, you can engage them in your data by first quizzing them on an interesting, fun, or counterintuitive finding from your data.

2) Bad new bias. Bad news is more likely to be reported than good news, possibly because bad news sells, according to this article citing various research. Perhaps because of that bias, we may be more likely to assume a chart is telling a negative story. This chart is a reminder of the importance of taking a broader view to gain a more balanced understanding of an issue.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Don't Measure Impact . . . Wait, What?

Ghost of Christmas Yet To Come in The Chrismas Carol by Charles Dickens, Illustration by J. Leech, Source: Flickr

Most organizations should not waste time and money on impact evaluations. Measuring impact is difficult and expensive. It’s difficult because you need a good counterfactual. A counterfactual is what Dickens’s Ghost of Christmas Yet to Come shows Ebenezer Scrooge: what would happen if you did not change anything. The impact of an intervention or program is the difference between what happened and what would have happened without the intervention. Since, in the real world, you can’t observe the same group of beneficiaries with and without the intervention (as we do when we watch The Christmas Carol), you need a good proxy for the would-have-been condition. The best proxy is a group of potential beneficiaries that were randomly selected from a larger group of potential beneficiaries. These folks do not get the intervention. Then you can compare those who did and did not receive the intervention over time to estimate the impact of the intervention. This is called a randomized control trial or RCT.

Of course, withholding an intervention from potential beneficiaries can be a difficult and morally-questionable pursuit. And tracking a large group of beneficiaries and non-beneficiaries over time is expensive. This usually requires a team of skilled data collectors and analysts. Non-randomly-selected comparison groups are not nearly as good because they may differ from the intervention group in known or unknown ways. So it’s difficult to determine if the outcomes observed are due to the intervention itself or to pre-existing biases or characteristics. This costly and challenging process is further complicated by the need to start with a well-established intervention, one that has already worked out the kinks.

Due to the many challenges of measuring impact, most organizations should not waste time and money on impact evaluations. Instead, they should consider interventions that already have a strong research base, ideally because they have been rigorously tested with RCTs. (Check out: Where to Search for Evidence of Effective Programs.)

In a Stanford Social Innovation Review article, Mary Kay Gugerty and Dean Karlan suggest that, before beginning a new program, organizations ask: “What do other evaluations say about it? How applicable is the context under which those studies were done, and how similar is the intervention? Study the literature to see if there is anything that suggests your approach might be effective.”

Rather than assessing impact, your limited resources are better spent assessing implementation. You can do this by collecting data that shows whether what you planned is actually happening. If you can pinpoint where the problems are, you are in a better position to make fixes, alter plans, refine processes.  Many organizations make their plans using a logic model (aka theory of change). A logic model is a flow chart with inputs and outputs. The best logic models draw on past impact evaluations to determine what inputs are most likely to lead to what outputs. And organizations can easily assess progress to date by plugging their logic models into real time data. Interested? Read more about “living logic models” HERE.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Data + Experience = Insight

Reposted from June 1, 2021

Data can’t take you all the way to a decision. In real life, you will never have enough data. So you’ll need to apply your own experience and your colleagues’ experiences to understand the implications of data for your work. Here’s a great way to apply experience to data. It’s from Dabbling In The Data: A Hands-On Guide to Participatory Data Analysis, a guide from Public Profit.

Dabbling in The Data describes how to do this group activity in person. I’ve adapted it to an online experience using Canva, but you can use any brainstorming app that allows for real-time collaboration. It’s simple yet powerful.

Step 1: Choose a template.

Sign up for a free Canva account. Click on “Create a design” in the upper right corner of the screen, select “whiteboard” from the dropdown list, and then select a template on the sidebar (A). I chose this template from the “Brainwriting” template group.

Step 2: Add a chart and customize.

Next add a chart showing change over time on some key measure you want to better understand. In this example, the key measure is the number of lessons provided to participants over a 7-year period. You can cut and paste an image of the chart from another program like Excel, or you can create the chart in Canva by click on the “Elements” tab in the sidebar (see B above), choosing a chart type, and then entering the data points (see C above.) I’ve added a chart and customized the instructions and notepads below. Note, it’s important to position the chart backward (see D above) and lock the chart in place (see E above) so that others can place notepads on top of the chart.

Step 3: Share the chart with your colleagues and invite them to add milestones.

Your colleagues will need free Canva accounts as well. To share the chart in real time, click on “Share” (see F above) and type in your colleagues' email addresses, making sure to allow them to edit the design. Ask the group to think about the key organizational milestones that occurred during the time represented in the chart and to add those milestones to the chart using the notepads at the bottom of the screen. Encourage them to also add detail to notepads added by others.

Step 4: Discuss.

Discuss how changes in the key metric over time might be related to the organizational milestones. Consider how this understanding of pivotal events can help you better show progress to stakeholders and to plan for the future. For example, if the implementation of a new program was followed by a decrease in participation, what about the new program may have caused the decrease? What else was going on at the time that may have contributed to the decline?

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Four Fun Chart Hacks

Have you played around with Canva? It’s a great, free online design tool. It includes lots of images and gifs and is easy to learn. Canva has a number of simple chart designs that you can adapt to your needs. After starting a design in Canva, click on “Elements” and then type in “chart” in the search window to see the chart options shown in the image below. Each allows you to customize the chart by entering in a few data points.

But I wondered how I could use other options in Canva to hack out some fun charts. Scroll down to see what I came up with.

 

Chart Hacks

Start a design in Canva by clicking on the “Create A Design” button (upper right corner of screen), selecting a size (such as presentation), and then try one of my hacks.

HACK 1: Use images to build bars: For this bar chart hack, I selected “Elements” and then searched for images of backpacks and then stacked them (by dragging and dropping) to create a bar chart about homework completion. You can use the “Show Rulers and Guides” option on the File menu to make the bars the right length.

HACK 2: Use icons to make a pictogram chart. Pictogram charts use icons to represent small sets of data. Each icon can represent one unit or any number of units (e.g. each icon represents 10). For this chart, I found a human graphic by selecting “Elements” and then searching for “human.” Then I colored the icons to show the number of students with failing grades and added labels using the text option on the left.

HACK 3: Use grids and photos to create a timeline of programs and events. Select “Elements” and type in “grid” in the search window. Canva will give you a bunch of frame options. Choose one and then select “uploads” to import photos of your organization’s events and programs. Then simply drag and drop photos into the grid and label bars using the text option on the left as in this example. Drag in a photo of something white for the empty cells.

HACK 4: Use frames and videos to create moving charts. For a bar chart like the one shown below, select “Elements” and type in “frame” in the search window. Canva will give you a bunch of frame options. Choose a rectangle shaped frame and place in the design, using the “Show Rulers and Guides” option on the File menu to make your bars the right length. Then select “Elements” and type in a key word for the type of image you want. I typed in “water.” Under the search window, click on “Videos” to show only video elements. Then drag and drop videos into the frames and label using the text option on the left.

For something like the line chart shown below, select “Elements” and type in “chart.” Select a line chart option and fill in data as needed. Then type in “frame” in the Elements search window. Choose a circle shaped frame and place in design over a data point, adjusting size as desired. Then select “Elements” and type in a key word for the type of image you want. I typed in “glow.” Under the search window, click on “Videos” to show only video elements. Then drag and drop a video into the frame. Use the “Position” button in the upper right corner to place the video “backward” (i.e. behind the chart). Label using the text option on the left.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


The Problem with Large Numbers (And What To Do About it)

Reposted from April 2021

BANs (Big Ass Numbers) — aka “vanity metrics” — are gaining prominent positions in data dashboards, websites, social media, email marketing, and annual reports these days. They are meant to impress. Wow! 359,234 meals served! Cool! $6 million raised!

But there is a problem with big numbers. Our brains can’t fully digest them. As noted in a 2017 Wall Street Journal article, “Big numbers befuddle us, and our lack of comprehension compromises our ability to judge information about government budgets, scientific findings, the economy and other topics that convey meaning with abstract figures, like millions, billions, and trillions.”

When quantifying the breadth of a problem or solution, nonprofits may toss out lots of giant figures, as in the bewildering graphic below. But without context, even numbers in the hundreds or thousands can bewilder.

So what can we do to make BANs more meaningful? Researchers at Columbia University and Microsoft found that they could improve numerical comprehension by using “perspectives,” which are simple sentences that relate a large number to something more familiar to us.

They found, for example, that when told that the number of registered firearms in the U.S. is about 300 million, study participants not only had trouble comprehending this number but also recalling it and assessing its likely accuracy. However, when told that there is about one firearm per person in the U.S., significantly more people could comprehend, assess, and recall the quantity. Makes sense to me. We can imagine a group of people, each holding a firearm, but we are hard pressed to imagine a pile of 300 million firearms.

So before you present a large number, consider a perspective that will make it relatable for your audience. Below are some formulas used in the Columbia/Microsoft study for developing perspectives.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Make Your Data Riveting

Reposted from September 2019

Attention is like a bouncer at the entrance to our brains. For anything to get inside and make a difference in how we think and act, it first has to win our attention. And I don’t have to tell you (although here I go anyway) that we each have limited attention and lots of things are competing for it. So if you aim to influence others’ thoughts and actions with data, give some consideration to the nature of attention.

What wins people’s attention? 1) Stuff that stands out and 2) Stuff related to our desires or goals. The former wins our “exogenous” attention. The latter wins our “endogenous” attention.

Say you are at a crowded cocktail party. You are going to notice stuff that stands out like loud noises or bright lights. But you will also notice stuff that does not stand out but is of particular interest to you such as that woman standing in far corner whom you were hoping to see. You may also notice if one of your favorite songs is playing softly in the background.

We can make use of this understanding of attention when we visualize data by:

  • Making the most important aspects stand out.  Vary the size, color, and space around text and data points. For example, make the title much larger than the rest of the text or color all of the data points gray except for the ones you want to call attention to.

  • Pointing to aspects that may interest your intended viewers. Use titles, subtitles, data labels and captions to highlight and explain aspects of the data that may be particularly engaging for your intended audience.

Check out the before-and-after vizes below to see how I’ve applied these techniques to focus my audience’s attention.

BEFORE

AFTER


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


 
 

Sure Data Confuses You. You Are An Early Human.

I recently read this article which suggests that, if we avoid a large catastrophe, we may be living at the early beginnings of human history. That is sort of mind-boggling. But even if we are not early humans, we are certainly at the beginning of our journey with data.

We aren’t so good at processing words and numbers and making sense of them. Think about the last time you looked at a spreadsheet and got the gist of it in a few seconds. By contrast, we can all get the gist of a photo in less than a few seconds. That’s because our brains have evolved over millions of years to process visual information — color, shape, size, placement — at lightening speed. Indeed, our survival depended on it. Think about detecting predators in the tall grass at a distance.

Processing words and numbers is a quite recent activity for humans, as the timeline below shows. Perhaps, as our brains evolve, we will be able to discern a spreadsheet at a glance. But, until then, we should consider visualizing our data by translating words and numbers into color, shape, size, and placement in the form of charts, maps, and graphs.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


5 Megatrends Fueling the Rise of Data Storytelling

Happy to share with you this great infographic from Visual Capitalist. You can find the full article here.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Reveal The People In The Data

Charts, maps, and graphs are, by nature, abstractions. And it can be easy to forget about the folks that the bars, circles, and lines represent. Plus sharing information on your clientele presents not only a visualization challenge, but also a privacy challenge since we rarely have permission to share information on all of our participants. Here’s my answer to that challenge. First, get permission from a handful of participants to share their stories. The visualization below provides an example of what we could do with that information. Each chart represents individuals with distinct shapes within groups. And scrolling over shapes colored in yellow reveals a photo and profile of an individual participant in select groups. Thus the charts convey both the aggregate story and individual stories. Try interacting with it yourself. I built this example using Tableau Public, the free version of Tableau.

And here is some more information on how to show the real people behind the data.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Upcoming Free Data Viz Webinars

webinars by Amelia Kohm

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Ideas You Should Steal From This Viz (Installment 4)

“Every artist gets asked the question: ‘Where do you get your ideas?’ The honest artist answers, ‘I steal them.’ . . . What a good artist understands is that nothing comes from nowhere. All creative work builds on what came before.” —Austin Kleon in Steal Like An Artist.

Today I offer up another steal-worthy interactive viz that I came across in the Tableau Public Gallery.


Source: Eugenio Gallastegui on Tableau Public


Here’s what I suggest you steal from this scatterplot:

  • Use color and labels to distinguish clusters. “Donor Score” appears to be a measure of engagement. By distinguishing groups based on their income and level of engagement, this scatterplot chart effectively shows the need for various strategies moving forward.

  • Use icons instead of dots. The chart reminds us that we are considering individual people by using human icons rather than dots on the scatterplot.

  • Provide detail on demand about individuals. The chart also lets us see the forest and the trees. If you scroll over icons, you learn more about the individuals in each group.

What I don’t think works so well on this chart is the size legend showing the age of donors and volunteers. It’s quite hard to discern the various sizes of the icons and form any ideas on the possible relationship between age and group membership.

To see past data tips, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


How To Motivate Action With Data

Data can either motivate or shut down action, depending on how it’s presented and to whom. Charts, maps, and graphs that convey good news can increase the commitment to an endeavor while those that broadcast bad news can either spur action among the already committed or quash action among the uncommitted.

Think about one of the most common data visualizations in the nonprofit world: the fundraising thermometer. When it shows minimal progress, only those most committed to the cause will likely donate. The thermometer may put off the less committed because it suggests that others do not feel the cause is important or because they feel that their small donation will not make much difference. However, when the thermometer shows considerable progress, the less committed are more likely to jump on the bandwagon. This is why, according to Eli Holder, many organizations don’t officially launch a campaign — and show a thermometer — until they are at least a third of the way to their goal.

Holder also offers up some advice on how to visualize data to maintain motivation in Dashboard Psychology: Effective Feedback in Data Design. Here’s my 60-second version of Holder’s recommendations:

Emphasize Progress Thus Far

You can make change over time appear more dramatic or more gradual depending on the the space between tick marks on your Y (or vertical) axis. Check out these two charts which show the same data, but the one on the right suggests a more dramatic increase and may be more motivating to the less committed. Of course it’s important to use this strategy to emphasize rather than deceive. Thus labeling the tick marks is essential.

Another way to emphasize progress is to give more visual weight to the good news. In this chart, the 7-day moving average trend is generally positive and is emphasized by the thick orange line. The daily changes are played down by using a thinner gray line. Moving averages, in general, iron out outliers and provides a sense of the overall trend.

Emphasize The Need For Progress

Those already committed may find the visualization of the gap between actual data and the goal quite motivating. Similarly, you can show them an expected range for a measure. As long as the data show that the measure is within range, they can feel reassured. However, a chart showing that the measure is above or below the expected range can motivate action. Note that the expected range can change over time with a lower range at the beginning of an endeavor and a higher one later on. Indeed, a changing expected range may reassure the less committed during early stages of an endeavor.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Head Versus Gut

Reposted from December 2018

Data is head food. But we often make decisions with our gut. And the gut is fueled by emotions.

It’s hard to defy our gut feelings when deciding. That’s because emotions often drive behavior. Evolutionary psychologists believe that emotions evolved to get us to do what has to be done to survive: to avoid predators, secure nutrients, resist infection, mate . . . you get the idea. So when your head says A, but your gut says B, you might feel an urgent need to do B because your survival button has been pushed.

I’m going to venture to guess that most of your decisions, like mine, are not directly related to survival. And when that’s the case, our emotions can lead us astray. In a 2016 article in the Atlantic, Olga Khazan summarizes research which suggests just how far astray. For example, anger may cause us to be trigger-happy and simplify our thinking. Happiness may lead us to make shallow assessments based on looks and likability. And depression may induce dwelling on particular issues.

It’s important to recognize our emotions and what they are telling us, rather than blindly following them. Sure, we can form hypotheses about gut feelings and see if the data support them. But when faced with a pressing decision in the real world, we often have a strong emotion and little data at hand. In these situations, we can ask ourselves: Is there a way to bring some more data to the problem quickly?

  • Perhaps it’s data collected by other people for other purposes. We can look for statistics about organizations similar to ours or about issues that our organization addresses.

  • Perhaps it's a quick and dirty anonymous survey of our staff, asking for their knowledge and opinions relevant to the decision.

The idea is to feed the head with some data and, in the process, temper the pleadings of the gut.

See other data tips in this series for more information on how to effectively visualize and make good use of your organization's data.