{"id":104,"date":"2021-03-01T04:00:00","date_gmt":"2021-03-01T04:00:00","guid":{"rendered":"https:\/\/bloudesigns.com\/blog\/?p=104"},"modified":"2025-03-04T03:41:00","modified_gmt":"2025-03-04T03:41:00","slug":"choosing-the-right-visualization-diversity-equity-inclusion-example","status":"publish","type":"post","link":"https:\/\/bloudesigns.com\/blog\/index.php\/choosing-the-right-visualization-diversity-equity-inclusion-example\/","title":{"rendered":"Choosing the right visualization: A diversity, equity, and inclusion example"},"content":{"rendered":"\n<p>It&#8217;s frequently the case that we don\u2019t just need to wrangle and analyze the data. We also need to <strong>communicate the findings<\/strong> of the analysis so that we can figure out what to do next. This is where choosing the right visualization comes in. In this post, I discuss how different visualization choices &#8211; in particular, a pie chart, a line chart, and a 100% stacked column chart &#8211; enable different understandings of the data, and different conversations and decisions around the data.<\/p>\n\n\n\n<p>(You can watch the video version of this post, or keep reading below.)<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Choosing the \u201cright\u201d visualization: A diversity, equity, and inclusion example\" width=\"680\" height=\"383\" src=\"https:\/\/www.youtube.com\/embed\/i07ah9_OQK0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">A Typical Diversity, Equity, and Inclusion Scenario<\/h2>\n\n\n\n<p>When we talk about Diversity, Equity and Inclusion (DEI) efforts, we frequently turn to the data to see how we\u2019re doing relative to our own internal goals, and, as possible, how our efforts and relative success rates compare to those in our local communities and others in our industries. That is, we typically talk and think in terms of <strong>benchmarks<\/strong> and <strong>progress towards a target percentage<\/strong>.<\/p>\n\n\n\n<p>For the purposes of this post, let\u2019s use a scenario in which fictional employees have self-reported demographic data as part of their job application process. Your resulting dataset includes department information as well as standardized demographic classifications for ethnicity, race, and gender.<\/p>\n\n\n\n<p>You\u2019re interested in knowing whether your employee population is trending towards establishing or maintaining a certain level of racial diversity, primarily through percentage targets. In other words, you need both percentages and changes in those percentages over time.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Pie Chart for Percentages<\/h3>\n\n\n\n<p>A pie chart is a natural choice for visualizing percentages. This pie chart shows the racial makeup of the dataset\u2019s employees in 2020.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"532\" src=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/PieChart-1024x532.png\" alt=\"pie chart showing fictitious employee racial demographics as percentages of a whole, accompanied by a slicer with the year 2020 selected\" class=\"wp-image-188\" srcset=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/PieChart-1024x532.png 1024w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/PieChart-300x156.png 300w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/PieChart-768x399.png 768w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/PieChart.png 1283w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>While the number of racial categories represented here is small, representing too many categories with a pie chart has the obvious problem of making the data difficult to read and digest, which makes it harder to understand and use for decision making. If diversity within the company were to grow, and the number of racial categories were to increase, the pie chart would lose its usefulness as a means of displaying percentage breakdowns.<\/p>\n\n\n\n<p>The bigger problem is that a pie chart is a single snapshot, much like a photograph captures a single moment. There is no history here, meaning that it has no context to show whether this is an improvement over where you were a year ago or whether you\u2019re on the right track for your targets.<\/p>\n\n\n\n<p>If all you needed was a simple yes or no to see if you\u2019ve met a certain target percentage, this might be sufficient. Since, in this scenario, you\u2019re interested in assessing how you\u2019re trending, you need a different visualization.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Line Chart for Trends<\/h3>\n\n\n\n<p>A line chart is the standard go-to for trends over time. In this chart, each line represents a racial category, with each data point showing the count of employees at that time.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"498\" src=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/LineChart-1024x498.png\" alt=\"line chart showing fictitious employee racial demographics between the years 2010 and 2020, with each line representing a different racial category\" class=\"wp-image-189\" srcset=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/LineChart-1024x498.png 1024w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/LineChart-300x146.png 300w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/LineChart-768x374.png 768w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/LineChart.png 1338w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>This chart gives you the history you\u2019re looking for, but isn\u2019t very impactful. It requires a lot of mental work to figure out how these trends translate in terms of your percentage goals. You could plot percentages instead of the count of employees, but the intersecting lines can still make it difficult to understand the implications of various changes over time.<\/p>\n\n\n\n<p>Are you on track? Maintaining? Trending away? Figuring this out is mental work you should be reserving for figuring out what to do about where you\u2019re at and how you\u2019re trending, not figuring out where you\u2019re at in the first place.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The 100% Stacked Column Chart for Percentages and Trends<\/h3>\n\n\n\n<p>My favored option for this scenario is the 100% stacked column chart. This format provides trends over time as well as percentages at each of the time slices. Each column represents 100% of the data at that time, sort of like a flattened pie chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"377\" src=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All-1024x377.png\" alt=\"100% stacked column chart showing fictitious employee racial demographics between the years 2010 and 2020, with each column showing the percentages of each racial category for that year, accompanied by a slicer for company departments\" class=\"wp-image-190\" srcset=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All-1024x377.png 1024w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All-300x110.png 300w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All-768x282.png 768w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All-1536x565.png 1536w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-All.png 1716w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>At a glance, you can quickly see how each racial classification is trending over time, which means that you get the information you need for the question you\u2019re asking, and you\u2019re reserving your mental energy for reflecting on what the data is telling you and what you want to do next.<\/p>\n\n\n\n<p>When you combine this visualization with a slicer or filter, it\u2019s also easy to explore the trends in terms of the departments and other factors represented in your dataset, and that provides a richer context, and a better understanding of where you might need to focus our efforts to achieve your goal.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"379\" src=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite-1024x379.png\" alt=\"100% stacked column chart showing fictitious employee racial demographics between the years 2010 and 2020, accompanied by a slicer for company departments with C-Suite selected, and each column showing that departments as 100% white\" class=\"wp-image-191\" srcset=\"https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite-1024x379.png 1024w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite-300x111.png 300w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite-768x284.png 768w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite-1536x569.png 1536w, https:\/\/bloudesigns.com\/blog\/wp-content\/uploads\/Stacked-CSuite.png 1709w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>I want to emphasize that this visualization claims a 100% representation of the population in question. So I\u2019ve included a category for UNKNOWN, which ensures that each employee is still counted, even if that employee opted out of answering demographic-related questions. The claim of 100% would be misleading otherwise.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Visualization Lessons from This Scenario<\/h2>\n\n\n\n<p>When working with your own demographic data, you could obviously extend this scenario to any situation with participants, such as students in a college-level program, committee memberships, or members of a networking group.<\/p>\n\n\n\n<p>Whatever the case, it\u2019s important to verify that your visualizations are:<\/p>\n\n\n\n<ul>\n<li>appropriate to the questions being asked,<\/li>\n\n\n\n<li>enable the types of conversations and decisions you want, and<\/li>\n\n\n\n<li>require a minimal amount of mental energy being used to understand what the visualization is trying to tell you.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s frequently the case that we don\u2019t just need to wrangle and analyze the data. We also need to communicate the findings of the analysis so that we can figure out what to do next. This is where choosing the right visualization comes in. In this post, I discuss how different visualization choices &#8211; in particular, a pie chart, a&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":192,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[22,25,23,24],"_links":{"self":[{"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/104"}],"collection":[{"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":12,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/104\/revisions\/193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/media\/192"}],"wp:attachment":[{"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bloudesigns.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}