Menu

Alison Pitt

×
A faded map in the background, with the Viz for Social Good logo on top

Viz for Social Good wanted to get to know their volunteers, and so did I

Surveys and heat maps: Viz for Social Good 2021

Alison Pitt January 13, 2022

For the last two years, Viz for Social Good has ended the year with a project looking at its volunteers. Last year, it was all about the projects and who submitted them, and this year, it was looking at the results from an org-wide survey.

As some of you know, I was job seeking for most of 2020, so when I got a new job in 2021, a few things stopped. One of those things was my participation in Viz for Social Good. Suddenly I was juggling a full-time job, a side hustle, and trying to find time to viz on the side of the side hustle. Tough stuff.

But! I retooled my side hustle’s business model to free up my time (maybe another post on that another time!) and when the 2021 VFSG survey project rolled around, I dove in. (Scroll to the end of this post for the full viz.)

I won’t explain all my thought processes here, but suffice to say that even if I’m doing a quick viz, I try to do three things:

  1. Pleasing color

  2. Tidy, “finished” format

  3. Something interesting in a viz

This time around, the “something interesting” was heat maps.

When I started looking at the survey results, I realized that looking at the two metrics gender and age could be misleading. Taken separately, they could mischaracterize the “average” volunteer. Consider the following:

 

A table showing “respondents”, with their ages and genders

 

In this table, we can see 20 sample responses. If you chart ages and genders separately, you get:

A bar chart showing the number of “respondents” by age group

A bar chart showing the number of “respondents” by gender

Check it out! Most respondents were male, aged between 18-25. Right?

Not exactly.

When you put the two metrics together in a heat map, the interpretation changes pretty sharply:

“Respondents” by age and gender

The most populous group here is women between 36 and 50, very much not men between 18 and 25. In reality, the men were more evenly spread in age, which is why they came out tops in the total. Women, in this case, were concentrated in age.

So does that mean you should do everything as heat maps? No! But it should be a consideration when you’re presenting your results. Are you arguing that VFSG should advertise on Joe Rogan? Might be worth knowing your demographic is middle-aged women, not young men! But if you’re just debating whether to spend your ad budget on men or women, just the straight gender total will do.

In my case, I chose three heat maps:

  1. Age and gender

  2. Job title and experience

  3. Hours vizzing at work vs hours vizzing for VFSG

These were the comparisons that worked for what I wanted to show, so that’s what I went with.

Plus, it worked for the design.

Check out the final viz on Tableau Public, or below.

In Data Viz
← Putting my money where my mouth isHumbled and surprised →

Search

No results found
Post Archive
  • May 2024 1
  • September 2023 1
  • June 2023 1
  • May 2022 1
  • January 2022 1
  • October 2020 2
  • September 2020 2
  • August 2020 2
  • July 2020 7
  • June 2020 4
  • November 2017 5
  • October 2017 4
  • September 2017 4
  • August 2017 1

Featured Posts

Featured
How to Set up a 2-Record Seed to do Math in Tableau
Data Viz
How to Set up a 2-Record Seed to do Math in Tableau
Data Viz

When you’re exploring math concepts in Tableau, you don’t necessarily need a full data set to do it. Here’s how to use a 2-record seed to create an expanding data set for all your math exploration needs (in my case, learning about triangular numbers).

Read more →
Data Viz
An Exploration of Incomplete Open Cubes
Data Viz
An Exploration of Incomplete Open Cubes
Data Viz

For a recent JLL viz challenge and Iron Quest, I explored an Alteryx + Tableau recreation of Sol LeWitt’s “Incomplete Open Cubes” (1974). I created all the cubes, then I visualized them in Tableau; this is how I did it.

Read more →
Data Viz
What size dashboard should you use for a nice Tableau Public thumbnail?
Data Viz
What size dashboard should you use for a nice Tableau Public thumbnail?
Data Viz

It’s not obvious what dashboard aspect ratio to aim for if you want a nice-looking thumbnail on Tableau Public, but I did some digging and found the best one. For now, at least.

Read more →
Data Viz
Let's talk about recovering from setbacks
Audio Production, Data Viz
Let's talk about recovering from setbacks
Audio Production, Data Viz

I scrapped a whole video because it wasn’t up to scratch. Afterward, I made a video about not making a video. Let me explain!

Read more →
Audio Production, Data Viz
7 things you can do to up your data game while job searching
Data Viz
7 things you can do to up your data game while job searching
Data Viz

So, you’re a data nerd, you’re looking for a new job, and you just reached the end of the list of jobs to apply for. What do you do next? This is exactly the situation that I have found myself in several times in the last few months, so I thought I’d compile a list of the things that I’ve done to keep myself engaged while in a lull.

Read more →
Data Viz
Visualizing Star Trek
Data Viz
Visualizing Star Trek
Data Viz

It’s no surprise that I’m into Star Trek. So what happens when my love of data collides with my fandom? I make a viz that turns the scripts of my favorite movies into an explorable piece of art.

Read more →
Data Viz
A few pitfalls of the small data set
Data Viz
A few pitfalls of the small data set
Data Viz

Think a small data set is easier to visualize? Think again. You have to pay as much attention to what’s NOT in the set as what is…or you risk misinforming your audience! This article explores some of the recent pitfalls I tried to avoid in the latest Makeover Monday challenge.

Read more →
Data Viz
Vintage Viz: Beautiful rings on your Linux desktop with Conky
Data Viz
Vintage Viz: Beautiful rings on your Linux desktop with Conky
Data Viz

System stats can be beautiful, too. Once upon a time, I used Conky on Ubuntu to visualize things like memory usage, disk space and battery percentage, rendered as dynamic rings right there on my desktop.

Read more →
Data Viz

Affiliate disclosure - Privacy policy - Terms of use