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.

Bar Chart Hack #3: The Combo Chart

60-SECOND DATA TIP_3.png

Reposted from January 2019

Welcome to another episode in the 60-Second Data Tip series, “How to Hack a Bar Chart.” As we have discussed, bar charts are user-friendly and familiar, but like all things familiar, they can be boring and easy-to-ignore. This week we consider—in about 30 seconds— how to combine a bar chart with another type of chart to wake us up and engage us.

Consider the two charts below. Both show the same data: fundraising goals vs. actual funds raised. The one on top uses bars for both categories. The bottom one uses bars for the goals and lines for actual amounts.

Which works better? I vote for the bottom one. It makes comparing values between two different categories easier because it uses not only different colors to distinguish them but different “encodings” (bars and lines).  The bottom chart gives us a clear view of when we are exceeding or falling short of our goals in any given month.

combo chart image.png

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.

Bar Chart Hack #2: The Icon Bar Chart

60-SECOND DATA TIP_3.png

Reposted from January 2019

Welcome to Episode 2 of “How to Hack a Bar Chart.” This mini-series shows you how to take something that works well and that folks understand and move it in a more creative and engaging direction. This time, you meet a close cousin of the bar chart, but this cousin is more interesting than its relative. It has icons.

This is what you should NOT do with icons: make them into bars. Here’s why: bar charts are powerful (if boring) because we can easily compare their lengths. When icons or images are used in place of bars, such comparisons are more difficult to make. See the first example below showing how many clients live in different types of homes. It’s quite a challenge to determine how many more clients live in suburban homes vs. high rises. That’s because the height of the icons are difficult to assess.

2.png

The second example makes it a little easier. But I’d argue that in both examples 1 and 2, the icons make the viewer’s job (comparing lengths) unnecessarily difficult.

3.png

The third example, introduces bars back into the bar chart and thus requires minimal viewer effort.

60-SECOND+DATA+TIP_3+%281%29.jpg

And the fourth further lightens the load by removing the Y-axis and directly labeling the bars and placing the bars closer together.

5.jpg

To see past data tips, click HERE.

Image credits: House by ANTON icon from the Noun Project, company by Angriawan Ditya Zulkarnain from the Noun Project, Farm by Ferran Brown from the Noun Project

Let’s talk about YOUR data!

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






Bar Chart Hack #1: The Divergent Stacked Bar Chart

60-SECOND DATA TIP.png

Reposted from January 2019

Last week I promised to arm you with useful bar chart hacks. The idea is to take something that works well and that folks understand but move it in a more creative and interesting direction.

So this week I give to you: The Divergent Stacked Bar Chart.

Okay, so you know what a bar chart is. And you probably know what a stacked bar chart is, even if you don’t call it that. It uses color to show the subgroups that comprise each bar (or larger group) in the chart like this:

bar.png

Regular Stacked Bar Chart

Now the cool, or divergent, part. It’s easier to show you than to describe it. So take a look:

returnstohomelessness.jpg

Divergent Stacked Bar Chart

As you can see, the the divergent chart aligns each bar around a common midpoint. So it’s much easier to compare, for example, positive and negative values across categories.

Stephanie Evergreen provides directions on making a divergent stacked bar chart in Excel. And here are instructions on creating such a chart in Tableau. Other data viz softwares can make this chart too.

For a much deeper dive into the data viz world’s debate over when and if to use divergent stacked bar charts, check out this article by Daniel Zvinca.

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 Hack A Bar Chart

Reposted from January 2019

Choosing a chart type is like making breakfast for your kids. Bar charts are Cheerios. You know they will eat it and it’s healthy. Now come the buts:

But #1:  Cheerios is boring and you wish they had a wider palate.

But #2: If you give them a quinoa breakfast bowl, it will go uneaten and you might as well have given them Cheerios.

When it comes to data visualization, Maarten Lambrechts says don't settle for Cheerios. He calls the problem “xenographobia” or the fear of weird charts. And he implores us to boost our viewers’ “graphicacy” by feeding them the equivalents of quinoa breakfast bowls in the chart world.

Here’s what I think. We should neither spook our children at breakfast time nor our funders, board members, and staff throughout the day. But we should try to slowly widen their palates. One way to do that is to take something they know and love and hack it a bit. Throw some nuts on the Cheerios. Use color in novel ways to enliven a bar chart.

Over the next several weeks, I will offer up different ways to hack a bar chart. Stay tuned!

To see past data tips, click HERE.

Let’s talk about YOUR data!

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


Ideas You Should Steal From This Viz (Installment 7)

Today I offer up yet another steal-worthy viz: Emergency Calls Dashboard created with Tableau by Pradeep Kumar G. This one is genius. It seems to defy basic graphic design rules. It includes many charts and lots of small text and numbers and yet it’s readable and not overwhelming.

As you can see, the charts are contained within four rectangular views, each with the dimensions of a phone screen. Tableau dashboards can include layouts for different types of devices with varying screen sizes. When you publish these layouts, people viewing your dashboard experience a design optimized for their device (phone, tablet, or desktop.)

If you view the Emergency Calls Dashboard with a phone, you will see just one of the four views and can use the icons at the bottom of the screen to navigate to the other views, as shown in the image to the right.

Effective phone layouts usually:

  • Limit a dashboard’s focus and content (you can only get so much on this small canvas),

  • Reduce interactivity (dealing with filters on a phone can be annoying*), and

  • Use a vertical orientation (vertical scrolling is easier than horizontal scrolling).

The Emergency Calls Dashboard has all of these features, so the phone view works quite well. Indeed, these phone views are so effective that they also work when laid out side-by-side in the desktop view.

When building dashboards for multiple device types, dashboard designers often start with the desktop view and then simplify that larger, more detailed design for the phone view. The Emergency Calls Dashboard demonstrates the benefit of beginning with the phone view. If you design a simple, readable phone view that makes effective use of its limited canvas, you can use this design to fit more information in the desktop or tablet layout. Even if you aren’t designing for multiple screen sizes, following the tips for effective phone layouts will serve you well, opening up possibilities for including more data in one view without overwhelming the user.

I’ve embedded the dashboard below so that you can interact with it.

*The Tableau Mobile app optimises filters for phones, making them pop and easier to use. It also allows for logical scrolling, swiping, pinching, and zooming. However, some of your users may not use the app.

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 Your Data Viz More Accessible: Screen Readers and Keyboard Navigation

In a series of 60-second data tips, I’m taking on one basic accessibility issue at a time. This week it’s about screen readers and keyboard navigation. We do not all perceive in the same way. Some people with vision or physical limitations, navigate charts, graphs, and maps using only the keyboard (no mouse) and screen readers to understand the content.

A screen reader is an assistive technology primarily used by people with vision impairments. It converts text, buttons, images and other screen elements into speech or braille. Here’s one in action:

Source: Highcharts on YouTube

You can make your data visualizations more screen reader- and keyboard-friendly by doing the following:

1) Understand the capabilities of the tool you use to create visualizations.

Some simple Googling can help you to figure this out. For example, if you use Tableau, this page explains that once you publish and embed a Tableau dashboard into a web page that conforms to Web Content Accessibility guidelines (WCAG 2.0 AA), screen readers should be able to interpret them. Further, dashboards created in Tableau 2021.3 and later have a default top-to-bottom, left-to-right “focus order” (i.e. the order in which elements of a visualization are narrated by a screen reader).

2) Reduce the number of marks in visualizations.

Marks are the visual elements used to represent data in a chart, graph, or map. Think bars, lines, circles, etc. When there are a lot of marks, it can be difficult to understand a visualization using a screen reader. You can reduce the number of marks by:

  • Including only the most important data points,

  • Aggregating data points into groups (e.g. rather than showing the population of 40 cities with 40 bars, you could group them into small, medium, and large cities and show just three bars representing the average population for each group), and

  • Adding filters that allow the user to see fewer data points at a time.

3) Add text that clarifies the content of the visualization

Titles, subtitles, captions, and legends make a visualization more accessible to everyone including those using screen readers.

If you are interested in a deep dive into accessibility issues and solutions, you can find plenty of information online including Chartability.

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 Your Data Viz More Accessible: Color Blindness

In a series of 60-second data tips, I’m taking on one basic accessiblity issue at at time. This week it’s color. About 1 in 20 people have color blindness meaning that two colors which appear distinct to a person with normal color vision may appear to be the same to a person with color blindness. There are different types of color blindness (as shown above), but the most common is red/green color blindness (aka deuteranopia). Becasuse color plays an important role in many data vizes by drawing attention to certain trends, distinguishing among categories, or illustrating relationships, we should be careful in choosing colors to make our visualizations accessible to more people.

Some data viz tools, such as Tableau, have built-in colorblind palettes. You can also generate an accessible color palette using an online generator like this one from Venngage.

If you are interested in a deep dive into accessibility issues and solutions, you can find plenty of information online including Chartability.

To see past data tips, click HERE.

Sources: Coloring for Colorblindness, Build Accessible Dashboards by Tableau, Accessible color palette generator by Venngage

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 The Right Text Size to Make Data Viz Accessible?

Here’s another in a series of tips on how to make data visualizations accessible to audience members with issues that affect their ability to see or interact with a visualization. This week it’s text size.

The rule of thumb is: Text must not be smaller than 9 point in size. Ideally only minor text is rendered at 9 point (e.g. axis labels) while all other text is larger. The viz below has a lot of text, and most of it is 9 point. To increase its accessibility, I might increase the key sentences in the captions to 11 point. But, at the least, I’d bump up the 8 point text, near the bottom, to 9 point, which is what you see in the “After” version below.

If you are interested in a deep dive into accessibility issues and solutions, you can find plenty of information online including Chartability.

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 Your Data Viz More Accessible, Tip#1

If you are trying to reach a large audience with your charts, maps, and graphs, then consider accessibility issues. Even if your data viz is meant for a small, specific audience, you may not be aware that certain people in the group are, for example, color blind or have other issues that affect their ability to see or interact with a visualization.

If you are interested in a deep dive into accessibility issues and solutions, you can find plenty of information online including Chartability. In a series of 60-second data tips, I’m taking on one basic accessibility issue at at time. This week it’s contrast.

Data visualizations must be perceivable to be accessible. This means that users can readily identify content using their senses: sight, sound, and touch. When the contrast between the critical content and the background or adjacent colors is low, the content can be difficult to perceive for some people. So shapes and large text should have more than a 3:1 contrast against background or adjacent content, and regular text should have more than a 4.5:1 contrast. Here’s a tool to determine contrast ratio.

The colors in the first stacked bar chart below have low contrast to each other (less than 2 to 1) and so some may have difficulty distinguishing among the bar segments. The second stacked bar chart, by contrast (pun intended), has a higher ratio (3 to 1) and thus is much easier to perceive.

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: Data Visualisation Catalogue

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

It’s simply a list of chart types with definitions. You can use it like you would a bird guide: you come across a chart you’ve never seen before in the wild and want to know more about it. In this case, you can review the chart icons in the “View by List” page to find one that looks like the one you’ve encountered. Or you can use it like you would a menu: you want a chart but are not sure what your options are. In this case, you can use the “Search by Function” page to find chart that best suits your purpose.

Who’s it for?

Anyone who wants to know more about charts.

Who’s behind it?

Severino Ribecca, a freelance designer in Poland, built and maintains the catalogue along with a blog on various data viz topics.

Why I think it’s cool

I love the simplicity of this site. There are other chart choosers online (easily found with a little Googling) but I find myself going back to this catalogue again and again when I need more information on a chart because it’s so user-friendly.

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: Tableau Tim

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

Tableau Tim and Tableau Tim You Tube are treasure troves of videos on Tableau, a powerful tool for visualizing data in the form of interactive charts, graphs, and maps. These collections include how-tos, introductions to new functions in Tableau, quick tips, etc.

Who’s it for?

It’s really for anyone interested in learning more about Tableau, from the absolute beginner to the absolute veteran.

Who’s behind it?

Tim Ngwena is an analytics professional based at The Information Lab in the UK and a Tableau Ambassador from 2020-21.

Why I think it’s cool

Tim is what’s cool. He is an extremely good explainer. If you don’t know anything about Tableau, check out his video called Tableau explained in under 10 mins! And if you are looking for free Tableau training, you might check out his Tableau Desktop Crash Course which takes you for zero to a published dashboard in three hours.

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: We All Count

In my IRL and virtual travels, I’ve come across many cool resources both for those wanting to stick their toes in data viz (and related topics) and those ready to dive into the deep end. So I’ve been thinking about creating a resource list on my website. The problem is: I sort of hate resource lists. They usually overwhelm me. They offer up too many resources which are poorly described or not described at all. And I end up hopping into a bunch of time-sucking rabbit holes and emerge cranky.

So I’m going to try slowly building a highly-curated resource list through 60-Second Data Tips. I will occassionally write a tip describing a particular resource, including why I think it’s cool. And I’ll link each of these tips to a resource list on my website. My first recommended resource is: We All Count.

What is it?

We All Count is a project to increase equity in data science. Data equity, according to We All Count, involves “principles of fairness, transparency, inclusion and justice regardless of who may be experiencing them. Overt or unintentional racism, sexism, classism, heteronormativity, colonialism, ableism, ageism, and religious intolerance are just a few factors that can skew the equity of any data project.” We All Count does its work through:

  1. A data equity community including a newsletter and community forum;

  2. Developing tools, case studies, practices, and systems to improve equity in data science including the Data Equity Framework which is a systematic way of looking at data projects;

  3. Training people in how to bring data equity to their work; and

  4. Consulting with organizations on data equity issues.

Who’s it for?

It’s mostly for data scientists looking for ways to collect and analyze data in a more equitable way. However, the site has some great tools for nonprofits concerned about using data more equitably including a Data Jargon Decoder. They also offer a series of free webinars about current issues in data science which sometimes include topics of interest to anyone dealing with data, not just data scientists. And you can ask questions about how to collect, interpret, and present data in an equitable way on their online forum.

Who’s behind it?

Heather Krause started We All Count. Heather is a mathematical statistician with experience working on complex data problems and producing real-world knowledge.

Why I think it’s cool

We All Count is focused on practical solutions to knotty data equity issues. They don’t just complain. They offer up real-world solutions to issues such as how to collect demographic data on surveys.

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, open (i.e. free) data, data privacy, etc. See a full list of events HERE.

Where can I learn more?

HERE.

To see past data tips, click HERE.

Let’s talk about YOUR data!

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

Before Showing A Percentage, Read This

Reposted from October 2021 (And yes, I know that the percentages > 100%, that’s the joke. . . .)

Here’s what I’m going to do in 60 seconds today:

  • Give you three percentages. They might be the type of percentages that you share in proposals, reports, your website, or in social media posts.

  • Give you the backstory on these percentages.

  • Convince you to think carefully next time you want to present a percentage.

Here goes.

#1: Two percent of clients in Program A dropped out in the first three days of the program.

#2: 60% of first time donors in March made a second gift.

#3: 25% of people who attended our XYZ event said that they were unlikely or very unlikely to recommend the event to others.

And here is the backstory on each of the percentages:

#1: Two percent of clients in Program A dropped out in the first three days of the program. Backstory: There were 50 participants in Program A. That means only one person dropped out.

#2: 60% of first time donors in March made a second gift. Backstory: There were 5 new donors in March. That means that 3 made second gifts.

#3: 25% of people who attended our XYZ event said that they were unlikely or very unlikely to recommend the event to others. Backstory: Eight people attended XYZ event. That means two people provided the low rating.

Did the backstories cast a different light on the percentages for you? Perhaps you were imagining more people were involved? When the numerator or the denominator is fairly small, it’s usually best to present both in raw numbers rather than give a percentage. The raw numbers present a clearer understanding of the situation that you’re trying to describe. In fact, when numbers are small, percentages can be downright misleading.

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.

9 Ways to Make Your Data Visualizations Stand Out

Data visualizers from around the world flex their muscles each week by creating charts, maps, and graphs using a common data set. It’s called Makeover Monday. Even if you don’t participate, it’s a great way to see the range of ways a single data set can be visualized and to consider the pros and cons of different approaches. Check out the Makeover Monday site which provides a wealth of information from past Makover Monday challenges including favorite vizes associated with each challenge. The Makeover Monday folks also shared this “Viz Checklist” with the world. And I’m offering it up as this week’s data tip. Use it next time you visualize data to ensure a polished result.

Source: https://www.makeovermonday.co.uk/

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 and How To Use Free Data

There’s a treasure trove of free data out there. And I know what you are thinking: “I can barely deal with my own data much less anyone else’s!” But think again. What if you could show the need for your services, your potential audiences, or other factors that affect your work without having to collect any data yourself?

Here’s an example of something you might do. I downloaded free data (in the form of an Excel spreadsheet) from the U.S. Department of Agriculture’s website on food access in 2019. I then combined this data with a list of counties that a (fictional) organization serves in Illinois to create the map below.

You can find any number of websites with lists of free data sources, such as this one. I found the USDA data by following the link from this page to Data.gov which is home to the US government’s open data.* I then clicked on “Data” on the navigation menu and searched for the topic of interest to me.

Fair warning, when searching for free data online, you are likely to find yourself in quite a few rabbit holes. So here are a few tips to make your search more fruitful:

  • Before you begin searching, know what you are looking for. Consider what geographies, time periods, or populations you need. Also, think about what data format you need. Perhaps you can only deal with Excel or CSV files. When visiting a free data site, determine if any of the data files available for download meet your needs asap. If it’s not clear, then give up and try another site.

  • If you need local data, check out your city government’s website. Many have open data available for download.*

  • Look for a data dictionary or some other type of documentation to understand what is included in the data, how the data was collected, and what each data field means. Sometimes this is included on a tab in the downloaded data file. Pay attention to what might be missing from the data and the biases that could be baked into it.

  • Link back to data sources (or attribute with text) when showing the data in charts, maps, and graphs.

  • Combine free data with your own data using zip codes, city names, census tracts or other data fields to link the two data sources.


    * Open data is data that can be freely used, re-used, and redistributed by anyone, subject only, at most, to the requirement to attribute and share-alike.

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

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

Ideas You Should Steal From This Viz (Installment 6)

Today I offer up yet another steal-worthy viz called “Flags of Inequality” created by Rita Costa and Beatriz Malveiro. Below is a partial view of the viz. But to have the whole experience and to see why I think it’s so great, click HERE.

The magic in this viz is the way the creators lead you through the meaning of each color. Color legends don’t get much attention in most vizes. But this viz guides you through the legend before showing you any data at all. It works well because, while the pride flag may be familiar to us, the various types of LGBTI equality laws and policies represented by the colors may not be. So the viz first grounds us in the meaning behind the colors so that we can fully appreciate the flags and make comparsions among countries. If you have data with complex or unfamilar categories, starting with the color legend might be a good idea.

To see past data tips, click HERE.

Let’s talk about YOUR data!

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

Best Data Viz of 2022

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

New York Times

Toward Data Science

Vox

FiveThirtyEight

FlowingData

To see past data tips, click HERE.

Let’s talk about YOUR data!

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