IGLC.net EXPORT DATE: 18 April 2024 @CONFERENCE{Wang2018, author={Wang, Frank L. and Rischmoller, Leonardo and Reed, Dean and Khanzode4, Atul }, editor={ }, title={Ad Hoc Data Analytics and Business Intelligence Service Framework for Construction Projects}, journal={26th Annual Conference of the International Group for Lean Construction}, booktitle={26th Annual Conference of the International Group for Lean Construction}, year={2018}, pages={1058-1068}, url={http://www.iglc.net/papers/details/1500}, doi={10.24928/2018/0535}, affiliation={Business Intelligence Lead, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, Frankwan@dpr.com ; Business Analyst, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, LeonardoR@dpr.com ; Lean/Integration Advocate, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, DeanR@dpr.com ; Technology and Innovation Leader, DPR Construction, 1450 Veterans Boulevard, Redwood City, CA 94063, USA, AtulK@dpr.com }, 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. }, author_keywords={Integration, waste, customization, complex, Integrated Information, Data Analytics }, address={Chennai, India }, issn={2309-0979 }, publisher={ }, language={English}, document_type={Conference Paper}, source={IGLC}, }