Level:
Intermediate
TCM Section(s):
10.4. Project Historical Database Management
10.1. Project Performance Assessment
Venue: 2022 AACE International Conference & Expo
Abstract: The importance of an integrated database for project historical data to measure project performance is recognized by the recent AACE International Recommended Practice 114R-20.A historical database allows project teams to create standardized reports on key performance indicators, trend metrics over time, and analyze the data to observe common trends in project performance.There are many challenges to overcome in the development of an integrated database; establishing data input standards, maintaining the data quality, establishing and maintaining the necessary data security, resolving database errors in a timely manner and developing effective metrics.
This paper will focus on the key challenges whilst implementing an integrated project data warehouse at Ontario Power Generation (OPG), and some of the benefits that have been observed. The development of this data warehouse began in 2015 as part of a mega-project and was extended to all OPG projects in 2019.
TCM Section(s):
10.4. Project Historical Database Management
10.1. Project Performance Assessment
Venue: 2022 AACE International Conference & Expo
Abstract: The importance of an integrated database for project historical data to measure project performance is recognized by the recent AACE International Recommended Practice 114R-20.A historical database allows project teams to create standardized reports on key performance indicators, trend metrics over time, and analyze the data to observe common trends in project performance.There are many challenges to overcome in the development of an integrated database; establishing data input standards, maintaining the data quality, establishing and maintaining the necessary data security, resolving database errors in a timely manner and developing effective metrics.
This paper will focus on the key challenges whilst implementing an integrated project data warehouse at Ontario Power Generation (OPG), and some of the benefits that have been observed. The development of this data warehouse began in 2015 as part of a mega-project and was extended to all OPG projects in 2019.