How To Choose The Right Chart

Copy of 60-SECOND DATA TIP.png

Reposted from September 2018 with updates!

There are many chart choosing tools out there. You can find online tools: just Google “chart chooser.” You also can use tools built into data visualization applications like Tableau or, of course, ask your friendly AI. But I still like one of the simplest out there: Andrew Abela’s decision tree called Chart Suggestions—A Thought-Starter.  It’s based on Gene Zelazny's classic work Say It With Charts. I like that it focuses on what you are working to show and gets you thinking about that. It prompts thinking, as the name suggests, and thinking is a good activity to do before visualizing data!

The decision tree starts with the basic question: “What would you like to show?” And provides four options:

Comparison. You have two or more groups of things or people and you want to see which group is largest/smallest or highest/lowest (or somewhere in between) on some measure. You also may want to see how these groups compare on the measure overtime.

Distribution. You have a bunch of data points (e.g. the ages of participants in a program or test scores of students in a class) and you want to know how spread out or bunched up they are. Are most of the ages, test scores (whatever) near the average? Or is there a wide range? Are there some extreme outliers?

Composition. You want to understand who or what makes up a larger group such as how many of the participants in a program are in different age brackets or how many have been in the program for different lengths of time.

Relationship. You want to know if one thing is related to another, either at one point in time or overtime. Does more participation in a mental health program correlate with less distress over time? Do those with lower incomes have higher heart rates?

Once you answer this basic question, the decision tree helps you to choose a specific chart based on the type of data you have. Abela’s chart chooser includes the types of charts you are most likely to select. But there are more rare species out there. To learn more about the wide array of ways to visualize data, check out the Data Visualisation Catalog.

However, I will leave you with a word of caution. And that word is: “Xenographphobia” or fear of weird charts. It’s a thing. And you should be aware of it. Although we might like the look of sexy charts, we don’t usually have the time or patience to figure them out. So in the interest of creating a positive and productive user experience, consider sticking with the charts folks already know how to read or are self-explanatory.

 

Column chart with line chart by HLD, Line Graph by Creative Stall, Pie Chart by frederick allen, Radar Chart by Agus Purwant, and sankey diagram by Rflor (from the Noun Project)

What's The Difference Between An Infographic and A Data Visualization?

Reposted from April 2018

Infographic and data visualization often are used interchangeably. And, indeed, the distinction is not hard and fast. They both focus on showing rather than telling. They explain something using more visual cues than words or numbers and so take advantage of our visual superpowers. (For more on these superpowers, see Tip #1.) The difference is that an infographic is more of a story, and a data visualization is more of a tool.

An infographic typically uses images to lead the viewer through a story. Some of those images might be visualizations of data. For example, the point of this infographic is to highlight aspects of a nonprofit workforce shortage. Infographics are usually meant to explain or show something to people who are not all that familiar with the topic.

A data visualization, unlike an infographic, uses visual cues (shape, color, size, etc.) primarily to represent data. Think bar chart, line graph, pie chart, and maps. And though the creators of the data visualization may have a story they want to tell, the viewer can use the visualization to discern any number of stories.

For example, on the quadrants chart below, each circle represents an educational strategy. The strategies are plotted along two measures: how much importance educators place on the strategies and how often they put these strategies into practice. We can use this chart as a tool to decide what to do next. Clearly, most of the educators represented in the data already feel these strategies are important. But they use most of the tactics less than 50 percent of the time. So we need not waste time explaining the value of the strategies to them. Instead, we should determine what is preventing them from implementing the strategies.

If you are looking to tell a specific story particularly to an outside audience, consider an infographic. If you are looking for a tool to explore data, consider a data visualization.

 
 

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.

Understand Your Volunteers Using "Pantry Staple" Data

If your organization is like most nonprofits, you rely on volunteers to get the job done. And you probably have at least some basic “pantry staple” data on volunteers.

Pantry Staple Data: Volunteer Data

The volunteer data you already have can be leveraged to:

  • Impress funders, donors, and other stakeholders. Show them how you are using this free resource to move the needle.

  • Recruit new volunteers. As we have discussed in this blog before, we are all influenced by peers. So show how many volunteers you have to attract even more.

  • Manage volunteers more effectively. Seeing clearly what’s going on with your volunteers will help you to retain them, make better use of them, and recruit new ones. This is the subject of today’s tip.

Use Case: Maximizing Volunteer Time and Value

This volunteer data dashboard uses a variety of charts to answer the who, what, where, and when questions that you may have about your volunteers. With this detailed view of volunteers, an organization can start thinking about how to activate inactive volunteers, what types of new volunteers to target, and when during the year to deploy volunteers.

Source: Jin Tat on Tableau Public

Source: Jin Tat on Tableau Public

This simple map dashboard provides insight into the distribution of volunteers—and volunteer hours—among sites. This understanding can help you decide if and how to redistribute volunteers. Both this dashboard and the one above can be created using Tableau Public, the free version of Tableau.

Source:CCE on Tableau Public

Source:CCE 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.

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.

3 PowerPoint Laws to Always Obey

60-SECOND DATA TIP_3 (1).png

Reposted from April 2019

Charts, graphs, and maps often make their debut in PowerPoint presentations (or the like.) This is a problem. A bad PowerPoint can kill even a great data visualization.

We already know PowerPoints are a problem. We have napped through many of them in our careers. And we even know, when we are on the creating end, that they shouldn’t be text heavy. But we don’t know what else to do besides typing in a few bullet points and pasting in some bad clip art.

Since I’m committed to giving you something useful in 60-second portions, this week I give you my top three PowerPoint laws (yes laws – you might not take mere recommendations as seriously, and this is important!)

Law #1: Slides are for seeing. Think about the last subtitled movie you saw. Did you miss a lot of the action while reading? Research shows we are quite good at simultaneously processing pictures and spoken words. But our brains go on overdrive when processing pictures plus written text – like during subtitled movies. And our brains can completely shut down when processing written text plus spoken words, which is what we ask audiences to do during our Powerpoints.* So move those bullet points to your script or speaking notes and use a well-designed data visualization or a great photo.

Law #2: Portion control. The hard truth is that our audience members are going to walk away from our presentation retaining just a few ideas whether we like it or not. If we shower them with ten, twenty, thirty ideas, we don’t control which ones they retain. So choose just a few and weed out the rest. Then feature only one idea per slide. And go easy on the charts, maps, and graphs. They are more difficult to process than photos or illustrations, so give your viewers a cognitive break between charts.

Law #3: Obey visual hierarchy. Remember what Antoine de Saint-Exupery said: “Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” Simplify your slides with one compelling image or one chart, map, or graph (which, itself, has been stripped down to what is necessary). Make sure there is plenty of empty space around the image or chart to give it prominence. Then enlarge only the most important elements while reducing the size of the rest. Similarly, use color sparingly to draw attention to the most important aspects of the slide. And for much more on visual hierarchy, check out this great article on Canva.

* For more on this, check out Moreno and Mayer’s studies on multimedia learning.

Photos by NeONBRAND and Cody Davis 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.

Lighten Cognitive Load, Boost Clarity: Smarter Data Visualizations for Nonprofits

When visualizing data, we should always consider cognitive load. What’s that? It’s the mental effort required to process information. There are two types of cognitive load: extraneous and intrinsic. Let's consider each in relation to data visualizations.

  • Extraneous cognitive load concerns how information is presented. There's a lot we can do to reduce the extraneous cognitive load of a chart.

  • Intrinsic cognitive load concerns the complexity of the information being shared. You can reduce intrinsic load only by altering what is being learned or by changing the knowledge levels of learners.

We can reduce the extraneous cognitive load of any chart through careful choices about titles, annotations, colors, use of white space, etc. But we are much more limited in what we can do to reduce the intrinsic cognitive load of a chart. I’d argue that the primary thing we can do is to choose a chart type that does not increase the intrinsic load by requiring the viewer to learn how to read the chart. So familiar or intuitive chart types usually work best.

Let's consider this data dashboard in terms of cognitive load. It has several different chart types.

The bar charts impose a fairly low intrinsic and extraneous cognitive load. We already know how to read a bar chart. They each show one measure which we probably can understand, such as C02 global share or CO2 per GDP across several years. And the compositions and colors aid interpretation. The cumulative carbon clock, however, is a different story. It may grab our attention with its novelty. It's a radial column chart (aka circular column graph or star graph.) But most of us will have to figure out how to read this chart using the color and shape legends to understand what the chart is showing and how it is showing it. I also find the circular shape, which usually suggests some type of cycle, confusing because there is no cycle inherent to this data. I think the costs of the radial column chart outweigh its benefits.

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 Is Data, How Do You Say It, and Is It Singular or Plural? (Asking for a Friend)

Feel free to share this with your “friend.”

What is data?
Data is raw information—facts, numbers, or observations that haven't been analyzed yet. For nonprofits, this can take many forms, such as:

  • The number of attendees at your last fundraising event,

  • Donation amounts,

  • Volunteer hours logged, or

  • Survey responses from program participants

These are all data points. On their own, they don’t say much. But when you organize and analyze them, they become information—like knowing that donations spike after your newsletter goes out, or that volunteers stay longer when they receive training.

How do you pronounce it?
Americans lean toward day-tuh while Brits and “serious science types” may prefer dah-tuh.

Is it singular or plural?
Purists say data is plural (the singular is datum, a word used only by archaeologists and robots). But in everyday English, data acts like a singular noun. Example: “The data is confusing.” Also valid: “The data are confusing.”

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 10-Charts Strategy

I’ve been noticing a possible trend among news outlets: covering an issue, often a complex one, using ten charts. Here’s an example. This strategy could work well for nonprofits. Organizations can explain a need they are addressing or show their impact during the past year in ten charts. I can see it elevating presentations, websites, and reports because:

  • Just alerting folks that you are going to explain, explore, or enlighten in ten charts seems to pique interest in reviewing each one of the charts, at least briefly.

  • The strategy allows you to shed light on an issue or topic from different angles.

  • Numbered subtitles allow you to provide ten key takeaways with the charts providing more detail for interested readers.

Of course, the charts should be well-designed so that their meaning can be easily extracted and digested. Give it a try. And let me know if you’d like some help with it.

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.

Avoid This Danger When Choosing Metrics

Reposted from July 2019

I’m all about making data clear and easy-to-digest. But there is a danger in it. The clarity may cause you to accept what the data seems to tell you. You may not linger. You may not reflect.

Writer Margaret J. Wheatley warns us that “without reflection, we go blindly on our way, creating more unintended consequences, and failing to achieve anything useful.”

Economist Charles Goodhart recognized this danger in the metrics we create to measure our progress. At first, a certain metric may seem like a good indicator of progress. If we want kids in an after-school track program to increase their endurance, we might measure how far they run at the beginning of the program and then again at the end.  Makes sense, right? We might then try to motivate students by offering them free running shorts if they increase their miles by a certain amount. But, that’s when students might start gaming the system. They can increase their miles not only by training hard and running farther over time but also by running very short distances at the start. This is the kind of unintended consequence that Goodhart warned us about. His law states: “When a measure becomes a target, it ceases to be a good measure.” 

The solution? First, reflection. Consider the potential unintended consequences of each of your metrics, particularly those tied to incentives. Second, use multiple metrics to provide a more balanced understanding of progress.  In our running example, in addition to the change in miles participants run, you might also measure resting heart rates at the beginning and end of the program, knowing that a lower resting heart rate generally indicates a higher level of cardiovascular fitness.

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.

Take Some Tips From The Information is Beautiful Awards

My tip for this week is to check out the Information is Beautiful (IIB) Awards’ longlist of nominees for 2024. IMO, there are some great ones here but also some beautiful-yet-confusing ones. Take a look at the 2024 vizzes in the Humanitarian longlist. I found the following three particularly inspiring. Click on the images below for more information.

Great way to provide context

The circles help us to understand the dramatic reduction in deaths due to natural disasters in the 21st century, particularly in areas harder-hit by disasters in the past, such as Asia. Of course, most of the 21st century is ahead of us, so the size of the circles will change over time.

 

Helpful Color Coding

This data dashboard uses consistent color coding across charts with cool tones indicating type of incident and warm tones indicating gender.

 

Effective Chart Type

Each circle in this beeswarm chart represents one of more than 13,000 incidents where at least one migrant died or went missing. The circle's size indicates the number of people affected. It provides a sobering understanding of the magnitude of the problem over time and across regions.

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 Resources You Should Know: Dabbling in the Data

Here’s a new addition to my highly-curated resources list: Dabbling in the Data. 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?

Dabbling in the Data is a free participatory evaluation guide that provides hands-on, practical group activities and techniques that will help organizations make sense of data. Each of the activities described in the guide includes the types of situations the method is best suited for, step-by-step instructions for facilitators, and suggested adaptations. This guide was expanded in late 2024 with new activities, tools, virtual adaptations, and playlists for mixed methods.

Who’s it for?

Nonprofit manager, evaluators, or anyone who wants to improve the analysis of data by involving multiple interest holders who bring multiple perspectives to the interpretation of data. Group analysis also helps group members to understand the importance of data to their work.

Who’s behind it?

Public Profit, an independent evaluation consultancy that works with nonprofits, foundations, schools, and governments to help them use data more effectively.

Why I think it’s cool

The activities provide both meaningful and fun ways to engage with data. This guide can help anyone in an organization to understand and influence the paths among data, findings, and action.

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

“All creative work builds on what came before.” —Austin Kleon in Steal Like An Artist.

Today I offer up another steal-worthy interactive viz. This one is from the New York Times. See a snapshot of this interactive map (with some embellishments) above but definitely follow the link to give it a spin for yourself. Now, you may be thinking: “The New York Times is the Grand Poobah of data visualization. I can’t do what they do.” But you can! Actually, what they are doing here is pretty simple and can be done easily with drag-and-drop tools like Tableau.

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

  • Make it personal. The map allows you to zoom in on an area of interest to you to see how the issue may affect you or those you know.

  • Multiple perspectives. The map provides three lenses on the location of fatal shootings which help you put the data into context:

    • The number of shootings near each block from 2020 to 2023;

    • The change in shootings since 2016-19; and

    • The racial makeup of areas affected by gun violence.

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.

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.

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.

What's Fundamental to Quality Data?

In their Harvard Business Review article How to Make Everyone Great at Data, Thomas Redman and Donna Burbank describe how companies and nonprofits, despite good intentions, get data wrong due to:

  • the way they enter data into databases,

  • perverse incentives around data, and

  • general distrust of data among employees.

How can organizations get data right? Redman and Burbank sum it up as follows:

I can think of no better way to show staff how the data they collect and input influences decision-making than to visualize that data. Show them a chart with a trend and then ask questions like these:

  • Does this trend look right?

  • Do our data entry procedures appear to have affected the data and thus the trend? If so, what can we improve?

  • What concerns do you have about basing decisions on this trend?

  • Assuming the trend is correct, what might we do differently based on what the trend is showing? What other data would help us to make this decision?

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.