Select Page

Have you ever come across an idea with TONS of potential but fails to deliver on that potential? My friends Andy and Eva are pros at finding this stuff.

Let me explain…

They run a super cool project called MakeoverMonday.

Why is it so super cool? Because each and every week they find data visualizations from across the web, collect the underlying data sets, provide inspiration and feedback to the data viz community.

It’s a great way to connect with others and level up your data visualization game.

But, here’s the secret that most people don’t know.

By participating in MakeoverMonday, you get to fulfill the potential of that FAILED idea.

Super cool, right? How often at work do you see a crappy PowerPoint deck or poorly written email? How often do you get to make it better? Basically never.

Well, I’m going to pull back the curtain to show you how I fulfill the potential of a failed idea.

I dig into a super busted (and super boring…) chart from the World Health Organization looking at life expectancy rates across the globe.

While the original chart is definitely boring, the underlying story is definitely not boring. Just look at these examples which all use the exact same data set. CRAZY!

In this case study you’ll learn:

  • 4 things I really liked about the WHO Life Expectancy dashboard
  • 5 things I didn’t like…
  • How I improved the WHO Life Expectancy dashboard
  • The exact 14 steps you need to create a smooth bump chart in Tableau (including ALL the calculations)

Let’s do this!

WHO Life Expectancy at Birth

Original WHO Life Expectancy Chart

Improved WHO Life Expectancy Dashboard

4 things I really liked about the WHO Life Expectancy dashboard

  1. All countries are listed in alphabetical order in a table. This makes it easy if you’re need to find the life expectancy of a specific country at a glance.
  2. There are multiple views in one interactive dashboard. You can answer a few basic questions pretty easily.
  3. Color scheme is consistent for each view. No glaring issues with the color selection that might cause confusion.
  4. The legend provides exact value ranges with no overlap or confusion. The extra level of precision here is nice!

5 things that could be improved

  1. The interactivity didn’t work for me in the Google Chrome browser. Chrome is a very popular browser, so it’s kind of shocking to have something not work using that browser in 2017.
  2. There is no story or any highlights or anything here. It’s a pretty boring reference dashboard and doesn’t offer much for exploratory analysis.
  3. The dashboard has a lot of wasted space. For example, the table view could be removed completely if labels were added to the map or to the bar chart.
  4. The interactivity on this dashboard is pretty minimal and really just highlights the selected countries. It would be better to add some new information to highlight the similarities and differences between the countries selected.
  5. There seems to be a mismatch between the title of the dashboard and what’s actually being displayed. The title shows “2000-2015” so that’s what I thought was being displayed. However, the default selection is set to 2015 so that’s somewhat misleading. Also, the dates are in 5 year blocks so we don’t have data for every year so I think the title is misleading in that way, as well.

The exact ways I improved the WHO Life Expectancy dashboard

  1. Created a smooth bump chart in Tableau to show the change in ranking for each selected country over time. This is better than the bar chart because it includes the time and country dimensions and makes it easy to compare countries against each other.
  2. Added color coding to each country so it’s easy to keep track of changes over time.
  3. Included Tableau dashboard actions and parameters for improved interactivity and encourage exploratory analysis.
  4. Added tooltips to keep some of the detail out of the main visualization, but still available on hover.

Rebuilding the original WHO Life Expectancy chart into an interactive Tableau dashboard (the step-by-step process)

  1. First, I downloaded the WHO Life Expectancy data in Excel (thanks again to the MakeoverMonday team!)
  2. Next, I explored the data to find any quick insights or potential problems with the data set.
    I found there were some countries with missing data for certain years, multiple levels of detail, and aggregates all buried within the data set.
  3. After identifying those issues, I created an Alteryx workflow to clean up the extra records and simplify the data.
    I also added a new column called Join with a value of 1, which will be used in the smooth bump chart.
  4. Then I started on the main part of the interactive Tableau dashboard: the bump chart.
    It’s something I’ve seen and wanted to learn, plus I think it fits well here with the rankings over time.

Now, I didn’t want just a regular bump chart.

I wanted a super smooth bump chart.

Here’s the problem: I had NO CLUE how to build one!

Thankfully, there are a few folks that have done all of the heavy lifting (thanks Chris, Ken, and Rody!).

Here is the short version based on what I’ve learned.

How to create a smooth bump chart in Tableau

  1. Create a simple Excel sheet with 2 columns.
  2. Label one ‘Path’ and the other ‘Join’. Path has numbers 1-49. Join just has the number 1 repeated 49 times. You can download mine if you are confused like I was!

    Click to download your copy…

  3. Save the Excel file to your computer as “Join.xlsx”
  4. In Tableau, open your main data set. I’m using the WHO Life Expectancy data with my extra “Join” column tagged onto the end.
  5. Then, add a new data source and select your newly created Join.xlsx file
  6. Switch the join type to Outer and adjust the join column data types if needed.
  7. Create the 8 calculated fields needed for the smooth bump chart
    • t = ([Path]-25)/4
    • Sigmoid = 1/(1+EXP(-[t]))
    • Rank 2 Setup =IF MIN([Path]) = 49 THEN LOOKUP(MIN([Rank]),1) END
    • Rank 2 = IFNULL(WINDOW_MIN([Rank 2 Setup]), MIN([Rank]))
    • Curve = MIN([Rank])+(([Rank 2] – MIN([Rank]))*MIN([Sigmoid]))
    • YearOrder = [Year] – {MIN([Year])}
    • PathOrder = (49*[YearOrder])+[Path]
    • Marker = FLOAT(MIN(IF [Path]=1 THEN [Rank] END))
  8. Convert the Year field from a measure to a dimension
  9. Drag YearTemp to the Columns card
  10. Drag Curve and Marker to the Rows card and set as a dual axis
  11. Adjust the left and right axis so it’s reversed and showing 0 at the top position.
  12. Drag Region to the Fitlers card and select North America to reduce the number of countries displayed while we’re developing
  13. Drag Region and YearTemp to the Detail section of the Marks card
  14. Adjust the Curve Table Calculation, for both Rank 2 and Rank 2 Setup
    • Compute Using: Specific Dimensions
    • Order: Country Name > Year > Year Temp > Region
    • Restarting Every: Year for Rank 2 and Country Name for Rank 2 Setup

That’s it!

You can remove the filters, finish formatting, add some tooltips, and build out more functionality as needed.

What you’ve learned in this step-by-step guide

  1. How to analyze an existing dashboard and how to identify areas for improvement.
  2. Smooth bump charts are a great way to view changes in rankings over time.
  3. The 14 steps needed to make your own smooth bump chart in Tableau (including 8 calculated fields need)

Questions or comments? Email me brian@newprediction.com or hit me on Twitter @NewPrediction

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

Download the FULL listing of 10 free data visualization books covering dozens of topics across 100s of pages. All nice and neatly organized in an awesome Google Sheet for you to print or copy.

All set! Check your email :)

Tableau Dashboards: Beginner’s Guide (Free PDF)

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Massive List of Tableau Web Data Connectors(Free List)

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

This 4-page example PDF lists 10 examples of slope graphs curated from around the web with author links for each one. You'll also see the 16-minute walkthrough video where I create an interactive Tableau Dashboard from scratch. 

You have Successfully Subscribed!

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

Tableau Tutorial Chart Redesign

You have Successfully Subscribed!

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!