Case Studies | PropTech

Replacing fragile spreadsheets with a governed data platform

Commercial property developer

About

A PropTech business working with Cloud Combinator on AWS. The client is anonymised at their request.

Challenge

The challenge had three focus areas, each a direct source of risk and lost time.

Fragile links between workbooks

Site workbooks feed the Corporate Model through external-link cell formulas that break whenever a file is renamed or moved. A single broken link can silently corrupt consolidated numbers, and tracing the fault costs analysts hours.

Manual copy-paste of actuals

Actual costs are copied by hand from Sage or NetSuite into Excel. This is slow, error-prone and impossible to audit reliably, so the numbers driving decisions carry avoidable uncertainty.

No scalability or version control

With each of the 20 to 25 live sites kept in its own continuously updated workbook, onboarding a new site means cloning spreadsheets, and multiple local copies reintroduce version chaos. The current approach simply does not scale with the portfolio.

Solution

We structured the work in two phases so the client would feel relief quickly, while a durable foundation was built in parallel. Crucially, analysts stay in Excel throughout.

20-25

Live site models to be consolidated

4-6 wks

Phase 1 stabilisation timeline (projected)

3-6 mths

Phase 2 platform timeline (projected)

By the numbers:

  • 20-25 - Live site models to be consolidated
  • 4-6 wks - Phase 1 stabilisation timeline (projected)
  • 3-6 mths - Phase 2 platform timeline (projected)
Changes

The proposed solution is designed to remove manual entry, surface hidden errors early and make the reporting estate scale cleanly with the portfolio, all while keeping analysts in the familiar Excel workflow. The figures below are proposed estimates from the engagement plan rather than measured results.

  • Manual entry disappears — Data travels straight from the accounting API into Excel and Power BI, replacing hand copy-paste with an one-click refresh.
  • Links that survive change — Power Query imports from a SharePoint source, keyed on file ID rather than path, so renames and moves no longer break consolidation.
  • Hidden errors surface early — Dependency diagrams and warehouse data-quality checks flag issues before they reach a decision.
  • Scalability built in — Onboarding a new site becomes a single row in the Sites dimension, not another cloned workbook.
  • Handover — A master template, rollout playbook and training are proposed so the client's team can extend the approach across the remaining sites themselves.

The phased design lets the client realise quick, low-risk wins in Excel first, then progress to a governed platform that can feed dashboards and future applications as the portfolio grows. These are the intended forward directions set out in the proposal rather than delivered outcomes.

AWS Stack

Azure Data Factory

For nightly ingestion of actuals, budgets and forecasts.

Azure Data Lake Storage

For a cheap, versioned landing zone.

Microsoft Entra ID

For securing Excel and OData connectivity to the platform.

YOU MIGHT LIKE

Related success stories

View all case studies

CONTACT US

Ready to turn AI into impact?

We'll help you spot the highest-value opportunities, reduce risk around your first AI initiative, and define a clear path to results from day one.

  • Outcome-driven recommendations
  • AWS-recognised delivery expertise
  • Risk-aware AI adoption
  • Clear next step, not a sales pitch

Start with a focused 20-minute conversation about your goals. No pressure, no commitment.

Schedule a free consultation

This website uses cookies to enhance user experience and to analyze performance and traffic on our website.

See our Privacy Policy for details.