Week 7: What happens if? Can you update sales forecast and targets using only parameters?

Introduction

At the last North West Tableau User Group, I watched a presentation from Ryan Lowers and Nathan Leather where they looked at using parameters as a data source. You can see their workbook here. So this week we are focusing on using Parameters as a Data Source. How can we add data to the current data we have. The dashboard focuses in on Sales, current, forecasts and targets.

Requirements

  • Dashboard Size: 1000px by 500 px
  • # of Sheets – up to you
  • Create a bar chart that shows 2019 sales
    •  That shows Target, 2019 sales and Forecast values on labels
    •  TARGET should be
      • Furniture_270000:Office Supplies_260000:Technology_250000:
  • Add targets as a gant chart sales
  •  Use a parameter to input a sales increase for a selected category
    •  When you enter a sales increase figure and click a category on the left it will add a new bar to the sales chart, to show the new forecast sales
  • Use a parameter to update sales targets when a category is clicked on the right
  • Add a reset button for both the sales forecast and targets.
EXTRA
  • Make sure selections automatically deselect
  • Calculate percent change for current value and target, and forecast value and target.

Dataset

This week uses the superstore dataset for Tableau 2019.4. 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 #WOW2020 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @AnnUJackson@LukeStanke@lorna_eden, and @HipsterVizNinja

Solution

1 thought on “Week 7: What happens if? Can you update sales forecast and targets using only parameters?”

Leave a Comment

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

Scroll to Top