SD Cockpit W.PNG SD Cockpit D.PNG
14 required attributes
  • dateBilling Date
  • stringCustomer
  • stringCustomer Group
  • stringCountry
  • stringDistribution Channel
  • stringDivision
  • stringSales Office
  • stringSales Group
  • stringSalesRep
  • stringMaterial Number
  • stringMaterial Group
  • numericQuantity | Volume
  • numericSales Amount
  • numericSales Cost
10 KPIs
  • Turnover
  • Total Sales Margin
  • Total Sold Quantity
  • Distinct Items Sold #
  • Active Customers #
  • Total Sales Costs
  • Sales Margin %
  • Average Selling Price
  • Turnover per Customer
  • Sales Costs %

Detailed presentation of the SAP SD dashboard

KPi Your SAP SD dashboard will contain 10 KPIs:

  • TurnoverSum of Sales amount
  • Total Sales MarginSum of Sales Margin
  • Total Sold QuantitySum of Sales quantity
  • Distinct Items Sold #Number of distinct items sold during the period (catalog depth)
  • Active Customers #Number of distinct customers having a sales transaction during the period
  • Total Sales CostsSum of Sales amount
  • Sales Margin %Total Sales Margin / Turnover (expressed in %)
  • Average Selling PriceTurnover / Total Sold Quantity (expressed in currency)
  • Turnover per CustomerTurnover / Number of Customers (expressed in currency)
  • Sales Costs %Total Sales Costs / Turnover (expressed in %)

Visualization and 20 dashboard pages

Home

Sales - Home

Sales - Home
Sales - HomeSales - Home
Get a Home Page for your Sales Dashboard

Cockpit

Sales Cockpit

Sales Cockpit
Sales CockpitSales Cockpit
Get a 360° view of your Sales performance

SAP SD KPIs Overview

SAP SD KPIs Overview
SAP SD KPIs OverviewSAP SD KPIs Overview
Get a transversal view of your Sales performance across dimensions of your SAP SD source

Sales Top KPIs Evolution

Sales Top KPIs Evolution
Sales Top KPIs EvolutionSales Top KPIs Evolution
Visualize how your Sales Performance is evolving (Month-to-Date, Year-to-Date)

Item / Product Analysis

Item Performance

Item Performance
Item PerformanceItem Performance
Better understand your Sales Performance from an Item point of view: Top items, Evolution of catalog depth, Product Life Cycle...

Item Average Selling Price

Item Average Selling Price
Item Average Selling PriceItem Average Selling Price
Visualize the evolution of the Product Average Selling Price over time

Customer Analysis

Customer Acquisition

Customer Acquisition
Customer AcquisitionCustomer Acquisition
Get instant insight on your new customers acquisition patterns: Number of new customers over time, new customers turnover evolution...

Customer Insight

Customer Insight
Customer InsightCustomer Insight
Get instant insight on your customers: Top customers, Evolution, Life Cycle

Customer Profitability (1)

Customer Profitability (1)
Customer Profitability (1)Customer Profitability (1)
Understand the profitability of your Sales

Customer Profitability (2)

Customer Profitability (2)
Customer Profitability (2)Customer Profitability (2)
Understand the profitability of your Sales

Customer Behavior (1)

Customer Behavior (1)
Customer Behavior (1)Customer Behavior (1)
Understand your Customer profitability profile and life cycle

Customer Behavior (2)

Customer Behavior (2)
Customer Behavior (2)Customer Behavior (2)
Understand your Customer behavior: Return purchase analysis

Customer Behavior (3)

Customer Behavior (3)
Customer Behavior (3)Customer Behavior (3)
Understand your Customer behavior: Helps identifying recurring customers who stopped buying

GeoAnalytics

Country Analysis

Country Analysis
Country AnalysisCountry Analysis
Visualize the performance of the KPI you selected at Country level

Trends Analysis

Trends Analysis

Trends Analysis
Trends AnalysisTrends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year

Evolution over years

Evolution over years
Evolution over yearsEvolution over years
Visualize how your top KPIs are correlated and how this correlation evolved across years

Trends Split Analysis

Trends Split Analysis
Trends Split AnalysisTrends Split Analysis
Visualize the evolution of the KPI you selected, breakdown by the dimension you selected.

Segmentation Analysis

Segmentation Analysis

Segmentation Analysis
Segmentation AnalysisSegmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)

Pareto Analysis

Pareto Analysis
Pareto AnalysisPareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)

KPI Performance

KPI Performance
KPI PerformanceKPI Performance
Visualize the overall performance of the selected KPI: evolution and breakdown by the dimension of your choice

 

You want to get a clear understanding on your Sales Performance? You want to build a Tableau dashboard based on SAP SD Data to better understand your Sales?

Using LinPack-for-Tableau.com, you can generate a stunning Tableau Dashboard on SAP Sales and Distribution in less than 1 minute!

 

SAP SD dashboard Live Demo

 

For this, just follow the instructions :-)

 

1st step: Create a Tableau workbook containing the connection definition to SAP-SD (from SAP:Orders or SAP:Invoices)

You must retrieve at least the following attributes:

  • date
    Billing Date Billing Date for Billing Index and Printout [VBKD.FKDAT | VBRK.FKDAT]
  • string
    Customer Sold-to party [VBAK.KUNNR | VBRK.KUNNR]
  • string
    Customer Group Customer Group [VBKD.KDGRP | VBRK.KDGRP]
  • string
    Country Country [KNA1.LAND1 | TVBUR.ADRNR]
  • string
    Distribution Channel Distribution Channel [VBAK.VTWEG | VBRK.VTWEG]
  • string
    Division Division [VBAP.SPART | VBRP.SPART]
  • string
    Sales Office Sales Office [VBAK.VKBUR | VBRP.VKBUR]
  • string
    Sales Group Sales Group [VBAK.VKGRP | VBRP.VKGRP]
  • string
    SalesRep SalesRep [VBAP.PVRTNR]
  • string
    Material Number Material Number [VBAP.MATNR | VBRP.MATNR]
  • string
    Material Group Material Group [VBAP.MATKL | VBRP.MATKL]
  • numeric
    Quantity | Volume Quantity / Volume [VBAP.VOLUM/KBMENG | VBRP.VOLUM/FKIMG]
  • numeric
    Sales Amount Amount of the document [VBAP.NETPR | VBAP.NETWR | VBRP.NETWR]
  • numeric
    Sales Cost Cost amount of the document [VBAP.WAVWR | VBRP.WAVWR]

 

2nd step: On LinPack-for-Tableau.com, select 'create dashboard from template: Sales' and upload your Tableau workbook

 

3rd step: Map your attributes, click 'Confirm & Download'... you're done!!!

 

This dashboard will help you to better manage your Sales performance: 

Just try it here :-)

 

Enjoy and share your feedbacks with us so we can improve the solution :-)

Other #DataViz Packs