CASE STUDY | CONSTRUCTION | POWER BI
Decision Inc UK. modernises Gleeson Homes’ data analytics capabilities with a comprehensive suite of Power BI dashboards.
Solution overview
Industry
Construction
Solution
Power BI
Location
United Kingdom
Client
Gleeson homes is a UK housebuilder operating predominately in the north of England building affordable, quality homes.
Requirement
Gleeson Homes was looking to reduce time spent on manual activities and becoming a data driven organisation.
The Client
Gleeson homes is a UK housebuilder operating predominately in the north of England building affordable, quality homes. Gleeson homes completed the sale of over 1,000 homes in 2020 despite the impact of the Coronavirus, with 71 active build sites and over 13,000 plots in the development pipeline.
The Requirement
In order to support the drive to become a more data-driven organisation Gleeson Homes engaged with specialist data and analytics consultancy Decision Inc. UK
The Engagement comprised multiple objectives, including:
Reduction in the reliance on manual spreadsheets, key person dependencies and multiple siloed views of the organisation.
Access to data within complex finance and supporting systems and the ability to present this information in an accessible & meaningful format.
Integration of data from external sources to further enrich the dataset.
Blending all of these data sources together into a holistic view of the organisation to make decisions based off empirical evidence over instinct.
Reducing the time to access data for decision making.
The Solution
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 the Power BI platform an organisation can ingest data from many disparate systems and files into a single, robust data model. Moreover, the vast array of ‘visuals’ on offer within the Power BI platform makes it the perfect tool for impactful dashboards to support to support any type of analysis.
Using Power BI’s native data preparation functionality the solution draws in data from:
Databases
This covers the ERP system and many other business applications
SharePoint Files
This provides additional data such as mappings or data not captured with an application.
SFTP Servers
These provide access to data in 3rd party applications which can then be integrated with existing organisational data sources.
Using Power BI all of this information is drawn into a central store which can then be refreshed multiple times a day all within the cheap licencing framework provide by Power BI Pro. Once the data has been collated and transformed, the team developed a comprehensive set of dashboards drawing on a wealth of visualisations to analyse and monitor:
The Sales Pipeline
from initial footfall and lead generation, through reservation, exchange and completion.
Customer Opinions
via conventional methods such as recommendations or Net Promoter Score through to understanding key themes within written feedback.
Construction progress
allowing early identification of any bottlenecks withing the process or opportunities for optimisation.
Defect Resolution
allowing workload prioritisation based off defect ageing, monitoring compliance with SLAs, alongside analysis of trends and recurring themes.
All of these dashboards are the presented to the end user in a single web-based portal where users can configure e-mail subscriptions to precise slices of the data or collaborate with colleagues using the intuitive comments pane.
The Outcome
The suite is currently being used by over 200 users across the organisation. Providing a single platform to analyse data from multiple different business functions, reducing the reliance on Excel spreadsheets, or the requirement to extract data from the source systems themselves
About Decision Inc.
Decision Inc. is a global digital partner that enables businesses to reinvent themselves to realise their full potential.
We deliver agility, resilience, and intelligence to any enterprise, enabling them to adapt quickly and thrive through innovation and opportunity. Our teams have engaged with more than 400 clients globally over the past 15 years, providing them with the expertise to build, operate, and optimise their digital businesses.
We achieve this by leveraging the world’s best technology to drive our client’s business ambitions forward into tomorrow’s reality. Our success is ultimately driven by our entrepreneurial culture, industry exposure, and the passion of our people. We have three key cross-functional teams – Functional and Specialist Consulting, Development, and Engineering teams.
Based in four global offices, our exceptional consultants focus on delivering value to clients by keeping them at the centre of our service delivery.