One Of The Most Popular Data Viz Technologies May Surprise You

According to the State of The Data Viz Industry Survey, the percent of respondents who used “pen and paper” to create charts, maps, and graphs ranged between 25 and 31 percent from 2019 to 2022 but then shot up to 58 percent in 2023 and 60 percent in 2024. This was the biggest increase of any of the technologies including Power BI, Tableau, and Excel. With so many applications out there to create sleek data visualizations, why are so many drawn to this low-tech, old-school technique?

The short answer is: I don’t know. But I have some ideas . . .

Hand-drawn visualizations are relatable.

We humans seem to be drawn to anything that suggests humanness. Pata Gogova’s What is (not) love? visualization mixes hand-drawn elements with charts created with Tableau to effectively draw our attention to certain aspects of the visualization. “A handmade visualisation can lend a feeling of friendliness to a story,” notes Amelia McNara, “Quite often, computer-generated visualisations feel sterile and can be inaccessible to certain audiences.”

Hand-drawn visualizations suggest uncertainty.

In her Ted Talk called 3 Ways To Spot A Bad Stat, Mona Chalabi emphasizes the importance of showing uncertainty when presenting data. She does that by using hand-drawn charts like the one below. Its unpolished look perhaps prevents viewers from unconsciously accepting what is shown. The result may appear more honest than a sleek presentation with all the requisite disclaimers about the limitations of the data in small type below the chart.

Hand-drawn visualizations aid exploration.

They aren’t limited by an application’s capabilities and thus allow you to think outside the box plot, bar chart, or line graph. And, as Stefani Posavec and Georgia Lupi (who have written several books on visualizing personal data by hand) note, drawing aids memory. Even if you end up visualizing your data digitally, beginning with a pen and paper will help you to explore and absorb your data.

Source: flickr

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.

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.

Context is King

Reposted from July 2023

This “sketchplanation” elegantly demonstrates the importance of context in understanding anything. Since data visualizations are supposed to help people understand something, we should pay close attention to context when creating them, adding as much context as is needed for others to appreciate what’s going on and act on it. Considering the following charts . . .

Low-context chart

This is your garden variety chart. I see them all the time. Sure, it provides some context by comparing clients served in different zip code areas. But it doesn’t give me enough context to understand if these numbers are high, low, or somewhere in between. This chart needs more context.

Moderate-context chart

This chart is better than the one above. By providing the previous year’s numbers, we can see where there has been increases and decreases and how large and small they were as well as compare the number increases (3) to the number of decreases (1).

Moderate-context chart

This chart, too, allows for better assessment of the numbers than the first chart did. By simply adding a reference line for the goal, we have a better understanding of what’s going on and where we might need to take action. A reference line showing the average number of clients per zip code might also be helpful.

High-context chart

This “small multiples chart”* gives us much more context by showing how the current numbers compare to past years. Consider, for example, the trend for 60601. Just knowing the current and past years’ numbers would not give you an appreciation of the overall upward trend.

*Small multiples chart: a series of similar graphs or charts using the same scale and axes, allowing them to be easily compared

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 Pies That Bind

Reposted from November 2022

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

Let’s talk about YOUR data!

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

Featured
044-CcCS-bIy_ss.jpg
Hi, I'm Amelia.

Ideas You Should Steal From This Viz (Installment 14)

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

Today I offer up another steal-worthy viz that I came across in the Tableau Public Gallery. All nonprofits need to understand and show the demographics of their participants or the communities they serve. This dashboard of South Korea’s demographics uses some good strategies you can apply to your organization’s charts and maps. Keep scrolling to examine the dashboard and see my suggestions on what to steal from it.

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

  • Heat = Density. The map uses warmer colors to show higher population density and cooler colors to show lower density. This makes finding the big population centers easy.

  • Charts for key demographics. A quick review of the charts on the right gives you a clear understanding of demographic trends over time.

  • Chart title as color legend. Using the chart title to explain the color coding in the chart is a great way to save space on small charts.

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 Resources You Should Know: Visual Capitalist

Here’s a new addition to my highly-curated resources list: Visual Capitalist. 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?

Visual Capitalist is an on-line publisher of data visualizations. Their aim is to make the world’s data more discoverable. As the name suggests, the visualizations primarily focus on markets, technology, energy, and the global economy but also on education, healthcare, and the environment using public sources of data including government entities (i.e. U.S. Census data, FRED, etc.), intergovernmental organizations (IMF, World Bank, etc.), or established thought leaders in their respective sectors (think tanks, non-profits, corporations).

Who’s it for?

Anyone who wants to understand or show information on markets, technology. energy, healthcare, education or the global economy. They allow much of their original visual content to be used by others. In many use cases, this can be done for free. (See more info on using their content.)

Who’s behind it?

Visual Capitalist is independently owned, with its founder, Jeff Desjardins, as a majority shareholder.

Why I think it’s cool

Their visualizations can be quite engaging with high production values. You can share them on social media for free. Sign up for a free subscription on any page of their website to get one in your email box each day.

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.

Behold the Heated Bar Chart

I’ve come across this useful chart a number of times and have yet to find a name for it. So I’m giving it one: the heated bar chart. If a bar chart and a heat map had a baby, it might look like this and be even more powerful than its useful parents. This heated bar chart shows months along the horizontal axis and days of the week along the vertical axis. Darker and longer bars on the two bar charts and darker cells on the heat map show when there has been the highest participation in hours. This allows us to examine patterns in participation. We can see, for example, that the relatively high participation in May is being driven by participation on Mondays during that month but that Monday was not a particularly high participation day during other months. We can also see that, overall, participation was lower during the fall months, regardless of day of the week.

This powerful combo chart can be used with many different types of data fields. For example, you might want to create one showing the number of participants from different gender identity and age groups to see if certain gender groups within certain age brackets are not well represented among your participants.

I made this chart with Tableau Public, the free version of Tableau. But this type of chart can be created with any number of applications. For those of you with at least a little Tableau know-how, check out the steps I took in the comic strip 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.

Data Viz Dangers: Hiding Variability

Data visualization has its pitfalls and landmines. Sometimes charts, graphs, and maps can have harmful consequences, intended or not.  So I’m offering up another tip in a series of 60-Second Data Tips that point out pitfalls and landmines to avoid. This time, it’s about hiding variability.

If we see a bar chart like the one below showing median income of Medicare beneficiaries by demographic group, we may make the following mistakes in interpreting it:

  • Assume that all or most of those in the higher income groups are earning more than all or most of those in lower income groups rather than assume that there may be more variation in income within groups than between groups.

  • Assume that the higher median income of a given group suggests that those in that group are more capable, smarter, skilled, etc. than those in lower median income groups rather than assume that those in the lower group faced challenges (e.g. racism, lack of education, etc.) that resulted in the lower median income. (This is called the fundamental attribution error.*)

  • Generalize our error-ridden conclusions about the people represented in the chart to all of those in certain racial, age, gender, or other demographic groups.

Eli Holder and Cindy Xiong conducted studies in which they showed participants charts that emphasized within group variability as well as those that did not like the chart shown above. And they found that participants were less likely to make the mistakes listed above when shown charts that emphasize within group variability such as the one below which shows that there is a lot of variability in scores within schools that one can’t appreciate by only looking at averages (represented by the black horizontal bars.)

Source: Jitter Plots in Tableau, by Ashish Singh

For a great ten-minute summary of the research, check out this video. What to do to avoid this pitfall? The video suggests that we find ways to represent variability within groups as shown below:

To see past data tips, click HERE.

*When visualizing data, we should consider how humans think including heuristics (i.e. mental shortcuts) and biases. Some of them have particular relevance to data visualization such as the fundamental attribution error, which is our tendency to relate behavior to a person’s character and personality rather than to the person’s context. So when someone cuts you off in traffic, if you write them off as a jerk rather than someone who is late for work or distracted, that’s the fundamental attribution error.

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

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

Today I offer up another steal-worthy interactive viz that I came across in the Tableau Public Gallery. Scroll down to see what you should steal from it.

Source: Nir Smilga on Tableau Public

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

  • Small Multiples. To highlight each country and to allow for easy comparisons across countries, Smilga created one small chart per country and placed them alongside each other, aka a “small multiples chart.”

  • Gray comparison trends. While Smilga highlights the trend for the featured country in each chart using color, the trends for other countries are also in each chart but in a light gray. This allows us to easily compare the trend for the featured country to that of others in general.

  • Color distinguishes trend types. Recent downward trends are highlighted in red, and recent upward trends are highlighted in blue.

  • Choose your view. Smilga allows the viewer to customize the view by selecting the number of columns, time period, and countries shown.

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 Make Data Viz Accessible

Data visualization is the translation of data in the form of words and numbers to a visual format, using color, size, shape, and placement to convey trends and patterns in the data which can be much less apparent when looking at tables of numbers or words. Thus data viz communicates best to those with full visual capabilities. To make charts, graphs, and maps accessible to those with visual impairment, we must translate the meaning of a visualization back into words, which can be a challenge. Amy Cesal's article, Writing Alt Text for Data Visualization, can help us address that challenge.

Alt text is a brief description meant to provide the meaning and context of a visual item in a digital setting. And although Cesal notes that, in most cases, it’s impossible to write something short that conveys the whole meaning of a visualization, she maintains that an incomplete description is better than none at all. Here are Cesal’s simple guidelines for alt text for data viz:

Chart type: It’s helpful for people with partial sight to know the chart type. This information provides context for understanding the rest of the visual. Example: Line graph.

Type of data: What data is included in the chart? The x and y axis labels may help you figure this out. Example: number of clients served per day in the last year.

Reason for including the chart: Think about why you’re including this visual. What does it show that’s meaningful? There should be a point to every visual and you should tell people what to look for. Example: more clients are served during the winter months.

Cesal also suggests that you include a link to the raw data somewhere in the surrounding text.

For a deeper dive into this topic, checkout Image Description Guidelines from the Diagram Center.

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 Common Problem with Survey Data - And How to Avoid It

Sampling bias occurs when some members of the group you are trying to understand are less likely to be included in your data than others. Survey data is especially vulnerable to sampling bias. The data you collect is often not representative of the whole group that received the survey but rather the subgroup that was willing to complete the survey — as illlustrated in the “sketchplanation” above. So here are some quick tips to avoid this type of bias in your survey data:

  • Clearly define the group and related subgroups that you want to understand. Consider what might be necessary to collect sufficient data from all of the subgroups.

  • Follow up with those who don’t respond to the survey to understand why they didn’t respond. Did you ask the wrong questions or target the wrong audience? Apply these insights next time you are planning a survey.

  • Make your survey brief and easy to understand.

  • Finally, don’t overinterpret your survey date. Assess which types of respondents were the least likely to respond and interpret accordingly.

For a fuller explanation of types of sampling bias and strategies to avoid it, check out this SurveyMonkey article.

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 Create Data Stories That Actually Engage People

Here’s a sneak preview of a workshop I’m doing on September 26th. I’m sharing the first few slides below. Click on the right to advance through them.

Presentation Preview by Amelia Kohm

To tell a story in a way that humans can understand and get behind, it helps to understand humans’ powers and challenges when it comes to consuming data. Then we can make better charts, maps, and graphs (aka data visualizations) and present them in a way that humans can absorb.

I hope you can join me on September 26th, 8:00 am - 9:00 am PT | 11:00 am - 12:00 pm ET. Click HERE to register.

Let’s talk about YOUR data!

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

Add This To Make Your Charts Memorable

Copy of 60-SECOND DATA TIP_3.png

Reposted from October 2019

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

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

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

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

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

Sources:

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

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

 Photo by Nery Zarate on Unsplash

Let’s talk about YOUR data!

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

When to (and NOT to) Use a Map

Copy of 60-SECOND DATA TIP_3.png

Reposted from December 2019

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

1) Your audience already knows the geography.

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

Source: Bloomberg

Source: Bloomberg

Source: Brilliant Maps

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

Source: Brilliant Maps

Source: Brilliant Maps

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

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

Source: Brilliant Maps

Source: Brilliant Maps

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

Let’s talk about YOUR data!

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

Charts That Changed The World

This week’s tip is to check out this video from The Royal Society in which Adam Rutherford shares five data visualizations that have changed the world. Admittedly, this will take you more than 60 seconds to watch (it’s 6 minutes). But it’s worth it. Rutherford shares four classic charts. Two of them clarified a problem so well that they led to solutions. He also shares a chart that drives home the dangers of visualizing lies and thus making them look legitimate. If you’d like to learn more about these charts, I’ve included links below the video. Enjoy!

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 Improve Your Organization’s Time Line

Reposted from March 2022

Here’s a simple data viz idea. Next time you make a time line showing your organization’s milestones, size those milestone markers (usually circles) according to some key measure. Voila! You are not only showing what happened but also your progress along the way.

The data for such a viz is super simple. Something like this:

Screen Shot 2021-08-24 at 9.01.48 AM.png

I connected the data shown above to Tableau Public (the free version of Tableau) to create the time line below. Vertical time lines not only suggest an upward progression but also work better on phone screens.

Dashboard 1 (3) (1).png

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

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.

Data Viz Pitfalls and Landmines: Polarization

Charts, maps, and graphs can be great tools for illuminating trends and patterns in data. But data visualization has its pitfalls and landmines. Sometimes charts, graphs, and maps can have harmful consequences, intended or not. So I’m starting a series of 60-Second Data Tips that point out pitfalls and landmines to avoid. This time it’s about polarization.

When visualizing data, we should consider how humans think including heuristics (i.e. mental shortcuts) and biases. That’s a tall order given how many shortcuts and biases affect our thinking. See Diagram B below. Some of them have particular relevance to data visualization such as conformity bias, which is the tendency to change one's beliefs or behavior to fit in with others. Can data visualization exacerbate this bias?

You are likely familiar with charts showing U.S. attitudes toward public policies which highlight the gap between Democrats and Republicans. Researchers conducted experiments to explore whether such charts invoke viewers’ social-normative conformity bias, influencing them to match the divided opinions shown in the visualization. In three experiments described in Polarizing Political Polls: How Visualization Design Choices Can Shape Public Opinion and Increase Political Polarization, researchers either aggregated data as non-partisan "All US Adults," or partisan "Democrat" / "Republican." (See Diagram A) They found that the partisan charts tended to increase viewers’ polarization while the non-partisan charts did not, leading the researchers to conclude that visualizing partisan divisions can further divide us.

So when showing differences of opinions across various groups, we should take this finding into consideration. Is our ultimate aim to divide or unite?

Diagram A

Diagram B

Source: https://upload.wikimedia.org/wikipedia/commons/c/ce/Cognitive_Bias_Codex_With_Definitions%2C_an_Extension_of_the_work_of_John_Manoogian_by_Brian_Morrissette.jpg

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 Visualize Cycles

Reposted from April 2022

Every organization experiences cyclical or seasonal patterns. Understanding how funding, participation, volunteering, and other factors change in predictable ways over time can help us to plan for the future. The problem is that we don’t always see these patterns. We get caught up in current issues and crises, and it’s hard to step back and see what’s coming next. Visualizing your data can reveal cyclical or seasonal patterns in helpful ways. This often involves aggregating data from multiple years by specific time periods such as season, quarter, or day of the week. Here are some examples.

Working with a statistician named William Farr in the 1800s, Florence Nightingale analyzed mortality rates during the Crimean War. She and Farr discovered that most of the soldiers who died in the conflict perished not in combat but as a result of “preventable diseases” caused by bad hygiene. Nightingale invented the polar area chart (shown below), a variant of the pie chart, meant “to affect thro’ the Eyes what we fail to convey to the public through their word-proof ears.” Each pie represented a twelve-month period of the war, with each slice showing the number of deaths per month, growing outward if the number increased, and color-coded to show the causes of death (blue: preventable, red: wounds, black: other). The New York Times showed the seasonal pattern of COVID cases using a somewhat similar chart.

Source: Wikipedia

In the dashboard below, Curtis Harris reveals not only patterns in taxi rides by time of day but also by day of the week. We can see, for example, that few people are using taxis between 2 and 3 am, particularly at the beginning of the week. (Click on this viz to see interactive version.)

Source: Curtis Harris on Tableau Public

This varsity-level viz (below) by Lindsay Betzendahl shows the seasonality of the flu. Each dot represents one week in a particular year. Each “ray” consists of dots for the same week of different years. So the ray at the 12:00 position represents the first week in January for each year between 2007 to 2018. The size of the dots show the number of influenza cases. So we can see that cases surge during the winter weeks, in general, but we also can see outbreaks during other seasons in particular years. Betzendahl explains how to create such a chart in Tableau here.

Source: Lindsay Betzendahl 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.