A key component of a comprehensive Environmental Management System is an ongoing data collection and monitoring. Data is used to inform progress towards goals, identify trends, perform analysis and conduct sustainability planning and budgeting.
As useful as data can be, it can be equally cumbersome to
collect and process. To properly manage data and ensure its highest level of
quality, a process should be developed. The ISO 14001 framework for
Environmental Management Systems follows a Plan-Do-Check-Act cycle and can also
serve as a guide to data management, as outlined below.
The types of data that can be collected within this
framework are either qualitative or quantitative. Qualitative is also referred
to as dimensions or categories and can include metrics such as initiatives,
certifications, or geospatial coordinates. Quantitative data includes
indicators, such as energy consumption or greenhouse gas emissions. As a
general rule, if the data can be summed, it is quantitative data, otherwise it
data collection, a comprehensive strategy should be designed to ensure a
thorough approach. The bulk of the work is done during this phase. Begin by taking
an inventory of all qualitative and quantitative metrics that will be collected
and tracked. For each of these metrics, consider the following:
- Source of the metric. Determine the system and
owner of the data.
- Frequency of updates. The more regularly the
data is refreshed, the greater the ability to update. This may also require
increased storage capacity.
- Consistency amongst metrics. Although individual
assets may use different systems, data should be converted to the same unit and
scale to allow aggregation for a complete portfolio dataset.
- Amount of manipulation required. If data
requires calculations or conversions, this can create a potential opportunity
- Data quality. Consider the integrity of the
rawest form of data available to determine quality.
The last point is the most important. Ultimately, the
quality of reporting and calculations is dependent on the quality of the raw
material. If your input data is inaccurate, obsolete or incorrect, so will be
Several approaches to data collection exist and the best
option will depend on the data management system’s architecture and
capabilities. One option is to manually extract data by exporting each source
as many times as necessary, then store in Excel files. This requires a
continuous time input to extract, store and version every metric.
An alternative is to design a data management system that
will collect data automatically, by creating and scheduling data flows between source
and storage. This type of system is typically administered by a third-party.
Monitor the project advancement at regular intervals to verify
data quality. Data quality can be checked against previous time intervals or
industry norms. If anomalies are identified, revisit the process of data
collection and raw source of data to ensure that any issue is systematically
corrected to avoid further data quality problems.
An additional layer of data quality check or assurance can
be conducted by a third-party. This is referred to as data verification or data
assurance. A third-party who is not involved in the data management process
should conduct data verification.
At this point, data is collected, cleaned and ready for
exploration. Utilize a reporting system to analyze and interpret the data.
Reports should be designed for actionable decisions and meaningful insights and
should be delivered to internal and external stakeholders who can use the data
to drive change, improve performance, and gain insight. Reports should offer
broader context and be provided at regular intervals to accurately measure
CodeGreen Solutions, Inc. was founded in 2006 in Manhattan and has provided sustainable building solutions to a total of over 250 million square feet nationwide. CodeGreen is an employee owned and privately held company. CodeGreen establishes long-term relationships with building owners, managers, operators, and occupants to develop innovative and creative solutions to achieve sustainability goals, reduce energy costs and overall environmental footprint. CodeGreen assists building owners to maximize project profitability through the sourcing of available federal and state financial incentives for sustainable and energy efficient initiatives.
This article is written by Raphael Lalou, Director, Data Practice; and Karen Mahrous, Associate Director of Corporate Sustainability, CodeGreen Solutions