#WOW2022 | Week 20 | Monthly Sales vs Target

Tableau, Workout Wednesday / By

Introduction

This week is TABLEAU CONFERENCE week! The whole team is in Vegas ready to meet some of you in our live Workout Wednesday Meet-up!

As luck would have it, I have the honour of preparing this week’s challenge. For those of you who will be working out with us in person, part of the challenge will be to complete as much as possible within the 30 minutes available. If you’re joining us virtually, let us know how you get on and don’t forget to share your solutions on Twitter.

Without spoiling too much, the challenge involves superstore Sales Target data and some sneaky labelling. I hope you enjoy it!

Click to open in Tableau Public

Requirements

  •           Dashboard Size: 1000 x 800px
  •           Download and join the Superstore Sales Target data to the usual Sample Superstore data (2021)
  •           Create a bar-in-bar chart to compare the Monthly Sales (in front) with the Target Monthly Sales (behind).
  •           Filters:
    •       Year = 2021 only
    •       Action filter to allow users to select a particular Product Category
  •           If the actual Monthly Sales did not meet or exceed the Target then colour the Monthly Sales bar in a bright highlight colour (I used red).
  •           For the highlighted months (where Sales < Target): label the bar with the following text “Target missed by” + the difference between the Sales amount and the Target amount.
  •           Match tooltips and formatting

Bonus:

  •       To really test yourself, set a timer and try to complete this challenge within 30 minutes!

Dataset

This week’s challenge requires two data sets. The first is the sample Superstore data which you can find here Data.World (Superstore). The second is some corresponding Monthly Sales Target data which you can find here Data.World (Target).

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 #WOW2022 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2022 and tag @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz

Solution

Download the workbook for a step-by-step breakdown of how this challenge was built (each step is on a different worksheet).

Interactive

Scroll to Top