Case Study

ESG Data Standardization and Cleansing: Improving Data Quality and GRESB Readiness Across a Global Real Estate Portfolio

Client Snapshot

Industry:

Global Real Estate Investment Management

Location:

Florida, USA

Scale:

$100B+ in assets under management

Portfolio Context:

200 hotels; 1,500+ assets across diverse classes

Key Highlights

GRESB Readiness:

Supported 2023 GRESB benchmarking utility data requirements

Data Audit:

Historical audit across 1,500+ assets and multiple asset classes

Data Quality:

35% improvement in data quality and reliability

Sustainment:

Ongoing ESG matrix reporting for acquisitions and dispositions

Client Background

The client is a Florida-based investment firm specializing in global real estate, managing over $100 billion in assets and recognized with 40+ awards in the Private Equity Real Estate (PERE) sector. As ESG reporting expectations grew, the firm needed a reliable, structured ESG and demographic dataset across assets, supported by traceable sources and consistent definitions.

The existing repository warehouse contained cluttered, unorganized, and inaccurate records with unclear source references. OHI was engaged to standardize key ESG data points, document source traceability, and improve the usability of existing repository tools through systematic cleansing and governance.

Business Challenge

Evolving ESG requirements and inconsistent source documents created standardization issues, sourcing delays, and unreliable repository data.

Changing ESG Requirements

As ESG expectations evolved, data needs changed frequently, requiring repeated reviews and updates.

Data Standardization Across Documents

Different reports used varied definitions, units, and formats for the same data points, complicating standardization.

Document Procurement and Source Gaps

Required reports were distributed across multiple sources, delaying extraction and increasing completeness risk.

Repository Data Quality and Traceability

The central repository contained inaccurate and unorganized data with unclear sourcing, limiting confidence in reporting outputs.

Evolving benchmarks and inconsistent documentation created repeated rework and reduced confidence in ESG reporting outputs. The client required a structured data dictionary, source traceability, and a repeatable audit-and-maintain process to sustain data quality over time.

OHI's Approach & Solution

Training and Standard Procedures

  • Provided comprehensive training to align the ESG consultant with the client’s benchmark requirements
  • Established standard procedures for extraction, validation, and documentation of ESG data points

Defined Data Points and Source Traceability

  • Standardized each ESG and demographic data point across report types
  • Documented each result with its source reference to support future audits and reviews

Cross-Functional Collaboration

  • Coordinated with multiple departments to resolve inaccuracies and complete missing data points
  • Improved repository usability by cleansing records and applying consistent structures

Governance Cadence

  • Held weekly meetings with relevant stakeholders to track requirements, validate updates, and manage evolving expectations
  • Maintained periodic reporting to monitor changes and ensure ongoing accuracy

Results & Impact

KPIBefore OHIAfter OHIImprovement
GRESB Benchmarking ReadinessUtility data requirements difficult to support at scalePortfolio utility data structured for benchmarkingAligned to 2023 GRESB needs
Repository Data QualityCluttered, unorganized, inaccurate repository recordsCleansed data with standardized definitions35% quality improvement
Historical Data Audit CoverageLimited confidence in legacy recordsHistorical audit completed across 1,500+ assetsInaccuracies identified and corrected
Source TraceabilityUnclear sources for stored dataDocumented data points with source referencesAudit-defensible repository
Ongoing ESG ReportingPeriodic reporting inconsistentMaintained ESG matrix reports for acquisitions/dispositionsSustained governance
Operational EfficiencyHigh rework from inconsistent definitionsCost-effective processing procedures implementedImproved throughput and accuracy

OHI established a standardized ESG data framework with clear source traceability, improving repository usability and reporting confidence. The engagement strengthened GRESB readiness, delivered measurable data quality improvements, and put in place an ongoing governance cadence to sustain accuracy as requirements evolved.

“OHI helped us bring structure and traceability to ESG data at scale. Their standardization approach improved data quality, strengthened benchmarking readiness, and reduced rework.”

Florida-Based Global Real Estate Investment Firm

CEO

Make ESG reporting audit-ready with standardized, traceable data

Improve data quality, reduce rework, and stay benchmark-ready with structured ESG data cleansing and governance.

Certificates And Memberships