High Level Design

Overview

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

Waste management - Corporate Social Responsibility dashboards

Goals

Minimize the amount of waste we generate.

Objectives

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

KPI Architecture

Objectives KPIs Measures Data Source
Lower Waste Reduction Rate, under 100% each month in 2016 for the different units we manufacture Waste Reduction Rate (Monthly / %) per Unit / Material
  • Wasted raw material cost ($) for current month
  • Wasted raw material cost ($) for past periods
  • Failed Production Rate (%)
 Production_Manufacturing, Purchasing_Raw_Material, Production_Unit_Spec

Data Requirements

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

Suggested data model for waste management analysis