Dashboard 4: Finding the Signal in a Scatter Plot’s Noise

Hi all! Welcome to Dashboard 4. The three visualizations here dive into the question of how individual names are split between female and male social security cards. Sure, there are many names that gravitate towards a single sex, but there are also a ton of names that are used by both sexes. Those names drift away from the axes on our scatter plot and move towards that 45 degrees reference line. When you click on a name’s circle, the line graph and 100% stacked bar chart give you a more nuanced picture of the name’s history. Get ready! Building Dashboard 4 breaks into eight steps, but we’ll take them one at a time and before you know it, you’ll have created this sophisticated dashboard.

WHAT YOU’LL LEARN
  • If/then statements
  • Scatterplots
  • Highlighter vs. filter
  • 45 degree reference line
  • 100% stacked bar charts
  • Bins
  • Global formatting
GET THE DATA

Dashboards 1 through 5 all use the same data. It’s a super simple data set (seriously, it’s just four variables) and it’s all about first names from U.S. social security cards in the 20th century. Click here to download the data and create your own dashboard along with the videos. This is the best way to build up those Tableau skills! If you haven’t used this data before, check out Dashboard 1: Step 1 for a quick overview of the data and instructions on how to connect it to Tableau Public. Thanks to Data.gov for making data like this public!


ROADMAP
STEP 1: CALCULATED FIELD WITH IF/THEN STATEMENT
STEP 2: SCATTER PLOT
STEP 3: HIGHLIGHTER
STEP 4: 45 DEGREE REFERENCE LINE
STEP 5: LINE CHART
STEP 6: 100% STACKED BAR CHART
STEP 7: BINS
STEP 8: DASHBOARD DESIGN

SHARE WHAT YOU’VE BUILT!

Thanks so much for building Dashboard 4 with me! Share your own dashboard below, and let me know what you think of this tutorial. Can’t wait to hear from you!


Leave a Reply

Your email address will not be published. Required fields are marked *