2021 Week 18: Can You Performance Tune This Workbook?

Introduction

Learning complex techniques and beautiful design is super important to mastering visual analytics.  But, nothing will stop a user from regularly and joyfully using a dashboard than a poor performing one.  It doesn’t matter if it looks like Michaelangelo designed it or it has the cure for some crazy infectious disease – if it takes more than 5 seconds to load, most people will take their chances without your dashboard and hit the ‘x’ on the browser tab. 

Think I’m being dramatic?  I wish I were.  People are busy, have things competing for their attention, and are used to web pages that load in under a second.  So, when something takes more than 5 seconds to load – people assume it’s broken and move on.  For those that hang in there, they’re frustrated for their wait before they even look at what you’ve built.  The general rule is 3 seconds or less – the closer to zero, the better.  

So, this challenge is all about performance optimization.  Speed is the name of the game.  The initial workbook will be like watching paint dry or crawling on glass – just painful.  For reference, the slow workbook will take between 2ish minutes to load, depending on your computer.

Key Context/Hint: 

  1. The end user only cares about OB/GYNs.  
  2. Save some time and download the slow workbook and use as your base to optimize.  

Requirements

  • Must take an ‘after’ performance recording using the following scripted actions:
    • Click on TX, deselect
    • Select a gender, deselect
    • All events must be sub-0.5 second (you can verify on performance recording)
  • Dashboard Size: 1100 x 800
  • # of Sheets: 2
  • Same formatting
  • All data prep/transformation has to happen within Tableau Desktop
  • Must create a map that highlights Providers per (100K) capita
  • Must create a table that provides provider detail that filters based on user action/selection

Dataset

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2021 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2021 and tag @AnnUJackson, @ItsCandraM, @LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Solution

Interactive

1 thought on “2021 Week 18: Can You Performance Tune This Workbook?”

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top