The Challenge
A prominent UK construction company faced challenges in offering site managers real-time insights into project costs and schedules. The existing system depended heavily on manual inputs and was prone to errors, leading to delays in decision-making and resource allocation. Site managers required an efficient solution to keep track of project progress and financial health, reducing reliance on outdated data and enhancing project outcomes.
The Solution
Adyantrix delivered a bespoke Construction Project Intelligence Dashboard, tailored specifically for this client's needs in managing site operations more dynamically. Our team engaged in a thorough analysis of the current systems and identified key areas where technology could transform processes.
We built a user-friendly, cloud-based dashboard that integrated data from various sites, offering real-time visibility into project costs and schedules. Leveraging advanced analytics and data visualisation techniques, the dashboard provided site managers with up-to-the-minute insights. Key features included automated data integration, predictive analytics for project forecasting, and an intuitive interface that allowed easy navigation through detailed project metrics.
The solution also incorporated alert systems for potential budget overruns and schedule delays, enabling proactive management strategies. This innovative approach set the groundwork for the client's digital transformation journey within the construction domain.
Key Results
The deployment of the Construction Project Intelligence Dashboard led to significant improvements in site management:
- Project oversight improved by over 30%, as site managers could access and interpret project data more effectively and make informed decisions quickly.
- The error rate due to manual data entry decreased by 25%, thanks to automated data integration.
- Financial oversight was enhanced with timely and accurate insights, resulting in a 15% reduction in project cost overruns.
- Schedule adherence improved by nearly 20%, reducing delays and improving client satisfaction.
Adyantrix's tailored solution not only streamlined project management processes but also paved the way for further technological advancements within the client's operations. The successful implementation underscored the immense value of data-driven insights in transforming construction project management.
Technical Approach
The dashboard was built as a Progressive Web Application (PWA), a deliberate choice driven by the reality of construction sites: connectivity is often intermittent, and issuing native app builds to a rotating workforce of subcontractors is logistically difficult. As a PWA, the dashboard could be installed from a browser, cached key views for offline use, and synced data automatically once connectivity was restored.
The data architecture connected three distinct source systems:
- ERP system (SAP S/4HANA): Cost commitments, purchase orders, and budget allocations were pulled via the SAP OData API on a 15-minute refresh cycle. This gave site managers visibility of committed spend without waiting for the monthly finance report.
- Programme management tool (Asta Powerproject): Schedule data — activity status, float, critical path — was extracted nightly via a custom XML export processed by an ETL pipeline built in Apache NiFi.
- Site IoT sensors and telematics: Plant utilisation data from GPS-tracked machinery was ingested in near-real time to provide a live view of resource deployment against the programme.
The front-end was built in React with Recharts for data visualisation, and the backend API was developed in Node.js with PostgreSQL as the primary data store. Role-based access control ensured that site managers could see cost data for their own projects but not across other contracts — a data governance requirement the client's finance director insisted upon from the outset.
Implementation Highlights
The project ran over 20 weeks across two phases. Phase one was a discovery and design sprint lasting four weeks, during which we interviewed 12 site managers across three active projects to understand what information they actually needed — as opposed to what the finance team thought they needed. This distinction proved critical: site managers consistently said they needed to know earned value and remaining float in a single glance, not the granular cost-code breakdowns the existing reports contained.
The SAP integration was the most technically demanding element. The client's SAP instance was heavily customised with non-standard cost centre hierarchies that did not map cleanly to the project structure used in the dashboard. We built a translation layer — a configuration-driven mapping table maintained by the client's finance team — that allowed the dashboard to aggregate SAP cost data into the project/trade/work-package hierarchy without requiring any SAP customisation.
During the user acceptance testing phase, site managers requested a "traffic light" status view for each active project that could be printed as a single A4 page for site hoarding boards. We built a print-optimised CSS layout for this view in under two days — a small addition that became one of the most-used features after go-live, as it gave site teams a shared reference point without needing to log into the dashboard.
Measurable Outcomes
Before the dashboard, the client's monthly project review cycle relied on cost reports that were, on average, 11 days old by the time they reached site managers — the result of manual data compilation across ERP, programme, and timesheet systems. The dashboard reduced this lag to under 15 minutes for committed cost data and under 24 hours for programme data.
The 15% reduction in cost overruns was most pronounced in labour and plant categories, where the real-time utilisation data allowed site managers to identify and redeploy underutilised plant before the cost of idle time compounded. On one project alone, early identification of a tower crane running at 40% utilisation allowed the site manager to bring forward a subsequent activity to fill the gap — saving an estimated £28,000 in crane hire costs.
The 20% improvement in schedule adherence was partly attributable to the early warning system: the dashboard flagged activities approaching their latest start date four days in advance, giving site managers time to marshal resources before a delay became a programme impact.
Lessons Learned
One of the clearest lessons from this project was that real-time data is only valuable if the recipient can act on it. In early iterations of the dashboard, we surfaced too many metrics simultaneously, and site managers found the information overload paralysing rather than empowering. The pivot to a tiered information architecture — a top-level "health at a glance" view with drill-down capability for those who needed detail — significantly improved adoption rates after the first month of use.
We also encountered the classic problem of data quality upstream: the dashboard could only be as reliable as the source systems feeding it. Two sites had inconsistent timesheet submission practices that caused anomalies in the labour cost data. Resolving this required process change on the client's side, not technical change on ours — a reminder that a data platform project is always partly an organisational change project.
Why This Approach Worked
The PWA architecture was the right call for the construction environment, but the deeper reason the dashboard succeeded was the quality of the discovery phase. By spending four weeks understanding how site managers actually made decisions — rather than how the finance team assumed they did — we built a product that matched the real workflow rather than an idealised one. The consequence was high adoption from day one: within three weeks of go-live, 87% of the target user base had logged in at least once, and daily active usage reached 64% within six weeks — metrics that the client's IT director described as the highest adoption rate of any digital tool they had introduced in five years.
Speak with our Custom Software Development team at Adyantrix to find out how we can support your next project.
Work with Adyantrix
If you are looking to tackle a similar challenge, Adyantrix has the expertise to help across the full project lifecycle. Our custom software development practice covers tailored applications built to your exact workflows. Our web application development practice covers scalable web applications and portals. Our data analytics practice covers BI reporting and self-serve analytics platforms. Our business intelligence practice covers BI strategy, platform selection, and dashboard delivery. Get in touch to discuss your requirements — no commitment required.
