The problem

Data piles up, but nobody uses it

A mid-sized property portfolio manager typically runs 5 to 8 different tools: a lettings management system, a CRM, an accounting package, tracking spreadsheets, an invoicing tool. Each one produces its own exports, in its own formats, according to its own logic.

The result: producing a consolidated report takes time, creates reconciliation errors, and depends on the handful of people who know how to join the Excel files together. Management steers with a two-to-four-week lag on what is actually happening in the field.

Across our deployments, the average delay between a data point being collected and it being available for decision-making is 2 to 3 weeks.With a connected dashboard, that drops to under 24 hours — often to real time.

This is not a problem of data volume. It is an architecture problem: the data is there, it is simply not structured to be read by humans without manual handling.

Dashboard types

Five priority dashboards for real estate

Depending on the profession and the scope of decisions, visualisation needs differ. These are the five dashboard types we deploy most often across the real estate value chain.

Asset Management
Portfolio dashboard
A consolidated view of the assets: value, yield, occupancy, works in progress, lease expiries. Filterable by asset class, location and manager.
Reporting 2 wks → 2h
Lettings
Vacancy dashboard
Vacancy rate by unit, by building, by manager. Average vacancy duration, alerts on units past threshold. Tracking of open follow-ups.
Real-time visibility
Agencies & Property mgmt
Sales performance dashboard
Active mandates, conversion rate, average time to sell, revenue per agent. Comparison by period and by team member.
Daily steering
Developers
Programme dashboard
Phase progress, reservations vs targets, sell-through rate, updated forecast margin. Per-programme and consolidated views.
Board meeting in 15 min
Compliance & Legal
Regulatory compliance dashboard
Tracking of mandatory surveys, validity dates, expiry alerts. Coverage for energy performance, asbestos, lead and electrical checks across the portfolio.
Zero omissions

Technical stack

What we connect and how

A useful dashboard starts with a reliable connection to the data sources. In real estate, those sources are often heterogeneous: proprietary line-of-business software, poorly documented APIs, Excel files shared on a network drive, manual CSV exports. That is where our work begins.

01
Source inventory and qualification
We map every available data source: line-of-business software, accounting exports, Google Sheets, field files. We qualify each one for reliability, refresh frequency and structure.
02
Collection and normalisation (ETL)
We build the pipelines that extract the data, transform it into a unified format and load it into a data warehouse. The pipeline runs automatically — no more manual handling.
03
Modelling the business metrics
We work with your teams to define exactly what "vacancy rate", "time to sell" or "net margin" means in your context. The metrics are documented and shared.
04
Building the dashboard
We build the views on whichever tool fits your organisation: Metabase, Power BI, Looker Studio, or a bespoke web interface. Each view is designed for one specific user profile: director, manager, analyst.
05
Training and autonomy
Your teams learn to read, filter and act on the dashboards. We document the metrics and train the key users so that dependence on IT stays minimal.

Beyond the dashboard

From reporting to augmented decisions

A dashboard makes data readable. But the real value arrives when AI starts analysing that data for you: spotting an anomaly in a vacancy rate before you see it, flagging a tenant likely to leave based on their payment history, or automatically drafting the narrative commentary for the board report.

Anomaly detection
AI alerts on your metrics
An agent watches your KPIs and alerts you proactively when a metric moves outside its normal range — without you having to open the dashboard.
Proactive vs reactive
Automated narrative
Generated report commentary
From the dashboard data, an agent writes the summary commentary for the monthly or quarterly report. Your directors review it; they no longer write it.
3h → 15 min
Forecasting
Forecasting on key metrics
Vacancy projected 90 days out, end-of-quarter sales performance estimated, lease expiries anticipated. From historical data to decisions made ahead of time.
Decide 90 days early

Across our deployments, moving from manual monthly reporting to a connected dashboard with AI narrative cuts the time spent producing reports by 90% — and raises the steering cadence from monthly to weekly, sometimes daily.

What to take away

Where to start

A dashboard project always starts from the same observation: find one recurring decision that takes too long to prepare, or one blind spot that generates errors or delays. That is where the ROI is.

We do not recommend launching a six-month “global data warehouse” programme. We deploy a first dashboard on one precise use case in two to four weeks, measure how it gets used, and extend from there. The value shows up in the first few weeks — not after a full IT transformation.

Map your data potential in 30 minutes

Together we identify the data available, the decisions worth accelerating and the first dashboard to deploy. We bring a mock-up of your own use case to the meeting.

Book a data review →Write to us