Pop Quiz: Guess What This Chart Shows

Reposted from September 2022

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 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.


Add This To Make Your Charts Memorable

Copy of 60-SECOND DATA TIP_3.png

Reposted from October 2019

Look at the two images below.  Which catches your attention? Which do you think you are more likely to remember?

Edward Tufte and other data viz gurus have warned us against “chartjunk” which is anything that is not necessary to comprehend the information represented on a chart, map, or graph. The idea is to get rid of distractions and focus attention on the data.

But some research by Michelle Borkin and colleagues points in a different direction.  In an experiment, they showed participants charts with and without various elements that might be construed as chartjunk like photos and drawings. They found that such images not only did not hinder memory or understanding of visualizations, they appeared to serve as “visual hooks into memory.”  Such visual hooks are important because what we perceive is based, in part, on what we expect to perceive due past experiences.

The idea of not loading up a chart with a lot of junk competing for attention is still a good one. But some images, if they are closely related to the data and connect with what folks already know, can help viewers to focus on and absorb information.

For more on how to capture attention with data visualizations, check out this data tip.

Sources:

M. A. Borkin et al., "Beyond Memorability: Visualization Recognition and Recall," in IEEE Transactions on Visualization and Computer Graphics, vol. 22, no. 1, pp. 519-528, 31 Jan. 2016.

 P. Kok et al., “Associative Prediction of Visual Shape in the Hippocampus,” in Journal of Neuroscience 1 August 2018, 38 (31) 6888-6899.

 Photo by Nery Zarate on Unsplash


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 Activate Board Member Fundraising With Visuals

Reposted from January 2023

I recently came across this excellent article by The Fundraising Authority. As promised in the title, it provides a “Simple, Step-by-Step Process for Getting Your Board to Refer New Prospects to Your Non-Profit.” In a nutshell, here are the four steps:

  1. Explain how referrals work and assure your board members that no one they refer will be asked for money until they indicate a desire to get involved.

  2. Show board members how many people they actually know through a mind mapping exercise.

  3. Ask board members for referrals usually in person.

  4. Bring referral success stories back to board meetings on a regular basis.

My tip is to enhance steps 2 and 4 with visuals.

Visuals for Step 2: For the mind map, the point is for board members to brainstorm all the people they know by considering people in different categories of their lives. You can use Canva whiteboards (or a similar tool) to create a mind map that the board member (pictured in the middle) can use to add the names of people in each category on virtual post-it notes.

Visuals for Step 4: The article claims that “this is a key step. Nothing will convince your board members to bring you more referrals than hearing from other board members that have done it successfully.” You can visualize the donors whom various board members brought in using tools like Flourish to show their networks, as in this example. Scroll over the circles to interact with it and learn more. Some board members brought in donors who, in turn, brought in other donors. To make something similar, select one of the network graph templates on Flourish and fill in the data needed. (See snapshots of the data I added for the visual below.)

Links data

(used to show who is connected to whom)

Points data

(used to show groups by color, size points according to amount of donations, and add images for board members)

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.


When to (and NOT to) Use a Map

Copy of 60-SECOND DATA TIP_3.png

Reposted from December 2019

Maps can be a powerful way to show your data. But not always. Maps work best when . . .

1) Your audience already knows the geography.

Most Americans have a basic understanding of the size, demographics, land use, weather, and history of different regions of the U.S. It’s that foundational knowledge that makes maps like the following so effective. We think: wow, cows would take up all of the midwest if we put them all together, and urban housing would require only a portion of New England. Or, if only white men voted, just a few states in New England and the Northwest would go Democratic.

Source: Bloomberg

Source: Bloomberg

But when we are not familiar with the geography, maps are much less illuminating. For example, if you don’t know Ireland well, then this map does not shed much more light on the matter than the simple bar chart in the upper left hand corner. It tells us which clans are most prevalent, which is all the map also shows us unless we know more about the different regions.

Source: Brilliant Maps

2. You are showing the significance of proximity or distance.

Even if your audience is not familiar with the geography (and sometimes especially when they are not familiar with it), maps can be an effective way to show proximity or distance. This map of the Eastern Congo shows us how close armed groups (in green) are to internally displaced people (in purple). Just naming the cities or regions where these two groups are would not be effective for audience unfamiliar with the geography.

Source: Brilliant Maps

For more information on when to use a choropleth map (in which regions are filled with a color, shades or patterns to represent a value), check out this great article from Datawrapper.


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.

Reposted from August 2022

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 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.


Ideas You Should Steal From This Viz (Installment 12)

“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.

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

  • Dot Matrix Chart Type. Each dot in a dot matrix chart is colored to represent a category and sized to represent the magnitude of the category. Thus the chart provides an overview of the distribution and proportions of each category in the data set. By clicking through the ban categories at the top (classrooms, libraries, etc,), we get a quick sense of the magnitude and origin of book ban challenges.

  • Explanation/Directions. The text on the left tells us everything we need to know to extract meaning from the visualization without loading us down with unnecessary details.

  • Details on Demand. For those who want more information, details are available on demand by scrolling over the individual circles and the info button.

Source: Gbolahan Adebayo on Tableau Public

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.


Another Data Viz Resource You Should Know: USAFacts

Here’s a new addition to my highly-curated resources list: USAFacts. I occasionally write a 60-second data tip describing a particular resource, including why I think it’s cool. And I link each of these tips to a resources list on my website.

What is it?

USAFacts is dedicated to making government data more accessible. The idea is to help people understand where their tax dollars are going and to help those working on issues of concern in the philanthropic, nonprofit, and public sectors to easily access information to inform their decisions.

Who’s it for?

The general public, policymakers, philanthropists, nonprofit managers, and researchers, among others.

Who’s behind it?

After he retired from tech and began to focus on philanthropy, former Microsoft CEO Steve Ballmer wanted to understand what the government spends on programs to help people and the outcomes of those programs. However, unlike businesses, US governments are not mandated to compile reports on their expenditures. He then hired data analysts to compile this data, and this was the origin of USAFacts, a not-for-profit, nonpartisan civic initiative which is solely funded by Ballmer.

Why I think it’s cool

It’s free and the data is shared under a Creative Commons license. They only ask that you credit USAFacts when using their curated material. Most of their data is visualized and all of it is well-documented. Charts can be easily downloaded in an image format or embedded into your website using an embed code like the chart below.


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.


10 Essential Data Facts For Non-Data People: The Cheat Sheet

Reposted from January 2022

Here are ten data facts for non-data people who, nevertheless, have to deal with data sometimes (i.e. most of us). This is the cheat sheet. Click on the “Learn More” buttons for additional information served up in comic strip format!


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 Power of Substraction

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.”

―Antoine de Saint-Exupéry, Airman's Odyssey

If you have heard of any data viz guru, it’s probably Edward Tufte. And if you know one thing about Tufte, it’s probably the data-to-ink ratio. The data-to-ink ratio is the amount of ink (or pixels) that convey the data divided by the total ink (or pixels) used in the entire chart. The ratio, according to Tufte, should be as close to one as possible. In other words, most of the ink/pixels should be conveying data, and you should remove as much non-data ink/pixels as possible. Click through Joey Cherdarchuk’s slides below for a great example of what Tufte is talking about.

Source: Darkhorse Analytics

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.


Presenting Data Fast and Slow

Reposted from May 2022

Sometimes we approach the challenge of sharing data with others as if we were trying to con a pet into taking a pill. We think that our audience is too busy, disinterested, or distracted to focus on the data. So we wrap it in something that attracts their attention and feed it to them as quickly as possible. The problem with this approach is that it may get the data into their brains—momentarily—but it won’t stay there long. See where the pill ends up in this video.

If we want others to LEARN from the data — which involves not only retaining it but also drawing knowledge from it and applying that knowledge in the future — then we need a different approach. Daniel Kahneman’s Thinking Fast and Slow can help us.

First a little background on how the brain works, according to the evidence Kahneman presents. For learning to happen, information first must get past System 1 of our brains. This is where fast thinking happens. System 1 is the harried gate keeper, madly processing all of the information that comes in through our senses, pitching most of it, keeping only what is deemed necessary. But making it through the gate is only half the battle. Once in, information confronts System 2. This is the part of the brain that allows for conscious thought or slow thinking. The problem is that System 2 is lazy. Conscious thought is hard, and System 2 is always looking for an excuse to avoid it. However, if System 2 engages with information, the resulting knowledge can find its way to long-term memory and learning happens.

So the challenge when presenting data is to make it past System 1 AND engage System 2. Let’s consider a series of vizes from Harvard Business Review (HBR) that I think meets both parts of this challenge. Yes, it’s an example from the for-profit world, but could easily work with nonprofit data. See snapshot of the first viz in the series below .

How to get data past System 1

Getting data past the System 1 fast-thinking gate keeper is all about grabbing attention. We process images much more quickly than words and numbers, so images are a great foot-in-the-door. The HBR viz does it with bright colors and a cool-looking, somewhat unusual chart. There’s plenty of information out there about how to attract attention, including the use of images with:

  • Stand out colors and textures

  • Human faces (we are wired to focus on them)

  • Novelty (images that are unusual in size, placement, etc.)

Data visualizations can use color as well as images to draw attention. But getting past System 1 is not nearly enough. For learning to happen, the viz also has to engage System 2.

How to engage System 2

System 2 is smart but lazy. So we need to pique its interest. The HBR viz starts with a title that poses a question. When confronted with an interesting question, we may be more likely to stick around for an answer. Then the viz leads you through the answer in a visually engaging way (see interactive version of the viz HERE). These are two great ways to slow down and engage the brain with data. Here’s a list of ways to engage System 2:

  • Ask a question in the title as the HBR viz does—questions beg answers.

  • Make it personal. We may be more likely to engage with data when we have a personal connection with it. This New York Times viz, for example, allows you to enter in your county to see what the barriers to COVID vaccination are in your area.

  • Highlight a surprising finding. Many of us love the counterintuitive and the creative. If you draw attention to something new that the data suggests, you may have a better chance at hooking System 2. For example, this viz from The Economist shows that China emits far less greenhouse gas per person than Western countries at the same stage of economic development. Or check out this viz by Dimiter Toshkov showing that small countries can be big players in development and good governance.

  • Hand draw it. There is some evidence that making information harder to consume, for example by presenting it with harder-to-read fonts, makes the brain slow down and engage in effortful and analytic processing. Although the jury is still out on this, I do find myself more likely to engage in hand-drawn vizes like two of the winners of the World Data Visualization Prize in 2019. Perhaps it’s simply the novelty of hand-drawn charts that engages me. Anyway, it’s something you might consider, and all you need is a pen and paper.

  • Walk them through it. A great way to slow down your viewers is to set the pace by walking them through the data as HBR does in the example. I love how HBR presents what the data might look like if our assumptions were confirmed followed by what it actually looks like.

Sources: Veritasium, Visual Content Space, MIT News, Springer Link,


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 11)

“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: Kizley Benedict on Tableau Public

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

  • Beeswarm Chart. The beeswarm chart at the top allows you to easily compare several countries and to see the overall distribution along the Gender Inequality Index among large and small countries. For more on beeswarm charts, see this tip.

  • Highlight a Country. For users who want to know about a particular country, the dashboard provides a search tool which highlights the selected country.

  • Overall Then Zoom In. After getting a sense of the overall distribution from the beeswarm chart, the user can zoom in and make comparisons among and within regions with the maps along the bottom of the dashboard.

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?

Reposted from September 2022

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.


It's Love Data Week!

What’s that?

Love Data Week is an international celebration of data, taking place every year during the week of Valentine's Day. Nonprofit organizations, universities, government agencies, corporations and individuals are encouraged to host and participate in data-related events and activities.

What’s in it for me?

Lots of free online events, many of which are relevant to nonprofit work such as workshops on data visualization, infographics, data resources, data privacy, etc. See a full list of events HERE.

Where can I learn more?

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.


Best Data Viz of 2023

Looking for a fun (if somewhat geeky) study/work break? Check out these best-of lists for 2023:

New York Times

Visual Capitalist

538/ABC News

FlowingData

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.


The Allure and Danger of Data Stories

Reposted from December 2018

I recently read Has Data Storytelling Reached Its Peak? in which Amanda Makulec suggests that we use the term “data storytelling” cautiously. “Not every piece of data needs to be communicated as a story,” Makulec notes. “Sometimes we need to start with story-finding or just a well structured chart, rather than a full narrative arc.” I’ve had my own concerns about the term “data storytelling” which I’m sharing with you (again) today.

***

“Data” and “storytelling” are an item. You see them together all the time lately. When I first came across the term “data storytelling,” it instantly appealed to me. “Data” suggests credibility, information that has some objective basis. But data, to many of us, is boring. Its meaning is often uncertain or unclear. Or, even worse, it’s both. “Storytelling,” by contrast, suggests clarity, a plot with both excitement and resolution. So, by coupling these two words, we seem to get the best of both worlds. Data lend credibility to stories. Stories lend excitement and clarity to data.

Indeed, that’s the point of data storytelling. As Brent Dykes, a data storytelling evangelist of sorts, noted in a 2016 Forbes article, “Much of the current hiring emphasis has centered on the data preparation and analysis skills—not the ‘last mile’ skills that help convert insights into actions.” That’s where data storytelling comes in, using a combination of narrative, images, and data to make things “clear.”

But let’s step back just a minute. Why are we so drawn to stories? According to Yuval Harari, author of Sapiens: A Brief History of Humankind, the answer is:  survival. Harari maintains that humans require social cooperation to survive and reproduce. And, he suggests that to maintain large social groups (think cities and nations), humans developed stories or “shared myths” such as religions and corporations and legal systems. Shared myths have no basis in objective reality. Reality includes animals, rivers, trees, stuff you can see, hear, and touch. Rather, stories are an imagined reality that governs how we behave. The U.S. Declaration of Independence states: “We hold these truths to be self-evident: that all men are created equal . . . “ Such “truths” may have seemed obvious to the framers, but Harari notes that there is no objective evidence for them in the outside world.  Instead, they are evident based on stories we have told and retold until they have the ring of truth.

So stories (in the past and present) are not about telling the whole truth and nothing but the truth. Instead, they are often about instruction: whom to trust, how to behave, etc. And we should keep this in mind when telling and listening to “data stories.” To serve their purpose, stories leave out a lot of data — particularly data that doesn’t fit the arc of the story. For example, you might not hear about a subgroup whose storyline is quite different from the majority. Or, indeed the story might focus exclusively on a subgroup, ignoring truths about the larger group.

Bottom line: listener beware. A story, whether embellished with data or not, is still just a story. And truth can lie both within and outside of that story.


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.


Two Ways to Offer The "Just Right" Data Portion

60-SECOND DATA TIP #8 (3).png

Reposted from June 2018

Pretend that you are Goldilocks and your porridge is data. How much data is just right? Just enough to engage your funders, staff, or board members, but not so much as to be overwhelming?

To answer this question, we might consider Miller’s Law. George A. Miller was a psychology professor at Princeton University and wrote one of the most frequently cited papers in psychology: "The Magical Number Seven, Plus or Minus Two: Some Limits on Our Capacity for Processing Information."

Miller conducted experiments on human memory and concluded that the number of objects that an average human can remember in the short-term is 7 ± 2.  Objects can include symbols like numbers or abstract concepts. We also can hold several groups of related objects in mind.

Armed with this knowledge, we can make visualizations of data (charts, maps, graphs) easier to digest by:

1) Grouping data into categories. Whenever you have a graph or chart with more than 5 data categories, the individual units start to lose their individuality and are perceived by our eyes as a single whole. In the “before” and “after” examples below, the after chart is easier to process because it combines data on donors into just two groups: those in Chicago and those in other cities.

2) Highlight one or two single categories and gray out the rest. The second chart below (called a parallel coordinates chart) includes a line for each of the 50 states showing the prevalence of various diseases in each state. But only one state (Hawaii) is highlighted and the rest are grayed out. Thus there are really only two data categories to compare: 1) Hawaii and 2) the rest of the states.

BEFORE: TOO MANY GROUPS

many groups.jpg

AFTER: JUST TWO GROUPS

two groups.jpg

HIGHLIGHT ONE GROUP

hawaii.jpg

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.


Interesting Versus Actionable Data

60-SECOND DATA TIP_4 (3).gif

Reposted from October 2021

It’s easy to get lost in a sea of interesting data when what you really need is actionable data. As Oracle’s Nate Mayfield points out, you know when you’ve presented only interesting data when you get this type of response: “Oh, cool. Yeah, that's great to know.” On the other hand, if you hear “Oh, okay. I can definitely decide what to do now,” then you’ve presented actionable data.

The key to presenting actionable data is to ask specific—rather than broad—questions. And then design your charts, maps, and graphs to answer those narrower questions. Mayfield’s article focuses on the types of questions a business might ask. Let’s consider the types of questions a nonprofit might ask:

Interesting Questions.png

Mayfield notes that data dashboards that are designed for a wide range of users tend to address only interesting questions. “Because they are intended for a broad set of users, with a lot of filters, you can in theory answer a lot of questions with these sprawling dashboards,” says Mayfield. “The problem is people quickly get lost in them and don’t spend the time required to answer their questions.” Instead, Mayfield advises us to create simple dashboards that answer quite specific questions such as the actionable questions above. So consider a series of simple dashboards, each designed to provide answers that prompt action for a particular type of user.

To see past data tips, including tips on other types of pantry staple data, 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.


What Averages Obscure

Copy of 60-SECOND DATA TIP #8.png

Reposted from January 2018

Nonprofits (and everyone else) are addicted to averages. We like to talk about how participants do on average. We might describe how many visitors we have in an average week. But how much are we missing when we focus solely on averages? Short answer: it depends, but it could be a lot. If I only showed you the average sized person in the picture above, would you appreciate the full range of sizes?

To figure out what and how much we are missing, we need to calculate—or better yet show—how spread out our data points are. Understanding the spread gives us an idea of how well the average represents the data. When the spread of values in the data set is large, the average obscures the real picture more than when the spread is small.

Spread measures include range, quartiles, absolute deviation, variance and standard deviation. For more on these measures, check this out. 

A great way to quickly grasp the spread of your data is to make a box plot. A box plot (aka. box and whisker diagram) shows the distribution of data including the minimum, first quartile, median, third quartile, and maximum. The box plots below show the affordability of neighborhoods in five cities. Each red circle represents a zip code area. The gray boxes show where 50 percent of the zip code areas fall on the affordability scale. And the median (the middle point in a dataset) is where the dark gray meets the light gray. You can see that, in general (i.e according to the median), New York is more affordable than Los Angeles. However, New York has some zip code areas that are much less affordable than the median seems to suggest.

So when looking at your data, don’t just look at averages, also consider the spread.

boxplot2.jpg

Image created by Moxilla for Noun Project.


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.



Bar Chart Hack #7: The Lollipop Chart

Reposted from February 2019

The lollipop chart provides a short and sweet addition to the 60-Second Data Tip series, “How to Hack a Bar Chart.”

A lollipop chart is nothing more than thin bars with circles on top. So why go to the trouble? Well, if you have a lot of bars of similar length, you should not go to the trouble. The circles will just make comparing the lengths of the bars more difficult.

But the lollipop chart can be helpful when you have a bunch of bars of varying lengths, and you want to set them apart in a visually interesting way. Also, you can use those circles as labels, as in the example above.

Check out these easy instructions for making lollipop charts in Tableau and Excel.

To see past data tips, click HERE.

Icons created by Ben Davis, Dinosoft Labs, and andrewcaliber from Noun Project.


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.




Bar Chart Hack #6: The Funnel Chart

Reposted from February 2019

Today we arrive at Episode 6 of the 60-Second Data Tip series, “How to Hack a Bar Chart.” As we have discussed, bar charts are user-friendly and familiar, but familiarity can breed contempt. So this week we consider yet another variation of the bar chart called the funnel chart.

The funnel chart is used to visualize a process and how the amount of something decreases as it progresses from one phase to another. You might think of it as a pipeline.

The example below shows the decreasing number of participants at each stage of a food service training program. We can see that few of those who attend orientation make it all the way to a job. And we can see where there is the most/least drop off. This funnel is also interactive. You can see the funnels for particularly subgroups by changing the filter at the top.

It looks cool and makes intuitive sense, but a funnel chart is just a bar chart on its side with a mirror image. Check out these easy instructions for making funnel charts in Tableau and Excel.

 

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.