A Simple Way to Improve Nonprofit Charts

Sometimes showing whether something happened or not is more powerful than showing how much it changed over time. A recent Grist article highlights this idea through a striking example: instead of showing gradual temperature shifts over time (see the lefthand chart below), scientists simply showed whether a lake froze each winter—yes or no—across several decades (see righthand chart below). People who saw the righthand chart were more likely to perceive climate change as causing more abrupt changes.

Source: Grist

This binary approach—did/didn’t, yes/no, on/off—turns complex data into clear signals. And it’s not just for climate science. Nonprofits can use it to communicate impact in a way that’s instantly understood. Long-term trends are easier to see, and it evokes a stronger emotional response.

Try this in your nonprofit work:

  • Show which years a program met its goals and which it didn’t.

  • Visualize which communities have (or don’t have) access to a key service.

  • Use a yes/no timeline to highlight when a resource was available.

Binary visuals don’t oversimplify—they clarify. Read the full story here: Grist – Scientists just found a way to break through climate apathy.

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 Balance Your Information Diet

Reposted from January 2024

Here’s a question for you. And don’t go Googling. Just make your best guess.

Have the number of people experiencing homelessness in the U.S. increased or decreased since 2007?

Whatever your answer, you likely drew on your own personal experience as well as images and information from the media when guessing at the answer. Perhaps you drew on some statistics too. But, unless you have expertise in this area, probably not. Stick with me for a minute, and I’ll not only provide an answer to the question but also some insight into how we consume information.

Personal experience, media, and statistics affect how we understand any issue, and there are limits to each of these inputs. So we would do well to understand those limits before acting on our understanding by voting, donating, or making decisions about programs that our organizations operate. Max Roser’s article in Our World in Data (The limits of our personal experience and the value of statistics) walks us through some of those limitations:

Personal Experience

“The world is large, and we can experience only very little of it personally,” Roser notes. “For every person you know, there are ten million people you do not know.” Even the most social and well-traveled among us can have only a limited understanding of the world through personal experience. I, for example, do not know anyone personally who has been unhoused, and most of my interactions with people in this situation occur on the street when someone asks me for money. This experience provides no information about the breadth of the problem or the range of experiences with this issue over time.

Media

“This fact is so obvious that it is easy to miss how important it is: everything you hear about anyone who is more than a few dozen meters away, you know through some form of media,” Roser points out. “The news reports on the unusual things that happen on a particular day, but the things that happen every day never get mentioned. This gives us a biased and incomplete picture of the world; we are inundated with detailed news on terrorism but hardly ever hear of everyday tragedies like the fact that 16,000 children die every single day.” If I recently heard a story about a city clearing homeless encampments, I may assess the problem as larger, and if I haven’t heard about anything on the issue in awhile, I may assess it as smaller.

Statistics

“The collection and production of good statistics is a major challenge,” writes Roser. “Data might be unrepresentative in some ways, it might be mismeasured, and some data might be missing entirely.” But, unlike personal experience and the media, it provides a way of assessing the full range of an issue. So it’s important to add statistics, along with personal experience and the media, to our information diet.

To add some statistics to your understanding of homelessness, the number of people experiencing homelessness in the U.S. decreased from about 650,000 in 2007 to about 580,000 (about 18 of every 10,000 people) in 2022 according to The 2022 Annual Homelessness Assessment Report to Congress.

We should not discount personal experience, the media, or statistics because of their limitations. But we should appreciate their limitations when forming opinions and taking actions based on them. As Roser notes: “Each way of learning about the world has its value. It’s about how we bring them together: the in-depth understanding that only personal interaction can give us, the focus on the powerful and unusual that the news offers, and the statistical view that gives us the opportunity to see everyone.” As described in many tips in this blog, well-designed charts make data/statistics more accessible to everyone and thus allow everyone to see everyone.

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 Charts That Are Not Confusing

When clients ask me for a better way to show their data, it often becomes clear that they want something other than a bar chart. They hope that I will offer them some cool-looking chart that will captivate their stakeholders. There are, indeed, many interesting charts out there such as the ones pictured here.

Sources: APT: Voices For Human Dignity (1984-2024) | #VFSG | #VOTD by Arshi Saleh, Violin Chart Demo by Chinmay Jain, Parallel Coordinates Radar Chart by Andy Kriebel

But I always encourage my clients to consider how long it will take folks to learn how to read the chart using instructions and legends, then grasp the data in the chart, and finally remember what they saw. Unless the chart type is familiar or highly intuitive, it’s probably not worth it. Instead, I encourage them to focus on well-designed, visually-engaging charts that are also intuitive or familiar. Here are some 60-second data tips that can help:

  • How to hack a bar chart: I offer up eight bar chart hacks that make this trusty yet (sometimes) boring chart more interesting. See links below.

  • Data viz makeovers. Here are 10 art rules that elevate any data viz.

  • Chart types. To explore different chart types and what they are each good for, check out tips under “Chart Types” on the index/search page on the website.

I recently watched “Charts That Confuse Us” from a great series called “Chart Chat.” You might want to check that out too.

Bar Chart Hacks

Bar Chart Hack #1: The Divergent Stacked Bar Chart

Bar Chart Hack #2: The Icon Bar Chart

Bar Chart Hack #3: The Combo Chart

Bar Chart Hack #4: Radial Charts

Bar Chart Hack #5: Fine Tuning

Bar Chart Hack #6: The Funnel Chart

Bar Chart Hack #7: The Lollipop Chart

Bar Chart Hack #8: Double Duty Stacked Bars

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.

Wait, What? Numbers That Bewilder

60-SECOND DATA TIP_3 (1).png

Reposted from July 2019

Numbers can bewilder our hunter-gatherer brains. For more than 95 percent of human history, folks were not processing written numbers or words. But they were processing visual information in the form of color, shape, and size. It’s not surprising that our brains, evolved over many thousands of years, are better at understanding data in visual form than in word and number form. So when numbers confuse, try “translating” them to the visual.

Here’s a great example of a number that makes me scratch my head: “54% more students with monitors improved attendance than students without monitors.” The statement relates to a fictional program that (like some non-fictional programs) pairs students with monitors to boost their attendance. At first blush, to me, that sounds pretty impressive. It sounds like this: if 10% of the students without monitors improved their attendance, then 64% (10% + 54%) with monitors improved their attendance. Or, put another way, six times as many kids with monitors improved their attendance as kids without monitors.

But my brain just made a wrong turn. That 54% is showing what statisticians call “relative difference.” And the problem with this type of stat is that indicators with low values have a tendency to produce large relative differences even when the “absolute difference” is small.

Okay, still bewildered? No worries, I give you now a picture for your primitive brain. Let’s say, in our fictional program, there are 10 students per class. In one class, all of the kids got paired with monitors. In the other class, none of the kids did. The picture below shows how many kids in each class improved their attendance.

 
 

So the difference (aka “absolute difference”) is 1.4 (4.0-2.6) which means that 1.4 more kids in the class with monitors improved their attendance. How did that measly 1.4 become 54%? Well, relative difference is calculated as the absolute difference divided by the “standard” which, in this case, is the class without monitors. So 4.0 minus 2.6 divided by 2.6 or .54, which when expressed as a percentage is 54%.

If relative difference requires varsity level processing for many of us, then percentages are junior varsity. So if I were visualizing the difference between the two groups, I would stay away from both and use an icon chart, like the one above. I might make it even more concrete by showing 25 person icons in each group since the typical elementary school classroom has 25 students. I would then use color to show that 6.5 students out of 25 without monitors had improved attendance and 10 students out of 25 with monitors had improved attendance. So, if you bring the program to a typical classroom, you might expect it to improve the attendance of an additional 3 to 4 kids.

Bottom line? Numbers can be like road signs pointing us in the wrong direction. To move folks in the right direction, make your message concrete and visible.

See other data tips in this series for more information on how to effectively visualize and make good use of your organization's 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.








Do Data Dashboards Pay Off?

I haven’t come across much research on the effectiveness of dashboards for organizations. So I thought I’d share this one with you from MIT. Okay, it’s from the for-profit sector. BUT, it does give you something to chew on. Based on a survey of 1,311 companies, the researchers found that those that were better at using data dashboards were also better at other things like innovation and growth. If you are thinking, “Well, that’s correlation rather than causation,” then I’m glad. Maybe these data tips are making an impact.

However, their research does suggest that something about using dashboards could be paying off for companies. Based on their analyses, which included a case study of one company, the researchers suggest that one reason "dashboarding” appears effective is that:

“Everybody in the company gets to see how it is doing against agreed-upon metrics and works together to make course corrections when necessary.”

The process of getting everyone on board with using a dashboard, they note, can take awhile. They also contend that the best dashboards focus not only on what value is created but also on how that value is created. So although their findings are only suggestive, they do jibe with common sense.

Many nonprofits have shifted their data collection to focus on metrics that help to asses their processes and impacts. Fewer, it seems, are effectively using dashboards to look at those metrics everyday and discuss patterns, trends, and benchmarks, and make course corrections along the way.

Creating customized interactive dashboards isn’t as hard as it sounds and can even be created with free applications like Tableau Public. If you’d like to set up a free consultation to explore this idea with me, please do.

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 Present Data More Effectively For Your Audience (aka The Human Mind)

We hear a lot about applying data to action. But for data to make an impact, it must first take a journey through the human mind. Understanding that journey helps us to consume and present data so that the mind can actually see, grasp, remember, and apply it. Here's a preview of the first few slides of my upcoming webinar on this topic: How To Present Data More Effectively For Your Audience (aka The Human Mind).

Want to know what a dog spitting out a pill has to do with data presentations? Then join me on March 17th. Sign up HERE. Use code 'friend10' for $10 off registration.

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.

Is AI Overkill and Wasteful for Nonprofits?

Food for thought. Most nonprofits don’t need AI tools to deal with their data. Using it to calculate a simple average is like “using a bazooka to swat a fly,’ according to Chitra Sundaram in her article Beyond the hype: Do you really need an LLM for your data?* The sixty-second version of her article is: what most for-profit and nonprofit organizations need are clear data visualizations, descriptive analytics (such as trends and KPIs), and user-friendly data dashboards. And we already have excellent tools for these tasks including Tableau, Qlik and Power BI. Moreover, AI tools are resource hogs. We should focus instead on sustainable IT which is about “optimizing resources, minimizing waste, and choosing the right-sized solution.” When is an AI tool worth it? Sundaram says: when you are working with very complex, unstructured data such as text, voice, or images. Not when you are dealing with structured data (i.e. data in spreadsheets and databases) on participants, donors, or financials, as most nonprofits are.

To see past data tips, click HERE.

*LLM stands for large language models which are a type of AI (artificial intelligence).

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 Viz Inspo

Looking for ways to make your data more engaging? Take inspiration from these data tips on steal-worthy visualizations. Click on the images below to see the whole visualization and get suggestions on what to steal from it.

To see past data tips, including those about other chart types, scroll down or 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 the full list of events.

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 Average Nonprofit Overuses Averages

I’ve warned of the danger of averages before. Yet, I continue to see nonprofits defaulting to averages when they show data about their clients, participants, volunteers, fundraising, etc. So here’s another warning.

The visualization below (which, by the way, is called a bump chart), does a great job of illustrating the danger of averages. In this chart, average wealth is the wealth of a country’s people divided by the size of its population. The median is the middle value when everyone’s wealth is arranged in order. So billionaires have an outsized effect on the average, but the median is less affected by big outliers like billionaires. That’s why the U.S. ranks 4th in average wealth but 14th in median wealth.

Before you share an average with your board or on your website, consider what the median is. If it’s quite different from the average, you might consider showing both the average and the median or just the median.

To see past data tips, including those about other chart types, scroll down or 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 2024

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

New York Times

Visual Capitalist

FlowingData

The Webby Awards

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 Viz Humor

For my last post of the year, I give you 60 seconds of data viz humor. ICYMI, How I Met Your Mother did a great bit on charts and graphs back in 2009. If you like this, you might want to checkout Chart Chat’s recent discussion of the Top Ten Charts on TV.

To see past data tips, including those about other chart types, scroll down or 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 Present Diversity Data (or What To Steal From This Diversity Scorecard)

Reposted from February 2022

Today’s tip is to take inspiration from Chantilly Jaggernauth’s excellent diversity scoreboard displayed below. It shows diversity among employees in a company but can easily be applied to staff or participants in a nonprofit organization.

I suggest you steal the following ideas from Chantilly:

  • Metric Definitions. In a Tableau Conference session, Chantilly shares the pros and cons of the four metrics in the dashboard. See image of the slide below. None of the metrics are perfect. But together they provide an understanding of where an organization is in its diversity efforts. These definitions are not incorporated in the dashboard itself but could be added through a link or in a tooltip (scroll over) feature.*

  • Views of Diversity. The dashboard provides three views of diversity: overall, gender, and people of color (POC). By providing side-by-side charts with these three views, the dashboard allows users to see variations that overall diversity charts obscure.

  • Color Coding. Each type of diversity has its own color, which makes the comparison among overall, gender, and POC easy, even when you scroll down and can no longer see the column headers. Also the comparison groups (non-diversity, male, and non-POC) are represented by the same colors in lighter shades. This approach makes the dashboard easier to understand. Assigning three additional colors for the comparison groups could be confusing and require a color legend.

  • Simple Charts. These are all charts we all know how to read. So the scorecard is accessible immediately to anyone, even if they are not familiar with the data or the organization.

  • Also, note that the dashboard and the slide use different terms for two of the metrics.

Source: HR Diversity Scorecard on Tableau Public by Lovelytics

Image above from Tableau Conference session called “Next Gen Analytics for Your New Normal” on 11/10/21.


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.

I Used Free ChatGPT To Analyze Survey Data. Here's What I Learned.

1. You collect this type of survey data.

Here’s a familiar scenario. You survey your clients, participants, donors, volunteers, etc. and you include some “Other, please specify” options or other “open-ended” questions to better understand respondents’ opinions, experiences, etc.

2. But you don’t know what to do with it.

You collect your survey data but don’t have the time and/or analytical skills to deal with this qualitative data.* Maybe you create one of those horrible word clouds or, even more likely, you just analyze the quantitative data and ignore the qualitative data.

If you had the time and know-how, you might have “coded” the data in order to analyze it. This involves assigning themes to each open-ended survey response in Excel (or the like) or perhaps using one of these free tools.

*Quantitative data is numerical, countable, or measurable. Qualitative data is interpretation-based, descriptive, and relating to language.

3. But what about AI?

You’ve heard that it’s supposed to make tedious, repetitive tasks much easier, and coding survey responses certainly qualifies as both. Could you use the free version of ChatGPT to get this job done? I shared your curiosity and gave it a try. Bottom line: It helped to identify themes to use as codes but it didn’t do all the work for me. For a little longer description of my experience, keep reading.

4. Prepare for AI.

I watched this YouTube Video based on this article to learn how to craft a prompt that would likely get me what I wanted. I also found free survey data on the City of Chicago Data Portal to use for my experiment. The survey asked 43rd Ward residents about “other priorities” for their ward. I thought I could just upload the CSV data file to Chat, but it turns out you need the paid version for that. So I ended up pasting in the survey answers after entering the prompt. Also note that I used publicly available data. You should think twice about entering any type of sensitive data into Chat.

5. Craft the prompt.

Here it is. Yes, it’s long and yes, I say “please,” although I’m not sure if that affected the results!

6. Here’s what happened.

I first tried pasting in the prompt plus the data but that was too long for Chat. So I had to feed the data (all 23 pages) in batches of about 3 pages at a time and despite entreaties to Chat to update the charts based on ALL of the data I shared so far, it only gave me charts for the last batch I had entered, and I had to combine them in Excel. At first I was impressed with the almost instant tables, but I felt my AI assistant wasn’t quite listening to my instructions or just not understanding them. Still, I did develop this list of themes and Chat did code each survey response according to these themes, but I would not feel comfortable relying on these results and would want to possibly combine some of these themes and read through all the responses to see if I agree with the coding.

To see past data tips, including those about other chart types, scroll down or 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 Viz Inspo

Looking for ways to make your data more engaging? Take inspiration from these data tips on steal-worthy visualizations. Click on the images below to see the whole visualization and get suggestions on what to steal from it.

To see past data tips, including those about other chart types, scroll down or 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

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.

Why You Should Know About Calendar Heat Maps

Want to see patterns in participation, fundraising, volunteering, or social media measures across an entire year? A calendar heat map might do the trick.

This is a new addition to a series of tips on different chart types. In each tip, l give you need-to-know information in a format akin to the “Drug Facts” on the back of medication boxes: active ingredients (what the chart is), uses (when to use it), and warnings (what to look out for when creating the chart). The idea is to fill up your toolbox with a variety of tools for making sense of data. And the calendar heat map is a simple tool you can put to good use!

Active Ingredients (What is a calendar heat map?)

As in the example above, a calendar heat map shows a measure across days on a calendar. The measure might be the number of participants, dollars raised, volunteers recruited, social media engagement, etc.

Uses

Calendar heat maps provide a great way to see patterns in a measure over time, particularly if month and day of the week are important factors. For example, such a chart can help you detect whether participation is lagging on Mondays during summer months. In the example above, you can scroll over dates for more information and use the program filter to see participation for the selected program. Here are instructions for creating an interactive calendar heat map with Tableau and in Excel.

Warnings

Depending on your needs, other charts that show change over time may be more useful to you. For example, if you need to more clearly see the amount of change over time, a line graph might serve you better. For other chart types that show change over time, see below.

Fun Fact

Here’s a fun calendar heat map showing more/less common birth dates.

Source: Amitabh Chandra on Tableau Public

To see past data tips, including those about other chart types, scroll down or click HERE.

Source: Visual Vocabulary by Andy Kriebel on Tableau Public

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.

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.

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.