Azure Time Series Insights explorer

This article describes the features and options in general availability for the Azure Time Series Insights explorer web app. The Time Series Insights explorer demonstrates the powerful data visualization capabilities provided by the service and can be accessed within your own environment.

Azure Time Series Insights is a fully managed analytics, storage, and visualization service that makes it simple to explore and analyze billions of IoT events simultaneously. It gives you a global view of your data, which lets you quickly validate your IoT solution and avoid costly downtime to mission-critical devices. You can discover hidden trends, spot anomalies, and conduct root-cause analyses in near real time. The Time Series Insights explorer is currently in public preview.

Tip

For a guided tour through the demonstration environment, read the Azure Time Series Insights quickstart.

Video

Learn about querying data by using the Time Series Insights explorer.

Prerequisites

Before you can use Time Series Insights explorer, you must:

Explore and query data

Within minutes of connecting your event source to your Time Series Insights environment, you can explore and query your time series data.

  1. To start, open the Time Series Insights explorer in your web browser. On the left side of the window, select an environment. All environments that you have access to are listed in alphabetical order.

  2. After you select an environment, either use the From and To configurations at the top, or click and drag over the timespan you want. Select the magnifying glass in the upper-right corner, or right-click on the selected timespan and select Search.

  3. You also can refresh availability automatically every minute by selecting the Auto On button. The Auto On button only applies to the availability chart, not the content of the main visualization.

  4. The Azure cloud icon takes you to your environment in the Azure portal.

    Time Series Insights environment

  5. Next, you see a chart that shows a count of all events during the selected timespan. Here you have a number of controls:

    • Terms Editor panel: The term space is where you query your environment. It’s found on the left side of the screen:
      • Measure: This drop-down list shows all numeric columns (Doubles).

      • Split by: This drop-down list shows categorical columns (Strings).

      • You can enable step interpolation, show minimum and maximum, and adjust the y-axis from the control panel next to Measure. You also can adjust whether data shown is a count, average, or sum of the data.

      • You can add up to five terms to view on the same x-axis. Use the Copy-down button to add an additional term, or select Add to add a fresh term.

        Terms Editor panel

      • Predicate: Use the predicate to quickly filter your events by using the set of operands listed in the following table. If you conduct a search by selecting or clicking, the predicate automatically updates based on that search. Supported operand types include:

        Operation Supported types Notes
        <, >, <=, >= Double, DateTime, TimeSpan
        =, !=, <> String, Bool, Double, DateTime, TimeSpan, NULL
        IN String, Bool, Double, DateTime, TimeSpan, NULL All operands should be of the same type or be NULL constant.
        HAS String Only constant string literals are allowed at the right side. Empty string and NULL aren't allowed.
      • Examples of queries

        Example queries

  6. You can use the Interval Size slider tool to zoom in and out of intervals over the same timespan. The slider provides more precise control of movement between large slices of time that show smooth trends down to slices as small as the millisecond, which allow you to see granular, high-resolution cuts of your data. The slider’s default starting point is set as the most optimal view of the data from your selection to balance resolution, query speed, and granularity.

  7. The Time brush tool makes it easy to navigate from one timespan to another.

  8. Use the Save command to save your current query and share it with other users of the environment. When you use Open, you can see all of your saved queries and any shared queries of other users in environments you have access to.

    Queries

Visualize data

  1. Use the Perspective View tool for a simultaneous view of up to four unique queries. The Perspective View button is in the upper-right corner of the chart.

    Perspective view

  2. View a chart to visually explore your data, and use the Chart tools:

    • Select or click a specific timespan or a single data series.
    • Within a timespan selection, you can zoom or explore events.
    • Within a data series, you can split the series by another column, add the series as a new term, show only the selected series, exclude the selected series, ping that series, or explore events from the selected series.
    • In the filter area to the left of the chart, you can see all displayed data series and reorder by value or name. You also can view all data series or any pinned or unpinned series. You can select a single data series and split the series by another column, add the series as a new term, show only the selected series, exclude the selected series, pin that series, or explore events from the selected series.
    • When you view multiple terms simultaneously, you can stack, unstack, see additional data about a data series, and use the same y-axis across all terms. Use the buttons in the upper-right corner of the chart.

    Chart tool

  3. Use the heatmap to quickly spot unique or anomalous data series in a given query. Only one search term can be visualized as a heatmap.

    Heatmap

  4. When you explore events by selecting or right-clicking, the Events panel is made available. Here, you can see all of your raw events and export your events as JSON or CSV files. Time Series Insights stores all raw data.

    Events

  5. Select the STATS tab after you explore events to expose patterns and column stats.

    • Patterns: This feature proactively surfaces the most statistically significant patterns in a selected data region. You don't have to look at thousands of events to understand what patterns require the most time and energy. With Time Series Insights, you can jump directly into these statistically significant patterns to continue conducting an analysis. This feature is also helpful for post-mortem investigations into historical data.

    • Column Stats: Column stats provide charts and tables that break down data from each column of the selected data series over the selected timespan.

      STATS

Now you've seen the various features and options that are available within the Time Series Insights explorer web app.

Next steps