Skip to main content

(DSAA-3814) Data Collection and Visualization for an Improved Analysis of Historical Project Data

Level: Intermediate
TCM Section(s):
10.4. Project Historical Database Management
11.3. Information Management
Venue: 2022 AACE International Conference & Expo

Abstract: Projects produce data around the clock and provide broad opportunities to generate organizational knowledge. Digital initiatives, especially in the field of cost engineering, establish a competitive advantage to owner organizations by improving cost and productivity, consistency of approach, and risk management processes. This paper shares practical experiences from the implementation of a digitalization process, which evolved from a stumbling block into a steppingstone. It addresses the design of a framework for the implementation, data collection, storage, analysis and sharing of relevant project data, whilst also demonstrating a methodology to adapt the AACE recommended practice 114R-20 on the development of project historical databases.

The paper starts with the introduction of the technical development by outlining the data collection process, the design of the database architecture, and the data analysis approach. A common business intelligence application (e.g., Microsoft Power BI, Tableau, Sisense) helps to perform data visualizations and sharing of results. The second part addresses the implementation process and how to create buy-in. It closes with a discussion of identified success factors like building a simple system, collecting structured data, sharing results via interactive dashboards, implementing in phases, and planning the communication precisely.