Advanced Analytics

Follow

In this article you are going to learn how to use the Advanced Analytics tool

Introduction

The Advanced Analytics feature gives you the freedom to create the analysis you need within the Platform. With it you can analyse different energy sources and other parameters, compare them with different frequencies and even year by year. You can also visualize devices groups based on the reference meters of each location.

You can later on export those analysis to an excel or a custom report.

Available frequencies

The available frequencies in this screen are from 5min to yearly.

Advanced Analytics is, until now, the only functionality in the EM Platform that allows you to visualize your curves with a yearly resolution.

You can also visualize your data accumulated, if that is the way you are inserting the data.

Available parameters

The available parameters to select in Advanced Analytics are all the parameters of the Platform, excluding only the calculated parameters. This means that you can compare Energy Sources between them and to Temperature or Degree Days too.

Requirements

In order to see data in Advanced Analytics, you need to do a few things first:

  1. To send data to the EM Platform
  2. To accept the devices and datapoints generated when the data gets into the platform
  3. To assign those devices to their corresponding location

And that's it, you are ready to analyse your data!

How does it work?

  1. Go to the Advanced Analytics screen, under Analysis
  2. Create a new Analysis clicking on New Advanced Analytics
  3. Name it as you want, it will be automatically saved in the platform (no save button!)
  4. Add the Data Series to the graph, that you can later on edit

Arrived to this point there are 2 different types of Data Series that you can add:

Single device

This Data Series adds a single device with the parameter that you desire to the graph.

Once you have selected the parameter and the device, just select the resolution at which you want to visualize the Data Series (from basic to yearly).

Resolution b:  is the resolution that allows you to visualize your data accumulated.

dexma-advanced-analytics-1.png

You can also apply any ratios that you want to the Data Series itself.

Once you've created the Data Series, you can edit it whenever you want.

Multiple device

This Data Series creates a group of reference devices under the hierarchy level selected on the configuration.

You can use the hierarchy level and even the tags to create this aggregated Data Series.

Once you have selected the parameter, the type of reference device, the hierarchy level and the tags (optional), just select the resolution at which you want to visualize the Data Series (from 5min to yearly).

dexma-advanced-analytics-2.png

You can later apply any ratios that you want to the Data Series and select the Operation that the Data Series must apply to aggregate the multiple devices.

Once you've created the Data Series, you can edit it whenever you want. 

Edit a Data Series

By clicking on the 3 dots on the right of the Data Series you can editduplicate or delete the Data Series.

dexma-advanced-analytics-3.png

While editing it you can change the name of the Series and the parameter, device, resolution and ratios applied.

Data Display

Once the Data Series are properly added to the Advanced Analytics query, the visualization by default is going to be all in lines, with the units by default and the data from the last 7 days.

You can modify this by changing:

Besides this, there are 2 key things in this section that might help you enormously with your analysis and reporting: 

The visualization of the graph

Lines

dexma-advanced-analytics-4.png

Bars

dexma-advanced-analytics-5.png

Stacked Bars

The bars are stacked based on their parameter.
In the picture below, all Active Energy devices are aggregated in a single stacked bar.

dexma-advanced-analytics-6.png

Pie Chart

dexma-advanced-analytics-7.png

Custom

This type of chart allows you to modify the way you want to visualize each device: in linesbars or stacked bars.

In the picture below, we can visualize water in bars, electricity in stacked bars and temperature in lines.

dexma-advanced-analytics-8.png

 

Scatter Plot

This type of graph allows you to visualize a Scatter plot based on 2 devices, previously set up, and get the Correlation coefficient and the Regression line formula.

 

dexma-advanced-analytics-9.png 

The graph settings

The graph settings change depending on the type of visualization of the graph:

Scatter Plot

With this type of graph, in the settings you define which device is set up into which axis (X or Y). You can also change the color of the dots and the line that the graph will show.

Note: For the scatter plot to work, both selected parameters must have the same resolution.

dexma-advanced-analytics-gif-1.gif 

Custom

With this type of graph, in the settings you define how you are going to visualize each device: in Lines, Bars or Stacked Bars.

Note: The Stacked bars aggregates the data of the devices that have the same parameter.

 dexma-advanced-analytics-10.png

Any other graph but Scatter Plot or Custom

In all the rests of visualizations, in the settings you can define the units to be shown in the Axis, for which value should the data be divided (by default 1) and wheter to autoescale the graph or set up manually a min and max value in case you need or want to do it.

dexma-advanced-analytics-11.png 

Yearly comparison

If you have historical data, you can compare your data throughout the years with this feature.

You just need to select Yearly Comparison below the chart, and then select the range of years that you want to compare.

dexma-advanced-analytics-12.png

Summary table

Underneath the graph, you will always be able to visualize a Yearly Summary table, with the monthly data of all your devices, a sum of the yearly data and an average.

dexma-advanced-analytics-13.png

Exporting data

Share the analysis

From the initial Advanced Analytics screen, (Analysis --> Advanced analytics) you can share your analysis with other EM Platform users by clicking on the share button:

dexma-advanced-analytics-14.png

The sharing menu appears, where you can choose the user you want to invite to visualize your analysis. The users invited will be able to see the Analysis, but will not be able to edit it.

If the user is not on the list, you can create it in the user settings or request it to your account administrator.

dexma-advanced-analytics-15.png

Export to a Custom report

You can export both the Graph and the Advanced Analytics table by clicking on the Add to report icon underneath each block.

dexma-advanced-analytics-16.png

When you click on the Icon, a window will appear where you will have to set up the block name and select the custom report template where you want to add the block or create a new report template.

dexma-advanced-analytics-17.png

Export the graph to an Excel file

You can also export the Advanced Analytics Graph to an Excel file by clicking on the Export to excel icon underneath the block.

dexma-advanced-analytics-18.png 

Tips and tricks

Change the Data Series colors

You can change the color of each Data Series to make the graph more customizable for you and your clients.

dexma-advanced-analytics-19.png

Zoom in and out

The graphs allow you always to Zoom in and Out as you desire with a drag and drop.

dexma-advanced-analytics-gif-2.gif

 

Download to an Excel file more than 1 parameter from the same device

You can visualize in your Analysis 1 data series per parameter, so you can visualize at the same time all the parameters from the same device, into different data series.

To be able to export these to an Excel file, you have to make sure that the data series have different names (not the same), that's the only way to export them.

 

 

Was this article helpful?