Posts tagged KPI

Week 38: Can you build a sales comparison chart with performance indicators?

This week I’m tackling a topic that nearly everyone has been asked – visualizing good/bad as performance indicators that are red or green.  At least here in the western world, the busy executive tends to think about things in terms of traffic lights.  So this week your task is to create something that satisfies their ask of seeing immediate good/bad and adding on some additional analytical components for context (essentially the “why” behind the good/bad).

click to view on Tableau Public (screenshot taken 9/17/19)

This dashboard also tackles the idea of automating the visualization to update as time ticks on.  The goal is that you build something today and it will continue to work in the future (in fact you’ll probably see based on when you’re viewing this blog post the visual will change).

And a last side benefit of this challenge will be learning how to build something that can be automated/pre-built, even if you don’t yet have the data.  In this specific example we’ll be pretending it’s 2018 to use the static Superstore data set.  So if you find yourself working with a static data set in the future and trying to anticipate and build out the visuals, you can use this method to construct the final view.

Requirements

  • Dashboard Size: 1100 x 700 (you choose # of sheets)
  • Create a running total sales chart (MTD) for the 3 different Segments
    • Show current year as a running total line chart, colored red/green depending on if it’s above/below the same MTD value from the prior year
    • Show prior year as area chart – if it’s part of the prior comparative time period it should be dark gray, yet to come should be light gray
    • Create a dynamic reference line for Today
    • Add on a dynamic title that states the days left in the month
    • Add on an indicator to the left of BANs that is red/green depending on if sales is up or down
    • Match labels, tooltips, and all additional formatting
    • Include a Category filter so you can test the functionality
    • Hint: pretend we’re in the year 2018 by subtracting X # of years from Today

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.  Also include the hashtag #WorkoutWednesday2019 in your description to make it searchable!

Share

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

Watch the Solution

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.