In this article, you are going to learn how to use the Advanced Analytics tool in the EMS Platform.
Contents:
- Introduction
- Available frequencies
- Available parameters
- Requirements
- How does it work?
- Data Display
- Exporting data
- Tips and tricks
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 analyses 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:
- To send data to the EM Platform
- To accept the devices and datapoints generated when the data gets into the platform
- To assign those devices to their corresponding location
And that's it, you are ready to analyse your data!
How does it work?
- Go to the Advanced Analytics screen, under Analysis
- Create a new Analysis clicking on New Advanced Analytics
- Name it as you want, it will be automatically saved in the platform (no save button!)
- Add the Data Series to the graph, that you can later on edit.
From this point on, 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.
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).
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 edit, duplicate or delete the Data Series.
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
On the bottom right of the chart, you can select the type of graph you want to use from the dropdown menu, as you can see on the attached picture.
These are the types of chart available:
Lines
Bars
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.
Pie Chart
Custom
This type of chart allows you to modify the way you want to visualize each device: in lines, bars or stacked bars.
In the picture below, we can visualize water in bars, electricity in stacked bars and temperature in lines.
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.
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 colour 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.
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.
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 whether to autoscale the graph or set up manually a min and max value in case you need or want to do it.
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.
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.
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:
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.
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.
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.
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.
Tips and tricks
Change the Data Series colours
You can change the colour of each Data Series to make the graph more customizable for you and your clients.
Zoom in and out
The graphs allow you always to Zoom in and Out as you desire with a drag and drop.
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.