dashboard template for tableau on ERP & CRM SAP SAP MM cockpit

Detailed presentation of the SAP MM dashboard

Your SAP MM dashboard will contain 10 KPIs

and 11 dashboard pages

Home

SAP MM Home

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

Cockpit

SAP MM Cockpit

SAP MM Cockpit
SAP MM CockpitSAP MM Cockpit
Gain full spend visibility on your purchasing process

SAP MM Top Performers

SAP MM Top Performers
SAP MM Top PerformersSAP MM Top Performers
Get an instant understanding of your top SAP MM performers

Top 4 KPIs Trends (MTD/YTD)

Top 4 KPIs Trends (MTD/YTD)
Top 4 KPIs Trends (MTD/YTD)Top 4 KPIs Trends (MTD/YTD)
Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Purchasing Analytics

Top Items - Pricing Analysis

Top Items - Pricing Analysis
Top Items - Pricing AnalysisTop Items - Pricing Analysis
Purchasing performance of your top items: Purchasing Volume, Average Buying Price & Variation, Savings, Number of Suppliers

Supplier Dependencies

Supplier Dependencies
Supplier DependenciesSupplier Dependencies
Optimize your procurement strategy by quickly figuring out the number of distinct suppliers you have for the items your purchase

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

Consistency between Price & Volume

Consistency between Price & Volume
Consistency between Price & VolumeConsistency between Price & Volume
Overview of the evolution of Average Buying Price by Product compared to the evolution of Total Purchase Quantity over the same period

Items Purchasing Classification

Items Purchasing Classification
Items Purchasing ClassificationItems Purchasing Classification
Instant classification of your purchased items by Volume & Price Volatility

Item Detail

Item Detail
Item DetailItem Detail
Get an efficient overview of the purchasing history of a given item/product: Min/Max Prices, Vendors, evolution of Prices, evolution of Volume...

Behavioral Analytics

SAP MM Adhoc Analysis

SAP MM Adhoc Analysis
SAP MM Adhoc AnalysisSAP MM Adhoc Analysis
Perform simple ad-hoc analysis on your SAP MM data set: analyze any of your KPIs across any dimension

Creating your SAP MM dashboard Step-by-Step

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

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

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your SAP MM 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
    Date Document Date [EKKO.BEDAT] (Date used for time-series analysis)
  • string
    Vendor Name of the Vendor [LFA1.NAME2]
  • string
    Product Purchased item: product, service… [MAKT.MAKTX]
  • string
    Purchasing Category Purchasing category [T134T.MTBEZ]
  • string
    Buyer / Purchaser Buyer name, Buying unit... [T024.EKNAM]
  • numeric
    Purchase Amount Amount of the purchase [EKPO.NETWR]
  • numeric
    Purchase Quantity Quantity purchased [EKPO.MENGE]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: SAP MM' 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 MM dashboard is already downloading :-)

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

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


Other DataViz Packs