
Date
Plant
Work Center
Material Category
Material
Scrap Reason
Scrap Quantity
Produced Quantity
Scrap Cost
Produced Cost
- Scraps (qty & cost) Home
- Scrap Cockpit
- Scraps (qty & cost) Top Performers
- Top Scrap Reasons (Cost-based)
- Scrap Breakdown Analysis (Cost-based)
- Scrap Evolution (Cost-based)
- Top Scrap Reasons (Quantity-based)
- Scrap Breakdown Analysis (Quantity-based)
- Scrap Evolution (Quantity-based)
- Scraps (qty & cost) Adhoc Analysis
- Top 4 KPIs Trends (MTD/YTD)
Required Attributes
To get your Scraps (qty & cost) dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):
- Date Date (Date used for time-series analysis)
- Plant Plant name
- Work Center Work Centre
- Material Category Material Category, Type..
- Material Material
- Scrap Reason Scrap Reason, Defect Type...
- Scrap Quantity Scrap Quantity
- Produced Quantity Produced Quantity
- Scrap Cost Scrap Cost
- Produced Cost Produced Cost
KPIs
Your SCRAPS (QTY & COST) dashboard will contain 10 KPIs
- Scrap Rate (quantity-based)Scrap Rate based on quantity: Total Scrap Quantity / Total Processed Quantity
- Total Scrap QuantityTotal scrap quantity
- Daily Scrap QuantityAverage scrap quantity per day
- Total Produced QuantityTotal producted quantity
- Total Processed QuantityTotal processed quantity (Produced Quantity + Scrap Quantity)
- Scrap Rate (cost-based)Scrap Rate based on quantity: Total Scrap Cost / Total Processed Cost
- Total Scrap CostTotal scrap cost
- Daily Scrap CostAverage scrap cost per day
- Total Produced CostTotal produced cost
- Total Processed CostTotal processed cost (Produced Cost + Scrap Cost)
Dashboard Pages & Data Visualizations
Your Scraps (qty & cost) dashboard will contain 11 pages
Home
Cockpit
Scrap Cockpit
Scraps (qty & cost) Top Performers
Scrap Analytics (cost-based)
Top Scrap Reasons (Cost-based)
Scrap Breakdown Analysis (Cost-based)
Scrap Analytics (quantity-based)
Top Scrap Reasons (Quantity-based)
Scrap Breakdown Analysis (Quantity-based)
Creating your SCRAPS (QTY & COST) dashboard Step-by-Step
You want to get a clear understanding on your Scraps (qty & cost) results? You want to build a Tableau dashboard to better understand your Scraps (qty & cost) data?
Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Scraps (qty & cost) data in less than 5 minutes!
1st STEP: Create the initial Tableau workbook file
Create a Tableau workbook in which you map your Scraps (qty & cost) 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):
2nd STEP: Upload your Tableau workbook file
On LinPack-for-Tableau.com, select 'create dashboard from template: Scraps (qty & cost)' 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 Scraps (qty & cost) dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Scraps (qty & cost) dashboard is now ready to be used or customized!