Makeover Monday live at Tableau Conference

by Emily Dowling

Tableau Conference is on tour this week in London and Andy Kriebel & Andy Cotgreave hosted #MakeoverMonday live and streamed it via Periscope. So, back at the Dataschool office we joined in the challenge – to create a viz in under an hour. I managed to get my basic dashboard completed within the time (but then spent a bit more time afterwards cleaning it up and formatting…!)

The dataset provided was very small and simple, comprising the percentage of US males and females in different level roles within corporate organisations.

Data

First, I decided to look at the percentages of females in the different level roles over the two years. I created a simple chart with Year in the columns and Level (role type) in the rows. I decided to use a dual axis so that I could plot a circle for each years’ average percentage and then a line to join them together.

Chart 1

I then replicated this chart for the male percentages.

These charts showed the difference in percentages for the different role types, but it’s not easy to see a comparison between male and female, so I decided to:

  • Add tooltips for more information
  • Create another chart to see the differences in each role type more clearly.

For the second part of my dashboard I made a bullet chart to compare the overall percentage of males vs. females within each role type.

Chart 2

See my final dashboard here or search #MakeoverMonday on Twitter to see some great vizzes.

How to Calculate a Linear Regression Line in Tableau

4 mins read

Fri 02 Sep 2016

Quick Table Calcs: How to Calculate Percent of Total in Tableau

4 mins read

Mon 08 Aug 2016

How to calculate a correlation coefficient in Tableau

4 mins read

Fri 05 Aug 2016

How to calculate Z-Scores in Tableau

3 mins read

Tue 02 Aug 2016