a
Case Study Construction Power BI Data Analytics

Decision Inc. UK Modernises
Gleeson Homes' Data Analytics Capabilities

Client
Gleeson Homes (MJ Gleeson PLC)
Industry
Construction
Location
United Kingdom
Solution
Power BI

The Requirement

Gleeson Homes needed to reduce reliance on manual spreadsheets, eliminate siloed data views, and become a truly data-driven organisation — with unified access to finance, construction, sales, and customer insights.

The Solution

Decision Inc. UK implemented Power BI to ingest data from databases, SharePoint, and SFTP servers into a single data model — delivering four comprehensive dashboard suites covering sales, customers, construction, and defects.

The Impact

The Power BI suite is now used by over 200 users across the organisation, providing a single platform for multi-function data analysis and eliminating reliance on Excel spreadsheets and manual source-system extracts.

01 · The Client

A UK Housebuilder Building Affordable Homes

Gleeson Homes is a UK housebuilder operating predominantly in the north of England, building affordable, quality homes. Despite the impact of the Coronavirus pandemic, Gleeson Homes completed the sale of over 1,000 homes in 2020 with 71 active build sites and over 13,000 plots in the development pipeline.

To support their drive to become a more data-driven organisation, Gleeson Homes engaged with specialist data and analytics consultancy Decision Inc. UK — seeking a comprehensive solution that would unify their data estate and reduce reliance on manual processes.

Gleeson Homes Construction
Upload cs_gleeson_overview.jpg
02 · The Requirement

From Spreadsheets to Data-Driven Decisions

The engagement comprised multiple objectives, all centred on eliminating manual overhead and giving Gleeson Homes a single, trusted view of its business — across finance, sales, construction, and customer operations.

  • Reduce reliance on manual spreadsheets, key person dependencies, and multiple siloed views of the organisation
  • Access data within complex finance and supporting systems, and present it in an accessible and meaningful format
  • Integrate data from external sources to further enrich the dataset
  • Blend all data sources into a holistic view of the organisation to support decisions based on empirical evidence over instinct
  • Reduce the time to access data for decision-making
House Construction Frame
Upload cs_gleeson_build.jpg
03 · The Solution

Power BI as the Single Source of Truth

Drawing on a wealth of experience in data and analytics, Decision Inc. UK presented Power BI as the platform best suited to the needs of Gleeson Homes. Using Power BI, an organisation can ingest data from many disparate systems and files into a single, robust data model. The vast array of visuals available within Power BI makes it the ideal tool for impactful dashboards to support any type of analysis.

Using Power BI's native data preparation functionality, the solution draws in data from three distinct source types — all refreshed multiple times a day within the cost-effective Power BI Pro licensing framework:

Databases

Covers the ERP system and many other business applications — the primary source for transactional and operational data across the organisation.

SharePoint Files

Provides additional data such as mappings or data not captured within an application — enabling manual inputs and reference tables to be blended seamlessly.

SFTP Servers

Provides access to data in third-party applications which can then be integrated with existing organisational data sources — eliminating manual exports from external systems.

Once the data was collated and transformed, the team developed a comprehensive set of dashboards drawing on a rich suite of Power BI visualisations. All dashboards are presented to end users in a single web-based portal, with configurable email subscriptions to precise data slices and intuitive collaboration via the comments pane.

Dashboard Suites Delivered

The Sales Pipeline

End-to-end visibility from initial footfall and lead generation, through reservation, exchange, and completion — enabling data-driven sales management across all active sites.

Customer Opinions

Captures both conventional metrics such as recommendations and Net Promoter Score, and unstructured analysis of key themes within written customer feedback.

Construction Progress

Provides real-time visibility of build progress across all 71 active sites, enabling early identification of bottlenecks in the process and opportunities for operational optimisation.

Defect Resolution

Enables workload prioritisation based on defect ageing, monitors compliance with SLAs, and supports analysis of trends and recurring defect themes to drive quality improvements.

04 · The Outcome

200+ Users on a Single Analytics Platform

The Power BI suite is currently used by over 200 users across the organisation, providing a single platform to analyse data from multiple different business functions — reducing reliance on Excel spreadsheets and eliminating the requirement to extract data from source systems directly.

200+
Users Across the Organisation Gleeson Homes now has a single, unified analytics platform delivering self-service insight to over 200 users — from sales and construction teams to finance and customer operations — all from one web-based Power BI portal.
  • Single Power BI platform replacing fragmented Excel spreadsheets and siloed reporting
  • Data from ERP, SharePoint, and SFTP servers blended into one unified model
  • Multiple daily data refreshes keeping all 200+ users on current information
  • Sales pipeline tracked end-to-end from footfall through to completion
  • Customer feedback analysed quantitatively and qualitatively via NPS and theme extraction
  • Construction bottlenecks identified proactively across 71 active build sites
  • Defect SLA compliance monitored and recurring themes surfaced to drive quality improvement
  • Email subscriptions to precise data slices configured per user, reducing report distribution overhead
Gleeson Homes Power BI Outcome
Upload cs_gleeson_outcome.jpg