Centralised Compliance Monitoring Dashboard

A portfolio-wide monitoring system for tracking operational compliance across multiple estates.

SQLBigQueryHexGoogle Sheets Sync Compliance MonitoringEstate OperationsPortfolio OversightOperational Risk

Outcome: Enabled proactive detection of compliance gaps by consolidating operational signals into a single monitoring system.

Problem

Compliance signals such as council meetings, water readings, and license renewals were tracked across multiple fragmented tools.

This created operational blind spots and delayed issue detection.

Approach

I designed a centralised monitoring dashboard integrating multiple operational datasets into a single analytical layer. Scheduled queries detect missing records and surface potential compliance risks.

Impact

Operational teams can now detect compliance gaps early, shifting estate management workflows from reactive to preventative.