Create Azure Time Series Insights and Visualize Device Data

Create Time Series Insights

Azure Time Series Insights is a fully managed analytics, storage, and visualization service for managing IoT-scale time-series data in the cloud. It provides massively scalable time-series data storage and enables you to explore and analyze billions of events streaming in from all over the world in seconds. Use Time Series Insights to store and manage terabytes of time-series data, explore and visualize billions of events simultaneously, conduct root-cause analysis, and to compare multiple sites and assets.

Time Series Insights has four key jobs:

• First, it’s fully integrated with cloud gateways like Azure IoT Hub and Azure Event Hubs. It easily connects to these event sources and parses JSON from messages and structures that have data in clean rows and columns. It joins metadata with telemetry and indexes your data in a columnar store.
• Second, Time Series Insights manages the storage of your data. To ensure data is always easily accessible, it stores your data in memory and SSD’s for up to 400 days. You can interactively query billions of events in seconds – on demand.
• Third, Time Series Insights provides out-of-the-box visualization via the TSI explorer.
• Fourth, Time Series Insights provides a query service, both in the TSI explorer and by using APIs that are easy to integrate for embedding your time series data into custom applications.

In this lab you will learn

• how to set up a Time Series Insights environment
• explore
• analyze time series data of your IoT solutions or connected things

Click on Create a Resource and click on Internet of Things

Click on Time Series Insights

Select the resource group you previously created and click Create button

Create Event Source

Create Event Source to connect to IoTHub. Please make sure you use a unique Consumer Group. Time Series Insights has a requirement to have its own unique consumer group

Select the appropriate consumer group and click Create button

Setup Time Series Insights

Go To Time Series Insights, Click on Go To Environment which will take you to Time Series Insights Explorer

If you get Data Access Policy Error execute the following steps

Go To Environment Topology and

Click on Add Button

Select Contributor Role

Select User

Time Series Insights Explorer

Go To Time Series Insights Explorer

Split By ID. You will see data flowing from two devices. MXChip and Pi Simulator.

Select humidity and Split By ID. You will see data flowing from two devices. MXChip and Pi Simulator.

Right Click to Explore events. You can download events in CSV and JSON format by clicking on CSV or JSON buttons

Create a perspective by clicking on the image shown below

Click + to add a new query

Select Temperature and split by Device ID and click on perspective image.

Create a chart by selecting a timeframe with drag feature

Create a Chart by adding a predicate

Perspective with 4 different charts and also changed Title

Click on Heatmap

View data in a table