High Level Design
OverviewMeasuring and monitoring the amount of waste a company generates can give it insight into the efficiency and effectiveness of its operations as well as their environmental and social impact. Understanding trends, main root causes and other insights from analyzing this data will enable the organization to focus on the most crucial improvements that need to be made.
Dashboard Example (sample data)Click on the image to open and interact with the dashboard:
Minimize the amount of waste we generate.
- Lower Waste Reduction Rate, under 100% each month in 2016 for the different units we manufacture.
- Lower Waste Reduction Rate, under 100% each month in 2016 for the different materials we use in production.
|Lower Waste Reduction Rate, under 100% each month in 2016 for the different units we manufacture||Waste Reduction Rate (Monthly / %) per Unit / Material||
||Production_Manufacturing, Purchasing_Raw_Material, Production_Unit_Spec|
|#||Source||Table Name||Table Details (type, # rows, key fields)|
|1||Manufacturing||Production_Manufacturing||How many units produced (pass/fail) each month.|
|2||Billing System||Purchasing_Raw_Material||For each material and supplier, the amount of tonnes purchased each month and their price.|
|3||Product||Production_Unit_Spec||Amount of materials needed to produce each unit.|
Data Modeling (Elasticube Design)