Category Archives: Community Projects

How to paginate data in Tableau | #WorkoutWednesday | 2019 | 09

It’s always fun to bend Tableau into doing things it’s not really intended to do. One of the things that makes Tableau different then other more traditional reporting tools is it doesn’t natively support pagination of data. I say natively because as we’re about find out, there are ways of doing creating a “pages” user

Read More

How to create a Pareto chart in Tableau | #WorkoutWednesday | 2019 | 08

The Pareto principle was developed by the Italian economist Vilfredo Pareto when, in 1906, noticed that 80% of the land in Italy was owned by 20% of the population. And thus, the 80/20 rule was born and business leaders have been stuck on it ever since 🙂 The Pareto chart is based on the principle

Read More

How to pivot rows to columns in Tableau Prep | #PreppinData | 2019 | 02

So it looks like Carl Allchin and Jonathan Allenby‘s little Tableau Prep project had a great first week! The solutions to #PreppinData Week 1 are available here: https://t.co/2oSmskhgxl We loved the feedback and alternate solutions found (along with some visualisations too). The new challenge will be posted tomorrow! Thanks to those that filled in the

Read More

How to create a radar chart in Tableau | #WorkoutWednesday | 2019 | 07

This is a fun one. I like it when the #WorkoutWednesday add a little whimsy into their challenges and that’s just what Lorna did with her’s this week. Since her challenge came during the week of Valentines Day, she resurrected an old #MakeoverMonday dataset about valentines day spending and challenged us to make a radar

Read More

Rural Hospitals are closing… | #ProjectHealthViz | 2019 | 02

Back in late December I was starting to look ahead to 2019 and thinking about what I wanted to accomplish. Among other things, I wanted to participate more in Lindsey Betzendahl‘s awesome dataviz project, #ProjectHealthViz And while I’m already one month behind, I really wanted to make sure that I completed something for this month’s

Read More

How to aggregate multiple columns in Tableau Prep | #PreppinData | 2019 | 01

Well hello there! Whether you’ve read my blog before or you’re here for the first time – Welcome to the first edition of a new weekly challenge, #PreppinData, spearheaded by Carl Allchin, “The Other” head coach at the The Information Lab Data School, and Jonathan Allenby, consultant at The Information Lab. In the same vain

Read More

How to make a tree plot in Tableau | #WorkoutWednesday | 2019 |6

#WorkoutWednesday2019 week 6 is here | don't get fooled by the pretty trees, this chart can easily be re-purposed for a business setting and includes a few little formatting tricks for good measure | blog: https://t.co/5slLIhIukT | full viz: https://t.co/ueS0wPAOEC pic.twitter.com/8RfwrAKx1s — Ann Jackson (@AnnUJackson) February 6, 2019 Well this looks fun and new! TREES?!

Read More

How to make a multi-dimensional dot plot | #MakeoverMonday | 2019 | 5

Hello again! Welcome back and as always, thanks for reading!

For week 5 of #MakeoverMonday 2019, Andy has given us a stacked bar chart from the European Commission looking at the Digital Economy and Society Index scores for countries in the EU across 5 categories.

original

What works well

  • sorted best to worst
  • legend is clear
  • title is simple enough

What could be improved

  • Stacked bars are good for cumulative comparison but as soon as you add the colors to each bar, I think instinctively a large number of will want to compare the parts to each other. And in this display, doing that is extremely difficult.

I think there’s a way that we preserve the ability to see and compare the cumulative indices AS WELL AS being able to compare each the individual parts.

I think a multi-dimensional dot plot is the best way to visualize this data. I remember WAY back in week 17 of 2017 (Apr. 24) of #MakeoverMonday that Tableau Zen Master, Matt Chambers created a dashboard that is extremely close to the one I want to build for this week. Back then we were comparing a list, compiled by LinkedIn, of skills in high demand. Here is what Matt created, click the picture for the interactive version:

linkedin top skills 2016 - makeovermonday

He even wrote up a blog about highlight action piece.

I’m going to #StealLikeAnArtist and use this as a framework for what I’m going to build. Here is what I built. If you want to learn how I built it complete with data prep and calculations, I encourage you to continue reading below, otherwise, click the screenshot for the interactive version

desi

Read More

How to create a Combination Step Line in Tableau | #WorkoutWednesday | 2019 | 4

Former #IronViz champion and just about the nicest guy you’ll ever know, Curtis Harris has also joined the #WorkoutWednesday2019 crew. And week 4 is his inaugural post. Let’s take a look! Alrighty, here we go. We’ve got a step line chart with circles on the points of change, sized by absolute change, colored by polarity.

Read More

Skip to content