Date Archives July 2019

2019 Week 31: When #WorkoutWednesday meets #PreppinData? Can you create a Hub and Spoke map?

This week, alongside WorkoutWednesday we have a new collaboration, which gives you a chance to try out another community project,  #PreppinData. PreppinData is a like workoutwednesday but with Tableau Prep Builder. Each week they give you a messy data set, some requirements and a finished data set, you then have to use Tableau Prep Builder to clean the data set and get to the final outcome. This week we start off with a PreppinData challenge, which then feeds into WorkoutWednesday. Are you ready to truly feel the Burn?

To celebrate Tableau’s Music month I found a great data source on one of my favourite artists (Ed Sheeran) that led Carl Allchin to ask a question about one of his faves (Ben Howard). We want to analyse the two artists careers based on their touring patterns and as two UK-based singer-songwriters who appeared on the UK music scene at similar times, how have they developed.

For the #PreppinData challenge please click here. This is where you will get the data from.

 

Now for the WorkoutWednesday challenge.

 

Click to Interact

Requirements

  • Dashboard size: 1600 x 900
  • Version 2019.2 needed
  • Group Locations into Regions
  • Create Hub and Spoke maps (no extra data prep required other than whats in the PreppinData Challenge), North and South America, Europe, Middle East and East Asia and Pacific.
  • Word Cloud of All supporting artists which an action per region.
  • Formatted Tooltips
  • Colours and font consistent.

Data

Here you can find the output from the #PreppinData challenge for those who want to just to the workout,

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

 

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 #PreppinData and tag @AnnUJackson@LukeStanke@lorna_eden@curtisharris_! @DataJediNinja and @JonathanAllenby

Track Your Progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Hints

Check out this blog by Tableau

Week 30: Creating a Navigating KPI Block

If your schedule is anything like mine, then you’re probably enjoying the summer months – using vacation time, nicer weather, summer holidays, and a generally more relaxed schedule.  To help keep that vibe going, this week I’m challenging you to a very straightforward build.  This is an extremely simplified version of something I recently built and leverages new features Tableau has brought us this year.

Your challenge is to build a 4 block set of KPIs (maybe Big Numbers is more appropriate) that upon clicking drills into bar charts showing Sales by the chosen dimension.  Nothing overly fancy here – just a hands on opportunity to rethink how you can use navigation to create better analytical tools.

click to view on Tableau Public

Requirements

  • Dashboard size: 600 x 600, # of sheets is up to you
  • Create a 4 block of KPI/BANs representing the distinct count of
    • Customers
    • Cities + State combo
    • Product Name
    • Order IDs
  • Users should be able to click on a box and navigate to a bar chart that shows Sales by the chosen dimension
  • Match formatting (and I’ve turned off all tooltips this week!)
  • Colors come from Hue Circle

Dataset

This week uses the superstore dataset for Tableau 2019.1.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

 

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson@LukeStanke@lorna_eden, and @curtisharris_!

Track Your Progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Watch the Solution

2019 Week 29: Which months do we see a higher number of orders?

Last week we were putting together a deck for an executive team and we wanted to show the seasonality of data while still showing the overall average. In our time crunch we came up with our challenge for this week!p

Challenge – Intermediate


Click image to view on Tableau Public

Requirements – Intermediate

  • Format: 900px by 600px
  • Create a line that shows the total orders per day by segment. Show the value on the left side of the line.
  • For each month, show a bar above or below the line with the orders per day for that month.
  • Label the bars with the percent difference between the monthly value and the overall value.
  • Match tooltips.
  • Color choices are up to you.

Dataset

This week uses the superstore dataset for Tableau 2019.1. You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Solution

Watch

 

Week 28: Workout Wednesday Weather

I recently came across a material design style guide for data visualization, and wanted to try some of the concepts. Google has many design guides based on their material design concept, but none related to data visualization until just recently. These style guides are great for getting new ideas, just make sure you don’t get too hung up trying to precisely replicate in Tableau… it won’t always work out that way! For this week’s challenge, I decided to focus on one specific visualization from this particular style guide:

I’m going to go ahead and say that someone out there could replicate this 100% accurately in Tableau, but there are a few elements where the juice just isn’t worth the squeeze. I chose this particular chart because of the elements that focus on, or could focus on scale. With that, here is this week’s challenge.. average monthly temperatures in the home bases of the Workout Wednesday crew.

Click to see the Tableau Public visualization

Data

https://data.world/curtisharris7/workout-wednesday-2019-week-28

Requirements

  • Dashboard size 1000×800
  • All elements should be in a vertical container, except for the filter
  • Provide 150px padding on all sides of the vertical container
  • Make sure values display the degrees symbol as a suffix
  • Axis should display marks every 20 degrees, and should provide context to the reader at the top most mark
  • Add a reference line for the current month, that will update automatically as the year goes on
  • Add a circle over the point in the lines that represents the current month’s average temp
  • Add a label for the hottest city, in the current month, for all of the cities in the view
    • If you filter out Phoenix, the label should move to Salt Lake City
  • Add a simple color legend that updates as the filter changes
  • Turn off tooltips – not necessary for the challenge

Solution Video

If you need some help, check out the solution video!

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Week 27: Can you build a dynamic KPI view?

How often do you think about scale? Making sure my dashboards scale over time is one of my top priorities whenever I start a new project, so this week’s Workout Wednesday is going to be focused on building a solution that will scale combined with standard KPI views. I’ve been asked to build KPI views many times in my career, and I’m always looking for ways to inject pieces of interactivity, while keeping the high level view in tact – this challenge should help you think of ways you can incorporate Workout Wednesday directly into your work.

Have fun!

Challenge

Click to view on Tableau Public

Requirements

  • Format: 720x420px
  • Create a summary view that can display the Category or Segment dimension on demand
    • The summary value should represent the profit ratio for the most recent week/month/quarter in the data, depending on what your date parameter is set to
    • The additional up/down number should represent the absolute percentage point change from the previous week/month/quarter
  • Create a dynamic color legend for the Category or Segment dimension members, that highlights the dimension member your user is hovering over
  • Create a line chart that displays the overall profit ratio for the last n weeks/months/quarters (as decided by the slider in the top right)
    • The line chart should also support an additional line for the dimension member your user is hovering over
  • Turn off all the tooltips – you’re welcome
  • Where you are assuming black, use #181818 instead
  • Where you are assuming white, use #e6e6e6 instead
  • Match all other colors as close as you’d like

Dataset

This week uses the superstore dataset for Tableau 2019.1.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.