Data Quality Page – SIERA

In this help article you will find the information you need to navigate the Data Quality page.

What does the Data Quality page show?

The Data Quality page helps users to quickly identify:

Missing data – both completeness in terms of time and coverage in terms of floor area.
Where utility meters exist for data which is not currently being reported / recorded (data coverage by area as a part of the whole asset).
Where consumption data has been submitted but is estimated data to indicate where data accuracy and reliability might be impacted.

The page is divided into two sections, one for the landlord and one for the tenant(s) respectively. Landlord and Tenant sections will only display if there are utility meters present. If for example all an asset’s meters are landlord procured meters, then no tenant section will appear and vice versa.

By default, the date range will be set to Year to Date but otherwise will be what was selected in the page you navigated from. You can select an alternative date range from one of the other predefined options or a custom date range from the date picker at the top of the page

The Summary tab

On the Summary tab, you can filter by utility type as well as the area served by the meter(s).

Each bar provides an aggregated visual representation of the data coverage and data completeness across all utility meters.

Details displayed as a list for the meters associated with the asset include:

Meter – this will display the unique meter identifier or name
Date – the date period the consumption data has been either completed (blue), estimated (yellow) or missing (red) for
Type – the utility type
Provider – the utility provider name where known
Location – the area type within the asset the meter serves
Floor area – the floor area the meter covers
Source – whether the data entered is an estimate or.
Consumption – the consumption data entered for that period. Where this is showing as blank, the consumption data is missing.

How can I enter in new data?

Enter data: Should you wish to add in data missing for a specific meter, select the specific meter(s) using the tick box next to each one in the list and click Enter data which will open a new page. Once open you can enter the data directly into the web form.

Note you can also enter data and access the same webform by selecting the missing periods (identified in red) from the relevant meter heat map located on the Meter view tab.

Once the consumption data has been entered into the data list, the Data Quality page will no longer display the gap as red in the relevant bar or Individual meter/period.

How can I request data?

To request data from someone, you can select the specific meter(s) using the tick box next to each one in the list and click the Request data button, or select the desired gap from the relevant meter from the Meter view tab to open a popup email template which allows you to enter a recipient’s email address.

Once you’ve hit send, the email recipient will receive an e-mail showing the gaps, along with a weblink which can be clicked to take the user to the consumption web form to enter the data.

Once the data has been entered (gaps filled), the missing data list on the Data Quality page will no longer display the gap in the list.

What does the ‘heatmap’ on the Meter view tab show?

The heatmap is colour coded and shows the list of meters recorded in SIERA for the asset. You can select a time period to view and filter which meters are visible. For example based on utility type as well as the area served by the meter(s).. Each meter row comprises segments to represent the months of the year.

Colour coding of each row denotes:

Blue– complete consumption data for the month is present and is an actual reading. It will also have the tooltip “All data collected”
Yellow– complete consumption data for the month is present and estimated. It will also have the tooltip “Data estimated”
Red– consumption data is missing for the whole month OR denotes a partial gap. Only partial gaps which are deemed significant are highlighted. A material gap is when there is less than a ull month’s data but when added together collectively results in more than % of consumption data is missing for the reporting period. It will also have the tooltip “Data missing”

You can click on the heatmap for any specific meter, and the individual meter modal will appear.

(data_qaulity_individual_meter)

From here you can either select the date periods that have missing consumption data and click on the Enter data button to add the consumption data, or click on the Request data button to request the consumption data from someone else.

What does the yellow vertical line show?

The yellow line indicates the reporting year start date for the fund or portfolio.

Data completeness

Data completeness refers to the proportion of the reporting year for which consumption data has been reported for meters recorded in SIERA. Completeness focuses on highlighting gaps within the recorded consumption for a meter.

Data coverage

Refers to how much data coverage by area the meters represent in relation to the whole building. Meters onboarded to SIERA are attributed to specific spaces within an asset such as common areas, whole building, tenant areas etc along with the extent of floor area they cover.

Coverage of areas with meters not reported in SIERA are represented by the grey portion of the bars at the top of the page. For example, if tenants procure utility consumption for their own demise and the data is not available then this would display as not covered under Tenant.