Business dashboard template: SCRAPS (QTY & COST)

dashboard template for tableau on Supply Chain & Production Quality & Production Scraps (qty & cost) cockpit

Providea workbookcontaining at least10 attributes

Geta ready-to-use,best-in-marketSCRAPS (QTY & COST) dashboard

Scraps (qty & cost) Home

Get a Home Page for your Scraps (qty & cost) dashboard

Scrap Cockpit

Get an overview of your scraps (Scrap Quantity, Scrap Costs, Scrap Rate, Produced Quantity, Produced Costs): How are we affected by Scraps? What are the top offenders?

Scraps (qty & cost) Top Performers

Get an instant understanding of your top Scraps (qty & cost) performers: current, mid and long term performance

Top Scrap Reasons (Cost-based)

Get a clear understanding of your top scrap reasons (cost-based)

10 required attributes

Date
Plant
Work Center
Material Category
Material
Scrap Reason
Scrap Quantity
Produced Quantity
Scrap Cost
Produced Cost

10 KPIs

11 dashboard pages

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

Scraps (qty & cost) Home

Get a Home Page for your Scraps (qty & cost) dashboard

Cockpit

Scrap Cockpit

Get an overview of your scraps (Scrap Quantity, Scrap Costs, Scrap Rate, Produced Quantity, Produced Costs): How are we affected by Scraps? What are the top offenders?

Scraps (qty & cost) Top Performers

Get an instant understanding of your top Scraps (qty & cost) performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Scrap Analytics (cost-based)

Top Scrap Reasons (Cost-based)

Get a clear understanding of your top scrap reasons (cost-based)

Scrap Breakdown Analysis (Cost-based)

Visualize the top offenders and their growth from one period to another

Scrap Evolution (Cost-based)

Visualize the evolution of your Scrap Rate, Scrap Cost and Produced Cost

Scrap Analytics (quantity-based)

Top Scrap Reasons (Quantity-based)

Get a clear understanding of your top scrap reasons (quantity-based)

Scrap Breakdown Analysis (Quantity-based)

Visualize the top offenders and their growth from one period to another

Scrap Evolution (Quantity-based)

Visualize the evolution of your Scrap Rate, Scrap Quantity and Produced Quantity

Behavioral Analytics

Scraps (qty & cost) Adhoc Analysis

Perform simple ad-hoc analysis on your Scraps (qty & cost) data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

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!

Scraps (qty & cost) dashboard Live Demo

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):

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

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).

Collapse All Expand All