Primary Author: John W. Blodgett
Co-Author: Brian Criss, PSP
Audience Focus: Advanced
Application Type: Application
Venue: 2014 AACE International Annual Meeting, New Orleans, LA, USA
Abstract: "Integrated Reporting" can be accomplished by using reporting and dashboard tools that support accessing multiple data sources directly or through a data warehouse. The data sources can include Primavera P6 for planning and scheduling; a financial tool such as SAP; and/or internal home-grown databases. The data warehouse is the "central" database containing data with differing structures used in producing reports that incorporate the data directly from their auditable source databases. The report/dashboard solution is supported by programming to align the data based on common elements to provide Enterprise level information, supported by individual system audit reports. A further objective is to move beyond siloed spreadsheet data by incorporating various sources into a single source of consolidated information. The data warehouse can also be used to store snapshots of datasets in order to perform trending and analytics. This paper will discuss the business case for developing Integrated Reporting dashboards; an example case-study of an existing dashboard developed and used by a Utility company; and alternative approaches, such as off-the shelf Analytics offerings.
Co-Author: Brian Criss, PSP
Audience Focus: Advanced
Application Type: Application
Venue: 2014 AACE International Annual Meeting, New Orleans, LA, USA
Abstract: "Integrated Reporting" can be accomplished by using reporting and dashboard tools that support accessing multiple data sources directly or through a data warehouse. The data sources can include Primavera P6 for planning and scheduling; a financial tool such as SAP; and/or internal home-grown databases. The data warehouse is the "central" database containing data with differing structures used in producing reports that incorporate the data directly from their auditable source databases. The report/dashboard solution is supported by programming to align the data based on common elements to provide Enterprise level information, supported by individual system audit reports. A further objective is to move beyond siloed spreadsheet data by incorporating various sources into a single source of consolidated information. The data warehouse can also be used to store snapshots of datasets in order to perform trending and analytics. This paper will discuss the business case for developing Integrated Reporting dashboards; an example case-study of an existing dashboard developed and used by a Utility company; and alternative approaches, such as off-the shelf Analytics offerings.