PMO Report Dashboard

Document Information

Functional Analyst

Abidemi Raji

VERSION	DATE	MODIFIED BY	DESCRIPTION
0.01	12/10/2023	Abidemi Raji	Initial draft
0.02	19/10/2023	Abidemi Raji	Updated
0.03	04/11/2023	Abidemi Raji	Updated with list of requirements and alternative tables

Overview

Application Overview

Domain: Programme Management / Finance

Main stakeholders: Service Delivery Managers (SDM), Pool Leads, Product Managers, Program Managers, PMO, Leadership Team (LT)

Business objective/value: Use data sourced from internal databases to create KPIs, determine project financial or execution status and provide decision useful information to stakeholders eliminating the need for manual intervention .

Main function: The dashboard is a visualization tool which provides authorized users with information on project financial and operational status. Various KPIs are also created using data sourced from Accolade and enriched with derived indicators to provide a complete overview to users.

The SBS Project Portfolio dashboard is used by the PMO team to monitor project deliverables, provide project financial summary and present any risks and issues. It provides a single source of information to the team and stakeholders on project KPIs, execution status, risk and issues over a specific period. e.g.

Project Status monitoring - Operational Burn Rate
Project Status monitoring - Status Update Frequency
Project Status monitoring - Carry Over not planned
Financial Status - Project Burn Rate
Financial Status - Project Close to Over Budget
Financial Status - Split Capex OTC
Financial Status - Project on Budget

Application Contact Details

Role (if applicable)	Name	Department	Email
Product Owner	Claire Bazin Dominique de Gouberville
Technical Product Owner
Users	Service Delivery Managers (SDM), Pool Leads, Product Managers, Program Managers, PMO, Leadership Team (LT)

Sign-Off / Approval

Role (if applicable)	Name	Department	Email
Product Owner	Claire Bazin
Product Owner	Dominique de Gouberville
Project Manager	Mauricio Nagahama	Project Manager • Visualization & reporting \| DATA, ANALYTICS & AI PLATFORM_ECO	mauricio.nagahama@solvay.com
Technical Sign off	Fernando Girante	Data Architect • Data & Analytics & AI Platform \| DATA, ANALYTICS & AI PLATFORM_ECO	fernando.girante@solvay.com
Technical Sign off	Matteo Menghetti	Data Engineer • Data architecture & engineering_ECO \| DATA, ANALYTICS & AI PLATFORM_ECO	matteo.menghetti@solvay.com
Technical Sign off	Maxime	Data science & AI_ECO \| DATA, ANALYTICS & AI PLATFORM_ECO	maxime.marboeuf-ext@solvay.com

Application Access Rights

Access to the PMO dashboard depends on the user's profile which ensures that the user is allowed to perform the requested action (e.g. Run reports and download results). The user profiles (“normal user” and “advanced user”) at the same time correspond to the privileges granted according to the Business Unit the user belongs to using Single Sign On functionality

Department	GBU Code	Role	Right	Comments

Business Context

Scope:

In-Scope

This document covers the requirements for the PMO Dashboard to be migrated onto Tableau

Main dashboard visualisation and filters
KPI dashboard visualisation and filters
Access to the dashboard

Out Of Scope

Data Sourcing requirements are out of scope of this document.

Business process:

The PMO team regularly monitors the overall financial and operational status of several programmes and projects within the organisation and provide update to stakeholders on project or programme status. The team needs the capability to extract and transform data seamlessly for the required parameters that have been pre-defined as part of the reporting process.

Specifically, the PMO team objectives are:

Portfolio Monitoring: The team requires the capability to monitor projects and programmes that are Open or Closed within a defined time period in order to determine status, be aware of risks to project delivery and provide decision useful information to stakeholders.
Data sourcing: The PMO team sources project operational and financial data from Accolade (Solvay internal DB) and vshare.
Reporting: The PMO team requires the capability to create reports from the data extracted from Accolade/vshare, highlighting several defined KPIs to provide updates on project financial and operational status.
Automation: The extraction, refresh and KPI update process are to be performed without manual intervention.

Challenge/ Opportunity :

The new PMO dashboard in Tableau will provide authorised users with the capability to leverage multiple data sources within Solvay to review Financial and Operational performance of programmes and projects within a 3.5 year rolling window and have instant access to KPIs, with automated data refresh, eliminating the need for any manual interference.

E ffective presentation of data: The PMO team require the capability to present KPIs and project status information in an automated fashion, showing the most impactful metrics.
Consolidated reporting: A single source pf reporting Financial and Operational status of projects and programmes including KPIs
Eliminate manual spreadsheets: The reporting process should not involve manual intervention

Business Glossary

Terminology used in this application consider to be added in -> Enterprise Data Governance

Term	Description

Application Feature List

Feature	Description	Latest update in production (DD/MM/YYYY)

Functional Description

Dashboard

Data Attributes and Mapping: https://drive.google.com/file/d/16n6b3eh9PCt-JRB1iaI745AZgqr8f_4wf2psU6Vfi0c/view

Data Product Type

Dashboard
Report
Advanced analytics

Technologies

BW
Tableau
Qliksense
Talend
Dataiku
Others <specify which one>

Data Sources

Note: list of all applications and various environment

Accolade
SAP PF1 (Production environment)
SAP WP1
SAP PI1
BW (versions)

Data Input

As-Is Data Sources (including the nature of the data and what is it needed for):

Currently the PMO Dashboard is implemented in Qlikview. Data is sourced from Accolade_SBS_Portal using two main queries (SGM_CUSTOM_VIEW, SGM_CORE_Project Details) and a Stored Procedure ( RSP_QV_GetMergedMetricsForGroupID) which uses GROUPID_SYS as a parameter .

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image-2023-10-18_23-41-20.png

AS-IS Tables

SGM_CUSTOM_VIEW

SGM_CORE_Project Details

SGM_PROJECTMETRICS_15

SGM_PROJECTMETRICS_62

SGM_PROJECTMETRICS_94

SGM_PROJECTMETRICS_108

As-Is Data Model:

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image-2023-10-18_19-3-9.png

Target State Data Model:

The target state data sourcing model will re-use existing data model (queries and Stored Procedures) as well as include additional calls to the Database using GroupID_SYS as shown below.

	As-Is	To-Be	Comments
Database	Accolade_SBS_Portal	Accolade_SBS_Portal
Stored Procedure	RSP_QV_GetMergedMetricsForGroupID	RSP_QV_GetProjectMetricsForGroupID
Parameter	GroupID_SYS	GroupID_SYS
Query/Tables	SGM_CUSTOM_VIEW	SGM_CUSTOM_VIEW / CRV_Initiative_V3
	SGM_CORE_Project Details	SGM_CORE_Project Details / CRV_ZGetProjectDetails
	GroupID_SYS: 15, 62,94,108	GroupID_SYS: 18, 46, 109, 63, 64, 65, 66, 103, 104, 69, 111, 105, 106, 110, 124	Execute the stored procedure iteratively, with the different parameters to obtain the different results sets needed for the scope of the project

Target State Data Sourcing:

Business Concept	Database Object	Link to output specification	Comments
SGM_CUSTOM_VIEW	CRV_Initiative_V3	Tables, Stored Procedures and Data Mapping File	<comment or description of the concepts in the table>
SGM_CORE_Project Details	CRV_ZGetProjectDetails
SGM_PROJECTMETRICS_15	Exec RSP_QV_GetProjectMetricsForGroupID 15
SGM_PROJECTMETRICS_62	Exec RSP_QV_GetProjectMetricsForGroupID 62
SGM_PROJECTMETRICS_94	Exec RSP_QV_GetProjectMetricsForGroupID 94
SGM_PROJECTMETRICS_108	Exec RSP_QV_GetProjectMetricsForGroupID 108
SGM_PROJECTMETRICS_18	Exec RSP_QV_GetProjectMetricsForGroupID 18
SGM_PROJECTMETRICS_46	Exec RSP_QV_GetProjectMetricsForGroupID 46
SGM_PROJECTMETRICS_109	Exec RSP_QV_GetProjectMetricsForGroupID 109
SGM_PROJECTMETRICS_63	Exec RSP_QV_GetProjectMetricsForGroupID 63
SGM_PROJECTMETRICS_64	Exec RSP_QV_GetProjectMetricsForGroupID 64
SGM_PROJECTMETRICS_65	Exec RSP_QV_GetProjectMetricsForGroupID 65
SGM_PROJECTMETRICS_66	Exec RSP_QV_GetProjectMetricsForGroupID 66
SGM_PROJECTMETRICS_103	Exec RSP_QV_GetProjectMetricsForGroupID 103
SGM_PROJECTMETRICS_104	Exec RSP_QV_GetProjectMetricsForGroupID 104
SGM_PROJECTMETRICS_69	Exec RSP_QV_GetProjectMetricsForGroupID 69
SGM_PROJECTMETRICS_111	Exec RSP_QV_GetProjectMetricsForGroupID 111
SGM_PROJECTMETRICS_105	Exec RSP_QV_GetProjectMetricsForGroupID 105
SGM_PROJECTMETRICS_65	Exec RSP_QV_GetProjectMetricsForGroupID 106
SGM_PROJECTMETRICS_110	Exec RSP_QV_GetProjectMetricsForGroupID 110
SGM_PROJECTMETRICS_124	Exec RSP_QV_GetProjectMetricsForGroupID 124

Transformation Rules (for each of the data source in the previous point):

In the target state, additional filters to the data extract are required to be implemented in the result of the SGM_CORE_Project Details / CRV_ZGetProjectDetails query

1. Extraction rules and filters:
  1. Project Closed Date >= 3.5yrs
  2. Project Closed = 0
2. Exception handling rules (how do we handle when data does not come in the format we need) : Normal exception handling rules apply
3. Enrichments (normally joins)
4. Aggregation rules

KPI's Definitions

Budget and Cost File: Budget & Cost File: 2F250000.xlsm

KPI Number	KPI Name	Calculation	Description
1	Forecast accuracy rate	(act+ planned total [year N] (-[year N]actual cost/(act+ planned total [year N])	Budget & Costs File: (Act.+Planned CAPEX) + (Act.+Planned OTC) = Act.+Planned Total Actual Planned Total for the current year -(Current year Actual Cost/Actual Planned Total for the current year)
2	Operational time total (in days)	NETWORKDAYS(Requested Start Date (PMO Gate) -end date)	Budget & Cost File: Number of working days between Requested Start Date (PMO Gate) and End date
3	Operational time to date vs total (in %)	if(IFERROR(NETWORKDAYS(Requested Start date (PMO Gate) ;today())/operational time total)>1;1;IFERROR(NETWORKDAYS(Requested Start date (PMO Gate);today())/operational time total))	Budget & Cost File: if the number of working days between Requested Start date (PMO Gate) and today divided by Operational Time Total KPI (NUMBER 4). If a value is returned, display that value otherwise if it shows an error just display 1
4	Burn rate budget	[year N]actual cost/act+ planned total [year N]	Budget & Cost File: Actual Cost for the current year divided by the Actual Planned Total for the current year
5	Burn rate vs burn rate time (in %)	burn rate/operational time to date vs total	Budget & Cost File: Burn Rate divided by Operational Time total KPI 4 / KPI 5
6	Operational time burn rate	if (burn rate vs burn rate time>50%, "1 - Ahead of Schedule >50%";IF(burn rate vs burn rate time>30%;"2 - Ahead of Schedule >30%";IF(burn rate vs burn rate time>-30%;"3 - Linear";IF(burn rate vs burn rate time>-50%;"4 - Below Schedule 30-50%";"5 - Below Schedule more than 50%")	Budget & Cost File: If KPI 5 is greater than 50 % display 1 - Ahead of Schedule >50%" If KPI 5 is greater than 30 % display 1 - Ahead of Schedule 30%" If KPI 5 is greater than -30 % display "3 - Linear" If KPI 5 is greater than -50 % display "4 - Below Schedule 30-50%" else display "5 - Below Schedule more than 50%"
7	Project (planned, ongoing or went life) with no approved budget but with some actuals	on Budget&cost file (coming from Accolade): column DO "total approved" is empty whereas column CI "status" is equal to on-going or went-live	Budget and Cost File: Display a list of projects where the Total Approved amount is BLANK and "Status" is "On-going" or "Went Live"
8	Carry over not planned	on Budget&cost file: column CI status = closed whereas still increase of actuals month after month (column EG) closed projects with actuals after the closure date	Budget and Cost File: Display the list of projects (+ number) with an increase of the budget
9	Projects not yet started with a start date in the past	Idea&prospective not migrated into project with a start date in the past
10	Status update frequency	status update frequency in number of projects if(project to be considered="no";"";if(days since Last update ="";"6.never updated";if(days since Last update <31;"1.Less than 30 days";if(days since Last update <61;"2.between 30 & 60 days";if(days since Last update <91;"3.between 2 & 3 month";if(days since Last update <181;"4.beetween 3 & 6 month";"5.more than 6 month"))))))	Budget and Cost File: Display a histogram of projects showing how frequently their status has been updated. if the project to be considered field = NO, and the days since last update is blank = 1; the status =6 Never Updated if the project to be considered field = NO, and the days since last update is < 31 ; the status = 1. Less Than 30 days if the project to be considered field = NO, and the days since last update is < 61 ; the status = 2. Between 30 and 60 days if the project to be considered field = NO, and the days since last update is < 91 ; the status = 3. Between 2 and 3 months if the project to be considered field = NO, and the days since last update is < 181 ; the status = 4 Between 3 and 6 months else display 5. more than 6 months
11	Finance update frequency	Finance update frequency in number of projects updated=countifs('project to be considered;"yes";'financial uptodate;"1") not updated=countifs('project to be considered;"yes";'financial uptodate;"3") no KFD=countifs('project to be considered;"yes";'financial uptodate;"")	Budget and Cost File: Display the number of projects where the financial status of the project has been updated if the project to be considered field = yes and the financial up to date field = 1; the status = Updated if the project to be considered field = yes and the financial up to date fiekd = 3; the status = Not Updated if the project to be considered field = yes and the financial up to date filed = blank; the status = No KFD
12	On Budget	Project forecasts vs approved budget below, above, on track	Budget and Cost File: Display a histogram of Project forecasts vs approved budget Status: below, above, on track If forecast budget is below ref approved: Below If forecast budget if above approved ref: Above If forecast budget if equal to approved ref: On Track
13	On Time	on time: =countifs('project to be considered;"yes";'on time;"1") slightly delayed=countifs('project to be considered;"yes";'on time;"2") delayed: countifs('project to be considered;"yes";'on time;"3")	Budget and Cost File: Display a histogram of the number of projects that are "On Time", "Slightly Delayed" or "Delayed" The value of On Time = 1 The value of Slightly Delayed = 2 The value of Delayed = 3
14	Project close to over budget	end date<month date	Budget and Cost File: Display a histogram of the List of projects where end date<month date
15	Split Capex / OTC	Approved vs forecast	Budget and Cost File: Display a histogram of the list of projects comparing Approved vs forecast

Visualization

Data & KPI User Story Deck

Graph name	Description
Main Dashboard	SBS Project Portfolio: Project Details
Finance -	Split Capex / OTC Finance Update Frequency Burn Rate Budget Forecast Accuracy Rate
Finance /Operational	Burn Rate vs Burn Rate Time Finance + Operation
Operational	Operational Time Total (in days) Operational time to date vs total (%) Operational Burn Rate Project (Planned, ongoing, went live) with no approved budget but with some actuals Projects not yet started with a start date in the past Carryover Not Planned Status Update Frequency On Budget On Time Project Close to Over Budget

PMO Dashboard AS-IS Visualisation:

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image2023-10-12_14-44-36.png

PMO Dashboard TO-BE Visualisation:

Main Dashboard

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image-2023-10-18_21-19-4.png

Main Dashboard filters:

- roadmap
- accountable (Business)
- Product Manager/ Service Delivery Manager
- Platform/product
- Objective
- Project Manager
- Status
- Program
- Financial Treatment
- Project prioritization
- Start Quarter
- Monthly status date
- Financial up-to-date

KPI Page

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image2023-10-15_21-5-34.png

System view (Architecture)

The purpose of this part is to describe the physical components that supports the functionalities of the product. From that point of view, this part should capture and visualizes the physical components of the data products such as backend, front end, data providers, libraries for ML models, etc.

Data Solutions - BD&A Team > Mecanoxxxxx - Dashboard Migration - xxxxx > image2023-10-12_14-40-51.png

Functional Requirements

Requirement #	Role	Requirement Title	Description/User Story	Acceptance Criteria
Data_Sourcing_1	Data Engineer	Source validated, complete and correct data from Accolade for the PMO dashboard visualisation.	As an authorised SBS Dashboard user I want to have access to correct and complete data on the financial and operational status of SBS projects and programmes in the PMO Dashboard	Data in the current state is migrated successfully to target state including all primary and secondary data
Visualisation_Dashboard_Main	Visualisation and User Experience	Create a Dashboard with Summary Table and Project Details (Main Dashboard)	As an authorised SBS Project Portfolio dashboard user , I need to see the overview of financial and operational details of projects using multiple filters and by dimensions	The main dashboard shall display multiple visuals with: The Programme/Project Manager Name The Programme ID, Status, Number of Projects The CAPEX by year, Total CAPEX .... Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_1	Visualisation and User Experience	Create a KPI table/histogram for Project Forecast Accuracy Rate	As an authorised SBS KPI dashboard user , I need to see a table/histogram of projects with the forecast accuracy rate.	The SBS KPI dashboard shall display a table/histogram with: A count of the number of projects Column titled Months Forecast Accuracy Rate Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_2	Visualisation and User Experience	Create a KPI table/histogram for Project Operational Time Total (Days)	As an authorised SBS KPI dashboard user , I need to see a table/histogram of projects with the Operational Time in Days.	The SBS KPI dashboard shall display a table/histogram with: Project ID Program Name Requested Start Date (PMO Gate) End Date Operational Time in days Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_3	Visualisation and User Experience	Create a KPI table/histogram for Project Operational Time to Date vs Total (in %)	As an authorised SBS KPI dashboard user , I need to see a table/histogram of projects with the Operational Time total to date vs Total (in %)	The SBS KPI dashboard shall display a table/histogram with: Project ID Program Name Requested Start Date (PMO Gate) Operational Time in days Operational Time in days vs Total (in %) Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_4	Visualisation and User Experience	Create a KPI table/histogram for Burn Rate Budget	As an authorised SBS KPI dashboard user , I need to see a table/histogram of projects with the budget burn rate	The SBS KPI dashboard shall display a table/histogram with: Project ID Program Name Budget Burn Rate Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_5	Visualisation and User Experience	Create a KPI table/histogram for Burn Rate vs Burn Rate Time (in %)	As an authorised SBS KPI dashboard user , I need to see a table/histogram of projects with the budget burn rate vs Burn Rate Time (in %)	The SBS KPI dashboard shall display a table/histogram with: Project ID Program Name Budget Burn Rate (in %) Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_6	Visualisation and User Experience	Create a KPI Histogram for Operational Time Burn Rate KPI	As an authorised SBS KPI dashboard user , I need to see a histogram of projects with operational burn rate	The SBS KPI dashboard shall display a histogram with: Project ID Program Name Operational Burn Rate Time Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_7	Visualisation and User Experience	Create a KPI Histogram for Project (planned, ongoing or went life) with no approved budget but with some actuals	As an authorised SBS KPI dashboard user , I need to see a histogram of project (with Status) with no approved budget but with some actuals	The SBS KPI dashboard shall display a histogram with: Project ID Program Name Operational Burn Rate Time Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_8	Visualisation and User Experience	Create a KPI Histogram for Project (planned, ongoing or went life) with no approved budget but with some actuals	As an authorised SBS KPI dashboard user , I need to see a histogram of project (with Status) with no approved budget but with some actuals	The SBS KPI dashboard shall display a histogram with The Number of projects Months Total Actuals with No Approved Budget Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_9	Visualisation and User Experience	Create a KPI Histogram for Projects not yet started with a start date in the past	As an authorised SBS KPI dashboard user , I need to see a table of projects with a start date in the past that hasn’t began yet.	The SBS KPI dashboard shall display a histogram with: Objective Start Quarter Platform Owner Project Name/Name of Initiative Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_10	Visualisation and User Experience	Create a KPI Histogram for Project Status Update Frequency	As an authorised SBS KPI dashboard user , I need to see a histogram of projects showing how frequently their status has been updated.	The SBS KPI dashboard shall display a histogram with: Project Count Status Update Frequency Month Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_11	Visualisation and User Experience	Create a KPI Histogram for Projects whose Finance Status is Up to Date	As an authorised SBS KPI dashboard user , I need to see a histogram of projects with finance status that is up to date.	The SBS KPI dashboard shall display a histogram with the below colour coded status: No KFD Not Updated Updated Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_12	Visualisation and User Experience	Create a KPI Histogram for Project On Budget	As an authorised SBS KPI dashboard user , I need to see a histogram of projects with a project status is On Budget.	The SBS KPI dashboard shall display a histogram with the below colour coded status: Forecast < Ref Approved Forecast > Ref Approved Forecast on track The histogram shall have month-year on the X axis and % on the Y axis Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_13	Visualisation and User Experience	Create a KPI Histogram for Project is On Time	As an authorised SBS KPI dashboard user , I need to see a histogram of projects with a the project status is On Time.	The SBS KPI dashboard shall display a table/histogram with: Slightly Delayed Delayed On Time The histogram shall have month-year on the X axis and % on the Y axis Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_14	Visualisation and User Experience	Create a KPI Histogram for Project Close To Over Budget	As an authorised SBS KPI dashboard user , I need to see a histogram of projects with a project status is Close To Over Budget.	The SBS KPI dashboard shall display a table/histogram with: Project ID, Name Month Platform Owner Project Name/Name of Initiative Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_KPI_15	Visualisation and User Experience	Create a KPI Histogram for Project Split CAPEX OTC	As an authorised SBS KPI dashboard user , I need to see a histogram of projects split between CAPEX and OTC.	The SBS KPI dashboard shall display a table/histogram with: Slightly Delayed Delayed On Time The histogram shall have month-year on the X axis and Amount on the Y axis The Histogram will be split between CAPEX and OTC The amount shall be displayed on the Histogram bars Users shall be able to apply filters in the dashboard to see relevant year and details required
Visualisation_Dashboard_Authorisation	Access and Authorisation	Restrict user access to dashboard	As an authorised SBS KPI dashboard Owner, I need access to the PMO dashboard and KPI dashboard restricted based on roles and business units.	Access to the dashboard shall be restricted using Single Sign On or any role specific authorisation protocol Users are only able to see data relevant to their assigned profile

Non-functional Descriptions

This part specifies criteria that describe the operation of the data product, rather than specific behaviours.

Usability

Regulatory Compliance

The Dashboard will comply with Solvay’s regulations and compliance e.g., access only granted to authorized Users.
Maintenance data will be split between either SCO or ECO, and Users will only have authority to one Entity data

Performance

Reliability

Scalability

Compatibility

Availability

Refresh of the Data

Data shall be sourced from the Accolade database 5 times per day

Storage of the Data

The final copy of the sourced data shall be stored on a daily basis
Stored data shall be made available on request by an authorised user within the PMO team with appropriate permissions.

PMO Report Dashboard