Providea workbookcontaining at least7 attributes
Geta ready-to-use,best-in-marketPURCHASING dashboard
Purchasing Home
Purchasing Home![Purchasing Home]()
Get a Home Page for your Purchasing dashboard
Procurement Cockpit
Procurement Cockpit![Procurement Cockpit]()
Gain full spend visibility on your Procurement process
Purchasing Top KPIs Evolution
Purchasing Top KPIs Evolution![Purchasing Top KPIs Evolution]()
Visualize how your Purchasing KPIs are evolving (Month-to-Date, Year-to-Date)
Item Average Buying Price
Item Average Buying Price![Item Average Buying Price]()
Visualize the evolution of the Product Average Buying Price over time
7 required attributes
Date
Supplier- Item / Product
- Purchasing Category
- Buyer / Purchaser
Purchased Amount- Purchased Quantity
8 KPIs
- Total Purchased Amount
- Total Purchased Quantity
- Dist. Items Purchased #
- Active Suppliers #
- Buyers #
- Average Unit Price
- Amount per Supplier
- Amount per Buyer
Detailed presentation of the PURCHASING dashboard
Your PURCHASING dashboard will contain 8 KPIs
- Total Purchased AmountSum of purchased amount
- Total Purchased QuantitySum of purchased quantity
- Dist. Items Purchased #Number of distinct items purchased during the period
- Active Suppliers #Number of distinct suppliers having a purchase transaction during the period
- Buyers #Number of distinct active buyers during the period
- Average Unit PricePurchased Amount / Purchased Quantity (expressed in currency)
- Amount per SupplierPurchased Amount / Number of Suppliers (expressed in currency)
- Amount per BuyerPurchased Amount / Number of Buyers (expressed in currency)
and 10 dashboard pages
Home
Purchasing Home
Purchasing Home![Purchasing Home]()
Get a Home Page for your Purchasing dashboard
Cockpit
Procurement Cockpit
Procurement Cockpit![Procurement Cockpit]()
Gain full spend visibility on your Procurement process
Purchasing Top KPIs Evolution
Purchasing Top KPIs Evolution![Purchasing Top KPIs Evolution]()
Visualize how your Purchasing KPIs are evolving (Month-to-Date, Year-to-Date)
Purchasing Top KPIs Overview
Purchasing Top KPIs Overview![Purchasing Top KPIs Overview]()
Get a transversal view on your top 6 Purchasing KPIs, split by the dimension of your choice
Item / Product Analysis
Item Average Buying Price
Item Average Buying Price![Item Average Buying Price]()
Visualize the evolution of the Product Average Buying Price over time
Price vs Volume
Price vs Volume![Price vs Volume]()
Quickly figure out which products you are not buying at the right price compared to previous year
Supplier Analysis
Supplier Dependencies
Supplier Dependencies![Supplier Dependencies]()
Optimize your procurement strategy by quickly figuring out the number of distinct suppliers you have for the items your purchase
Distribution Analysis
Purchasing Segmentation Analysis
Purchasing Segmentation Analysis![Purchasing Segmentation Analysis]()
Visualize the value of any of your Purchasing KPIs, split by the dimension you selected (market share analysis)
Purchasing Pareto Analysis
Purchasing Pareto Analysis![Purchasing Pareto Analysis]()
Perform a Pareto Analysis on any of your Purchasing KPIs: the 80/20 rule.
Purchasing KPI Performance
Purchasing KPI Performance![Purchasing KPI Performance]()
Visualize the overall performance of any of your Purchasing KPIs: what is the performance, how does this performance evolve, who contributes to this performance
Creating your PURCHASING dashboard Step-by-Step
You want to get a clear understanding on your Purchasing results? You want to build a Tableau dashboard to better understand your Purchasing data?
Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Purchasing data in less than 5 minutes!
1st STEP: Create the initial Tableau workbook file
Create a Tableau workbook in which you map your Purchasing 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
-
Supplier Name of your supplier
-
Item / Product Purchased item: product, service…
-
Purchasing Category Purchasing category
-
Buyer / Purchaser Buyer name, Buying unit...
-
Purchased Amount Amount of the purchase
-
Purchased Quantity Quantity purchased
2nd STEP: Upload your Tableau workbook file
On LinPack-for-Tableau.com, select 'create dashboard from template: Purchasing' and upload your Tableau workbook (note: your data is NOT uploaded).
Dashboard Template
- Predefined (and customizable) KPIs
- Predefined DataViz
Finance
Procurement
Digital Marketing
Processes
Case Management
Banking
Healthcare
Telecommunications
Fundraising
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Purchasing dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Purchasing dashboard is now ready to be used or customized!
Just give it a try here :-)
