Ad Hoc Data Analytics and Business Intelligence Service Framework for Construction Projects

Abstract

This paper presents a framework of an ad-hoc data analytic and Business Intelligence service tailored to a construction project. Mandates of delivering integrated information solutions and effective reporting are commonly required nowadays in large capital projects. Due to the nature of construction projects with schedule and budget constraints, poorly defined business problems prohibited the team to deploy full scale data analytic and Business Intelligence (BI) services on site. On the other hand, the increasingly complex data coming from multiple applications and organizations on projects requires more powerful data integration tools and techniques. The proposed framework outlines an agile and ad hoc best practice for job site data analytics and effective reporting based on a real use case from a large pharmaceutical project. Processes in the framework include data alignment, Level of Detail (LoD) data articulation and analytical model establishment. It also illustrates how to resolve complex data analytic challenges for unforeseen cost disputes and how to deliver solutions within a short period of time.