How To Make Big Numbers Tangible

Reposted from March 2022

We’ve talked about the problem with big numbers before. Most recently, we considered the difficulty humans have digesting large numbers and how “perspectives” — simple sentences that relate a large number to something more familiar to us — can help us to understand, assess, and recall numbers. (For more on this, check out the data tip.)

I’m returning to the big number problem today and offering up some new tips for dealing with them. The inspiration for these tips came from the data-driven documentaries of Neil Halloran, specifically his first documentary called The Fallen of World War II. If you have a few more minutes to spare after reading this 60-second tip (and are not among the 13 million + who have viewed it already), I highly recommend that you check it out. It’s 18 minutes long, but the techniques listed below all appear in the first 7 minutes.

Halloran uses the following techniques to make large numbers understandable. And you don’t need to be a filmmaker to use them. You can apply them to simple data presentations on websites, reports, and PowerPoints.

  1. Use shapes or icons (rather than bars) to represent one or more people, programs, etc. Halloran uses a human figure shape to represent 1,000 people.

  2. Show an aggregate and then break it down by subgroups and time periods. Halloran shows aggregates, such as the total number of U.S. soldiers who died and then, using animation, redistributes the human figures to show how many soldiers died in the European and Pacific theaters and then how many died over time. The animation is cool but not necessary. You can do the same thing with a series of static images. See example below.

  3. Juxtapose photos and charts. To keep the discussion from becoming too abstract, Halloran reminds the audience what actual soldiers (rather than icons) look like by incorporating photos into his presentation. Again, animation is not necessary. Static photos can be placed alongside charts.

  4. Walk your audience through the data. To give the audience a sense of scale, the video progresses from smaller to larger numbers. Halloran first walks us through casualty stats for the U.S. and European countries. These numbers seem quite high so by the time Russian stats are shown, we are blown away.


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 Recognize and Reform Vanity Metrics

Reposted from March 2022

Vanity metrics are like cheap, trendy sunglasses. They may help you to look cool, briefly, but they don’t last long and do little to improve your eyesight. You’ve seen vanity metrics, even if you haven’t used this term to describe them. They are those flashy statistics (sometimes called “big ass numbers”) and charts showing how many services an organization has provided or people they’ve served or some other seemingly impressive stat. The problem is that these metrics don’t help you to better understand your current work and improve it. In this tip, I’ll give you some quick advice on recognizing and reforming vanity metrics.

How To Recognize A Vanity Metric

This Tableau article suggests three questions to ask to identify a vanity metric. I’ve put a nonprofit spin on each:

  • What decision can we make with the metric? If the metric can’t help you to make a decision, it’s probably a vanity metric. For example, does knowing how many meals you delivered help you to decide who, what, where, when, or how to deliver meals in the future? Or do you need a more specific metric such as the gap between need and service provision for various subgroups of clients?

  • What can we do to intentionally reproduce the result? Did some random event produce the big number? For example, did you see a bump in the number of participants last year because another organization, providing a similar service, closed down? If you cannot consistently reproduce the same result next year, this isn’t a helpful metric.

  • Is the data a real reflection of the truth? Let’s face it. There are always ways to misrepresent the truth. You can tell the world that attendance at all of your programs last year totaled 3,237. Sounds good, but that’s probably a “duplicated number” and can be misleading depending on what you want to understand or broadcast to the world. Some people likely attended more than one program. So the total number of individuals who participated in any program could be much lower. The central question to ask yourself when considering a metric is whether or not it will help your organization achieve its goals. If your goal is to reach more folks, this metric is not helpful.

How To Reform A Vanity Metric

  • Provide context. The metrics that are worthy of your attention and your stakeholders’ attention are those that are directly related to your goals. You may have overall goals for all of your participants, clients, audiences, services, programs, etc. But you also might have specific goals for subsets of those groups and for specific time periods. Present your metrics in relation to the goals. And compare metrics for subgroups to each other to see where you are making progress and where you are not.

  • Use more than one statistic. Sometimes what you want to improve cannot be measured with just one metric. For example, if you aim to improve the diversity of your staff, you may want to look at a set of metrics together including number, tenure, and seniority of staff by race/ethnicity, gender identification, age, etc.

Sources: Moving Beyond Vanity Metrics, Stanford Social Innovation Review and Vanity Metrics: Definition, How To Identify Them, And Examples, Tableau.


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 Recognize and Reform Vanity Metrics

Vanity metrics are like cheap, trendy sunglasses. They may help you to look cool, briefly, but they don’t last long and do little to improve your eyesight. You’ve seen vanity metrics, even if you haven’t used this term to describe them. They are those flashy statistics (sometimes called “big ass numbers”) and charts showing how many services an organization has provided or people they’ve served or some other seemingly impressive stat. The problem is that these metrics don’t help you to better understand your current work and improve it. In this tip, I’ll give you some quick advice on recognizing and reforming vanity metrics.

How To Recognize A Vanity Metric

This Tableau article suggests three questions to ask to identify a vanity metric. I’ve put a nonprofit spin on each:

  • What decision can we make with the metric? If the metric can’t help you to make a decision, it’s probably a vanity metric. For example, does knowing how many meals you delivered help you to decide who, what, where, when, or how to deliver meals in the future? Or do you need a more specific metric such as the gap between need and service provision for various subgroups of clients?

  • What can we do to intentionally reproduce the result? Did some random event produce the big number? For example, did you see a bump in the number of participants last year because another organization, providing a similar service, closed down? If you cannot consistently reproduce the same result next year, this isn’t a helpful metric.

  • Is the data a real reflection of the truth? Let’s face it. There are always ways to misrepresent the truth. You can tell the world that attendance at all of your programs last year totaled 3,237. Sounds good, but that’s probably a “duplicated number” and can be misleading depending on what you want to understand or broadcast to the world. Some people likely attended more than one program. So the total number of individuals who participated in any program could be much lower. The central question to ask yourself when considering a metric is whether or not it will help your organization achieve its goals. If your goal is to reach more folks, this metric is not helpful.

How To Reform A Vanity Metric

  • Provide context. The metrics that are worthy of your attention and your stakeholders’ attention are those that are directly related to your goals. You may have overall goals for all of your participants, clients, audiences, services, programs, etc. But you also might have specific goals for subsets of those groups and for specific time periods. Present your metrics in relation to the goals. And compare metrics for subgroups to each other to see where you are making progress and where you are not.

  • Use more than one statistic. Sometimes what you want to improve cannot be measured with just one metric. For example, if you aim to improve the diversity of your staff, you may want to look at a set of metrics together including number, tenure, and seniority of staff by race/ethnicity, gender identification, age, etc.

Sources: Moving Beyond Vanity Metrics, Stanford Social Innovation Review and Vanity Metrics: Definition, How To Identify Them, And Examples, Tableau.


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 Big Numbers Tangible

We’ve talked about the problem with big numbers before. Most recently, we considered the difficulty humans have digesting large numbers and how “perspectives” — simple sentences that relate a large number to something more familiar to us — can help us to understand, assess, and recall numbers. (For more on this, check out the data tip.)

I’m returning to the big number problem today and offering up some new tips for dealing with them. The inspiration for these tips came from the data-driven documentaries of Neil Halloran, specifically his first documentary called The Fallen of World War II. If you have a few more minutes to spare after reading this 60-second tip (and are not among the 13 million + who have viewed it already), I highly recommend that you check it out. It’s 18 minutes long, but the techniques listed below all appear in the first 7 minutes.

Halloran uses the following techniques to make larger numbers understandable. And you don’t need to be a filmmaker to use them. You can apply them to simple data presentations on websites, reports, and PowerPoints.

  1. Use shapes or icons (rather than bars) to represent one or more people, programs, etc. Halloran uses a human figure shape to represent 1,000 people.

  2. Show an aggregate and then break it down by subgroups and time periods. Halloran shows aggregates, such as the total number of U.S. soldiers who died and then, using animation, redistributes the human figures to show how many soldiers died in the European and Pacific theaters and then how many died over time. The animation is cool but not necessary. You can do the same thing with a series of static images. See example below.

  3. Juxtapose photos and charts. To keep the discussion from becoming too abstract, Halloran reminds the audience what actual soldiers (rather than icons) look like by incorporating photos into his presentation. Again, animation is not necessary. Static photos can be placed along side charts.

  4. Walk audience through the data. To give the audience a sense of scale, the video progresses from smaller to larger numbers. Halloran first walks us through casualty stats for the U.S. and European countries. These numbers seem quite high so by the time Russian stats are shown, we are blown away.


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)

60-SECOND DATA TIP_3.gif

BANs (Big Ass Numbers) 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 Use Big A** Numbers

60-SECOND DATA TIP_3 (1).png

You already know about BANs even if you don’t think you do. They are Big Ass Numbers meant to catch your attention. You see them everywhere these days, featured in bold fonts on websites, brochures, and reports; sprinkled throughout PowerPoint presentations; and arrayed as KPIs* in data dashboards.

BANs are having a moment. And they can be powerful. But watch out for overdoing it. When lots of BANs crowd a single display, they steal each other’s limelight and bewilder the audience. Anyone who gives a BAN a moment’s thought might wonder: “Wow, 5,000 meals sounds like a lot, but what is the need? What do similar organizations provide?”

So use BANs sparingly and give them space so they can shine. Also, provide context when possible: “5,000 meals served and no one turned away.”

Steve Wexler also advises using one or two BANs when they provide a good overall summary of a lot of data and when they clarify and provide context for subsequent charts, maps, and graphs.

And for some great ways to design BANs, check out Adam McCann’s 20 Ways to Visualize KPIs.

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

*key performance indicators