All Products
Search
Document Center

Connect Quick BI to TSDB

Last Updated: Jun 05, 2020

Quick BI overview

Alibaba Cloud Quick BI is a cloud computing-based service that supports big data analysis and visualization. It is a lightweight, easy to use business intelligence (BI) tool. You can perform ad hoc queries and analysis on data by creating data sources and datasets. You can use workbooks and dashboards to visualize data.

For more information about Quick BI, see the Quick BI documentation.

Use Quick BI to query and analyze TSDB data

Create a data source based on a TSDB instance

You can create a data source based on a TSDB instance in the workspace of Quick BI. For more information, see the Quick BI documentation. Pay attention to the following points when you create the data source.

  1. Only users of the Quick BI Pro edition or Quick BI Professional edition can own workspaces and create a data source based on a TSDB instance.

  2. To create a data source based on a TSDB instance, you must enable the TSQL connection string feature of the TSDB instance. Follow these steps to enable this feature:Log on to the TSDB console, and click Manage for the TSDB instance on the Instances page.

  3. When you create a data source based on a TSDB instance, you must enter the AccessKey ID and the AccessKey Secret of the Alibaba Cloud account that is used to purchase the TSDB instance. You can click the button as shown in the following figure to obtain the AccessKey pair.

Then, a data source is created based on the TSDB instance in Quick BI.

Create a dataset to enable data analysis

After you create the data source based on the TSDB instance in Quick BI, a connection is established between Quick BI and TSDB. However, data analysis has not been enabled. To query and analyze data, you must create a dataset in Quick BI.

Datasets are similar to views in relational databases. Quick BI does not store data in datasets. However, you can define a rule to obtain a dataset by using a SQL query statement. The following figure shows the interface for defining a rule to obtain a dataset.

Create a dataset

After you select the data source based on the TSDB instance, you must enter a query statement that follows the Syntax and features in the interface as shown in the preceding figure. In the upper-right corner of the interface, you can click Execute to preview the result of the query statement.

Save the settings. Then, the dataset is created. You can also modify the query statement after the dataset is created.

During data query and analysis, the values in time series data are regarded as metric data. The values are specified in the value column in a single-value model and the field column in a multi-value data model. Tags and timestamps in time series data are regarded as dimension data. We recommend that you include both metric and dimension data in the query results that are used to create a dataset. Otherwise, the created dataset may fail to be analyzed.

Query, analyze, and visualize data

After a dataset is created, you can create data visualization components in Quick BI, such as dashboards and workbooks. Then, you can create your BI portal based on your business needs.

For more information about how to create BI portals, see the Quick BI documentation.

The following figure shows an example of a dashboard that is created based on time series data of the TSDB data source. You can also create visualization components to meet your business needs.

Dashboard example