/uploads/galerie/000001/Sales Cockpit.png

Detailed presentation of the SAP SD dashboard

Your SAP SD dashboard will contain 11 KPIs

and 13 dashboard pages

Home

SAP SD Home

SAP SD Home
SAP SD HomeSAP SD Home
Get a Home Page for your SAP SD dashboard

Cockpit

SAP SD Cockpit

SAP SD Cockpit
SAP SD CockpitSAP SD Cockpit
Get a 360° view of your Sales performance

SAP SD Top KPIs Breakdown

SAP SD Top KPIs Breakdown
SAP SD Top KPIs BreakdownSAP SD Top KPIs Breakdown
Get a transverse view on your top 6 SAP SD KPIs, split by the dimension of your choice

SAP SD Top KPIs Evolution

SAP SD Top KPIs Evolution
SAP SD Top KPIs EvolutionSAP SD Top KPIs Evolution
Visualize how your SAP SD KPIs are evolving (Month-to-Date, Year-to-Date)

Sales Analytics

Product Performance

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

Customer Insight

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

Customer Lifetime Value & Churn Rate

Customer Lifetime Value & Churn Rate
Customer Lifetime Value & Churn RateCustomer Lifetime Value & Churn Rate
Predict of the revenues and profit attributed to the entire future relationship with a customer. Customer lifetime value can also be defined as the monetary value of a customer relationship. Measure your (in)ability to retain customers.

Price Volume Mix Analysis

Price Volume Mix Analysis
Price Volume Mix AnalysisPrice Volume Mix Analysis
Price Volume Mix variance analysis enhances standard variance analyses by decomposing how volume or pricing changes of our product assortment contributed to the difference in performance between the Actual and Reference values

Behavioral Analytics

SAP SD KPI Performance

SAP SD KPI Performance
SAP SD KPI PerformanceSAP SD KPI Performance
Visualize the overall performance of any of your SAP SD KPIs: what is the performance, how does this performance evolve, who contributes to this performance

GeoAnalytics

SAP SD Country Analysis

SAP SD Country Analysis
SAP SD Country AnalysisSAP SD Country Analysis
Visualize the performance of any of your SAP SD KPIs, at Country level

Trends Analytics

SAP SD Trends Analysis

SAP SD Trends Analysis
SAP SD Trends AnalysisSAP SD Trends Analysis
Visualize the evolution of any of your SAP SD KPIs: Trends, Performance & Year over Year

Distribution Analytics

SAP SD Segmentation Analysis

SAP SD Segmentation Analysis
SAP SD Segmentation AnalysisSAP SD Segmentation Analysis
Visualize the value of any of your SAP SD KPIs, split by the dimension you selected (market share analysis)

SAP SD Pareto Analysis

SAP SD Pareto Analysis
SAP SD Pareto AnalysisSAP SD Pareto Analysis
Perform a Pareto Analysis on any of your SAP SD KPIs: the 80/20 rule.

Creating your SAP SD dashboard Step-by-Step

You want to get a clear understanding on your SAP SD results? You want to build a Tableau dashboard to better understand your SAP SD data?

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

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your SAP SD 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):

  • date
    Billing Date Billing Date for Billing Index and Printout [VBKD.FKDAT | VBRK.FKDAT] (Date used for time-series analysis)
  • 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
    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: Upload your Tableau workbook file

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

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your SAP SD dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your SAP SD dashboard is now ready to be used or customized!


Other #DataViz Packs