**IMPORTANT NOTE**

**The functionalities of this module have been merged into our all-new Reporting engine.**

The** Data Explorer **by Ubidots** **is a collection of data analysis tools to help identify and analyze trends, anomalies, and correlations across variables in an App. With the **Data Explorer** you can:

Analyze data across different time periods on the go.*Historical data navigation*:Compare two or more variables in the same chart, or across several charts*Correlation analysis:**Max/Min analysis:*Apply regression algorithms to create trend lines and insights.*Regression Analysis:*Perform moving average analysis for anomaly detection*Anomaly Detection*:

## Table of Contents

Getting started with the Data Explorer

Navigating the Data Explorer

Example Analysis

## 1. Getting started with the Data Explorer

Access the Data Explorer from **"Data" –> "Analytics"** of your Ubidots Admin account Navbar.

To get started, simply click on “Add variables”, then select the variable(s) you wish to include in the analysis:

After adding your variables, you'll be able to modify their properties using the vertical configuration menu on the right of the Explorer user interface. You can set the **type**, **Y-axis** **range **and **aggregation** **method** of each variable to be displayed.

## 2) Navigating the Data Explorer

### The Data Explorer interface is made up of three components:

### 1. Time Frame Selector

Data Explorer analyzes data from the chosen **S tart Date** with

**S**

*pan**(*which is the amount of minutes, hours or days to include after the start date) to generate insights.

In additional to select the* Start Date* and data *Span* you must select an **aggregation method **(count, min, max, etc) and a **Sample Period **(the sample time period of the entire Time Frame selected).

**Aggregation Method Options**

**Count**: The amount of data points in each**Sample Period****First**: The first data point of each**Sample Period****Last**: The last data point of each**Sample Period****Max**: The max value of each**Sample Period****Min**: The min value of each**Sample Period****Sum**: The sum of all values within each**Sample Period**

### 2. Data Configuration Menu

From the right-side of the Data Explorer user interface you are able to add and remove variables for your analysis.

### 3. Charts

Based on the data configuration and time frame, you are able to view real-time charts to analyze, understand, and digest data more easily.

## 3) Example Analysis

### Adding a Moving Average

To create a moving average across your time frame, click on “Add Variable” in the configuration menu, then click on “Moving Average”:

Then, select the variable from which you'd like to compute the Moving Average:

A new variable with the Moving Average will be created.

### Adding a Regression Trendline

To add a trendline, click on “Add Variable” in the configuration menu, then select “Regression":

Then, select the variable from which you'd like to compute the Regression**; **a polynomial regression trendline will be added your chart:

You can modify the properties of the regression, including the degree of the polynomial within the Configuration panel. We'll also display the polynomial coefficients to allow you to easily replicate this in external tools such as Excel:

The polynomial coefficients can be interpreted using the following canonical expression:

where **t**:

Is the time relative to the first data point of the series being displayed

Has the same time units as the current

**Sample Period**in the date picker

**IMPORTANT NOTE: **

Ubidots computes the regression trend using the dots (data points) currently being displayed in the Data Explorer Chart. Ubidots

compute the regression using the entirety of the variable's time frame.*does not*Ubidots doesn't use milliseconds as the time unit to compute the regression, as it would yield very large-magnitude coefficients. For this reason, the sample period is used.

Other users also found helpful...