Data Sampling

In order to successfully use Info360 Insight, it is important to understand the data sampling process that is used.

Raw SCADA data typically comes in varying time steps, which can be inefficient for analysis and display at varying time scales. Info360 Insight samples the raw data at specific intervals and stores it as explained below.

Sample Values

For each interval, the following five summary values are stored in the Info360 Insight database.

Type Description

Open

The first value in each interval.

High

The highest value in each interval.

Low

The lowest value in each interval.

Close

The final value in each interval.

Average

The average value for each interval.

Generally, Close is used for viewing real-time data (to see the latest values), High and Low are used in alerts and summary analysis, and Average is used with flow and volume analysis.

Sample Data Tables

Info360 Insight builds sampled data tables for each sensor down to the minimum interval set for the sensor. The Open, High, Low, Close, and Average values are stored at the end of each sample interval (hourly, daily, etc.). For example, the data between 0:00 and 0:05 are sampled and summarized at 0:05.

The following tables illustrate how an hour's worth of raw SCADA data is built into data tables for 5-minute and 15-minute intervals.

For larger intervals, note how the sample tables are built. For a daily interval for example, the Low daily value reported at 0:00 on 1 April comes from the data sampled between 0:01 on 31 March and 0:00 on 1 April. So, each value summarizes the previous day.

Note: The default series type used when opening a Chart from the map is Close. This may not be appropriate for the analysis you'd like to do. You can change it in the chart configuration when you add the chart to a workspace.

Data Quality Control

Often, SCADA data can be prone to noise and gaps in data. To address this, Info360 Insight allows you to configure value mapping.