Business dashboard template: SALESFORCE SALES PIPELINE

/uploads/galerie/000275/Sales Pipeline Cockpit.PNG

Providea workbookcontaining at least12 attributes

Geta ready-to-use,best-in-marketSALESFORCE SALES PIPELINE dashboard

Salesforce Sales Pipeline Home

Get a Home Page for your Salesforce Sales Pipeline dashboard

Sales Pipeline Cockpit

This cockpit provides you with an overview of your pipeline across your open opportunities. Visualize instantly on what you should focus first.

Sales Pipeline Review

Support your weekly/monthly sales reviews with tangible facts & figures: Which achievements have been done over the last period? Where to focus on following period?

Sales Pipeline Analysis

This dashboard page provides you with insightful information on your pipeline.

12 required attributes

Opportunity ID
Account
Opportunity Owner
Opportunity Type
Opportunity Name
Stage
Open Flag
Won Flag
Created Date
(Estimated) Close Date
Amount
Probability (%)

10 dashboard pages

Detailed presentation of the SALESFORCE SALES PIPELINE dashboard

Your SALESFORCE SALES PIPELINE dashboard will contain 23 KPIs

Nb of Open OpportunitiesTotal number of open opportunities
Pipeline ValueTotal opportunity amount (for open opportunities)
Weighted Pipeline ValueTotal opportunity amount weigthed by probability (for open opportunities)
Sales Cycle LengthAverage duration (in days) between Created and Closed Date
Sales Cycle Length (won)Average duration (in days) between Created and Closed Date for Won Opportunities
Sales Cycle Length (lost)Average duration (in days) between Created and Closed Date for Lost Opportunities
Total Sales ValueTotal amount for won opportunities
Win RateShare of won opportunities (on total closed opportunities)
Nb of OpportunitiesTotal number of opportunities
Nb of Closed OpportunitiesTotal number of closed opportunities
Nb of Won OpportunitiesTotal number of won opportunities
Nb of Lost OpportunitiesTotal number of lost opportunities
Total Closed Opportunities AmountTotal amount of lost opportunities
Avg Deal Size (won)Average amount of won opportunities
Avg Opportunity SizeAverage opportunity amount
Nb of AccountsNumber of accounts having opportunities
Nb of OwnersNumber of opportunity owners
Nb of Opp. per AccountAverage Number of opportunities per Account
Nb of Opp. per OwnerAverage Number of opportunities per Owner
Nb of New AccountsNumber of New accounts (first time opportunity over the period)
Avg ProbabilityAverage probability ratio
Total Opp. AmountTotal opportunity amount (for all opportunities)
Sales VelocitySales velocity is a measurement of how fast you are making money (you are bringing in roughly that much revenue each day): [Nb of Open Opp.] * [Avg Deal Size] * [Win Rate] / [Sales Cycle]

and 10 dashboard pages

Home

Salesforce Sales Pipeline Home

Get a Home Page for your Salesforce Sales Pipeline dashboard

Cockpit

Sales Pipeline Cockpit

This cockpit provides you with an overview of your pipeline across your open opportunities. Visualize instantly on what you should focus first.

Sales Pipeline Performance Breakdown

Get an instant overview of your performance: Win Rate, Sales Cycle, Pipeline Value...

Sales Pipeline Review

Support your weekly/monthly sales reviews with tangible facts & figures: Which achievements have been done over the last period? Where to focus on following period?

Sales Pipeline Analysis

This dashboard page provides you with insightful information on your pipeline.

Sales Pipeline Calendar

Get a quick overview of when your opportunities took place

Sales Pipeline Historical Performance

This dashboard shows your past performance in closing deals

Trends Analytics

Salesforce Sales Pipeline Trends Analysis

Visualize the evolution of any of your Salesforce Sales Pipeline KPIs: Trends, Performance & Year over Year

Distribution Analytics

Salesforce Sales Pipeline Segmentation Analysis

Visualize the value of any of your Salesforce Sales Pipeline KPIs, split by the dimension you selected (market share analysis)

Salesforce Sales Pipeline Pareto Analysis

Perform a Pareto Analysis on any of your Salesforce Sales Pipeline KPIs: the 80/20 rule.

Creating your SALESFORCE SALES PIPELINE dashboard Step-by-Step

You want to get a clear understanding on your Salesforce Sales Pipeline results? You want to build a Tableau dashboard to better understand your Salesforce Sales Pipeline data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Salesforce Sales Pipeline data in less than 5 minutes!

Salesforce Sales Pipeline dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Salesforce Sales Pipeline data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Opportunity ID Opportunity Unique Identifier [Opportunities.Opportunity ID]
Account Customer/Prospect [Account.Account Name]
Opportunity Owner Owner of the opportunity [Opportunities.Opportunity Owner]
Opportunity Type Type of Opportunity [Opportunities.Opportunity Type]
Opportunity Name Opportunity Name [Opportunities.Opportunity Name]
Stage Opportunity Stage [Opportunities.Stage]
Open Flag "Y" if the opportunity is Open [if [Opportunities.Closed] then "N" else "Y" end]
Won Flag "Y" if the opportunity is Closed and Won [if [Opportunities.Won] then "Y" else "N" end]
Created Date Opportunity Creation Date [Opportunities.Created Date]
(Estimated) Close Date Actual Closed Date is the opportunity is Closed, else Estimated Close Date [Opportunities.Close Date] (Date used for time-series analysis)
Amount Opportunity Amount [Opportunities.Amount]
Probability (%) Probability to win the opportunity (50 stands for 50%) [Opportunities.Probabilities (%)]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Salesforce Sales Pipeline' and upload your Tableau workbook (note: your data is NOT uploaded).