Case Study: Delivering Insight from Waste Data

This article is part of a series of selected ESG case studies submitted by participants in the 2017 GRESB Real Estate Assessment.

We have formed a successful partnership with Capita identifying innovative ways of reducing consumption, we now need to continue this good work with further improvements. Kevin Bould, RLAM

Purpose of the project

To support RLAM’s sustainability strategy, which includes a commitment to improving resource efficiency and waste management, by developing an analytical tool to report trends in waste generation and disposal methods.


In order to really drive resource efficiency, it is important to be able to establish a baseline per property and a means for evaluating performance over time. Whilst waste contractors may be able to provide actual (weighed) or estimated data, there are a number of contractors across a portfolio, so it is very difficult to show trends consistently without such a tool or purchasing a web based portal/data management system.
Capita Environment Consultancy developed an automated reporting tool, which takes large quantities of waste data and turns it into useful reports with infographics. The reporting output enables monitoring of trends over time in:

  • overall waste generation,
  • specific types of waste production,
  • the distribution of waste consumption and
  • waste treatment methods.

In addition, Capita’s environmental consultants provide bespoke commentary on the quality of data, arising data trends and suggestions for improvement.


This bespoke solution is informed by consistent waste treatment data, which is collected in a web based portal called Meridian, which we export to Excel. Waste data on the spreadsheet informs Macros which populate the graphics and report. This approach has been applied since 2015 to the UK based properties where Capita (the Managing Agent) is responsible for waste management. The reports were reported to both the client (Royal London), property managers and the tenants periodically. Capita’s waste analysis tool and reports have been used to support waste management for a number of sites, where data may have historically been collected but not utilised to deliver insights and inform actions. The reports are also provided to tenants and discussed, to support waste management and cost saving opportunities. The development of the tool reflects a wider movement towards using Big Data to drive sustainable agendas and actions.


Key success is visual representation of data to increase understanding and engagement. This solution bridges the gap between data collection and online/real time data presentation when budgets do not allow investment in the latter. It is flexible to support Fund level down to property or tenant level reporting where the data exists. It requires data to be provided in a specified and agreed format, however, the waste industry is increasingly able to provide this.


2015 RLAM Sustainability Report
This case study was submitted by Royal London Asset Management.

Related insights