2020 Week 14: How does the sales pipeline look?

Introduction

One of the most common questions I get is how to build a sales funnel. I always answer: just build a bar chart! That’s what we are going to do today. To build that sales pipeline we are going to have data where we know the latest stage, but it doesnt track the previous stages. We only know they always flow through each stage: Prospect, Lead, Qualified, Opportunity, Negotiations, and Closed. You challenge is to calculate the total value that has funneled through each stage of the sales pipeline.

To do this you’ll need to use a table calculation where the calculation is Table Up. Of course, this option doesn’t exist, you only have Table Down and Table Across. So how will you solve it?

Requirements

  • Dashboard Size: 700 by 400 px
  • Show three columns of bar charts:
    1. the total value of the sales opportunity currently at each stage
    2. total dollars that have passed through each stage of the funnel: (Ex: Closed sales have gone through each stage and should be included at each level, Negotiations should be added to every stage except closed)
    3.  The total percentage of sales that have closed that have passed through that stage level.
  • Color the background of the percent of sales to close a lighter green.

Dataset

This week’s challenge uses a custom data set for sales. You can get it here.

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_Brown and @LosaniMeera

Solution

Luke is on lockdown and has a broken laptop so he’s written a solution instead of posting a YouTube video. You can see the solution here.

3 thoughts on “2020 Week 14: How does the sales pipeline look?”

Leave a Comment

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

Scroll to Top