The deliverable 7.6, Reporting to the SCIS System (2), was submitted by Future Analytics Consulting (FAC) in October 2019. Following, the executive summary of the deliverable:
“Monitoring and Evaluation (M&E) in the +CityxChange project prescribes in Task 7.3 – Data Collection and Management, and Task 7.4 – Developing practical recommendations and guideline reports based on +CityxChange results of the Description of Actions that project monitoring data be captured, managed and disseminated. This is primarily done using an M&E dashboard developed for the project and the Smart Cities Information System (SCIS).
By the time of submitting this deliverable, very little monitoring data is available, and hence this deliverable does not contain detailed reporting on the monitoring data that will in future be shared through the +CityxChange Monitoring and Evaluation Reporting Tool (MERT) and the SCIS Self-Reporting Tool (SRT). Project monitoring data will be reported to the MERT once the prototype tool is able to accept data at the start of Month 13 of the project. This deliverable however provides an update on the process to get monitoring data captured in the MERT and the way data will be transferred to the SRT. The project monitoring data from the full set of 33 KPIs is set to be captured in the MERT, where it will be modelled, displayed and made available for export and external use in a summary ‘.pdf’ report and a more detailed data driven ‘.csv’ download. This method will include the full set of all project KPIs.
Through ongoing refinement of the data capturing process it has been confirmed that, as it stands, monitoring data from only six of the 33 Key Performance Indicators (KPI) will be reported to the SRT. As the SRT was designed to capture data from multiple smart city projects, it employs a rigid data capturing structure to accommodate data inputs across certain data capturing themes from a host of different sources. As such, the KPIs specifically designed for the project (e.g. KPI 1 – Number of APIs connected to the DST, or KPI 28 – Number of citizen observatories established) can not be reported to the SRT. Other KPIs currently have a mismatch in data capturing and calculation requirements between the MERT and SRT. The availability of data later on in the project will prompt a review of the data capturing capabilities of the SRT and the definition of the project KPIs, highlight adjustments to be made to the KPIs and the MERT and setup of Fields of Action (FoA) of the SRT in order to ensure that data is captured, modelled and shared efficiently.
The process will need to be completed using a manual data capturing method where data is submitted annually according to the requirements in FoA developed for each compatible KPI of the project within the SCIS system. To simplify the data transfer process, the FoA developed in the SRT, will be emulated in the MERT. This will enable partners to submit data in the MERT in the same format as required in the SRT, which will then require less processing and additional overhead to get data submitted to the SRT.”
