TY - CONF TI - Ad Hoc Data Analytics and Business Intelligence Service Framework for Construction Projects C1 - Chennai, India C3 - 26th Annual Conference of the International Group for Lean Construction SP - 1058 EP - 1068 PY - 2018 DO - 10.24928/2018/0535 AU - Wang, Frank L. AU - Rischmoller, Leonardo AU - Reed, Dean AU - Khanzode4, Atul AD - Business Intelligence Lead, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, Frankwan@dpr.com AD - Business Analyst, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, LeonardoR@dpr.com AD - Lean/Integration Advocate, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, DeanR@dpr.com AD - Technology and Innovation Leader, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, AtulK@dpr.com AB - 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. KW - Integration KW - waste KW - customization KW - complex KW - Integrated Information KW - Data Analytics PB - T2 - 26th Annual Conference of the International Group for Lean Construction DA - 2018/07/18 CY - Chennai, India L1 - http://iglc.net/Papers/Details/1500/pdf L2 - http://iglc.net/Papers/Details/1500 N1 - Export Date: 28 March 2024 DB - IGLC.net DP - IGLC LA - English ER -