You can connect Alibaba Cloud Quick BI to a MaxCompute project to analyze large amounts of data in the MaxCompute project in real time. You can perform drag-and-drop operations and use various visualization methods to analyze MaxCompute data, explore business data, and generate reports in the Quick BI console. This topic describes how to connect Quick BI to a MaxCompute project and visualize MaxCompute data in the Quick BI console.
Quick BI is an easy-to-use, high-performance big data analytics and visualization platform that is developed for users in the cloud. Quick BI is a user-friendly platform that allows all users to perform the tasks of a data analyst. Quick BI not only allows business personnel to visualize data, but also helps in the development of digital operations. For more information about Quick BI, see Quick BI.
- A MaxCompute project is created.
For more information about how to create a MaxCompute project, see Create a MaxCompute project.
- The AccessKey ID and AccessKey secret that are used to access the MaxCompute project
You can obtain the AccessKey ID and AccessKey secret on the AccessKey Pair page.
- The Quick BI service is activated.
In this topic, Quick BI Basic is used.
Step 1: Connect Quick BI to MaxCompute
- Log on to the Quick BI console.
- In the top navigation bar, click Workspace. In the left-side navigation pane, click Data Sources.
- In the upper-right corner, click Create Data Source. On the Cloud Data Sources tab of the Add Data Source dialog box, click the MaxCompute card. In the Add MaxCompute Database dialog box, configure the parameters as described in the following table.
Parameter Description Name The name of the data source. For example, you can set this parameter to MaxCompute. Database Address The URL of the MaxCompute project. Set this parameter to http://service.odps.aliyun.com/api. Quick BI can connect to MaxCompute by using the public endpoint of MaxCompute. Project Name The name of the MaxCompute project.
This parameter specifies the name of your MaxCompute project instead of the DataWorks workspace to which the MaxCompute project corresponds. You can log on to the MaxCompute console, select the region where your MaxCompute project resides in the top navigation bar, and then view the name of the MaxCompute project on the Project management tab.
AccessKey ID The AccessKey ID that is used to access the MaxCompute project.
You can obtain the AccessKey ID on the AccessKey Pair page.
AccessKey Secret The AccessKey secret that corresponds to the AccessKey ID.
You can obtain the AccessKey secret on the AccessKey Pair page.
MaxCompute query acceleration Specifies whether to enable the MaxCompute Query Acceleration (MCQA) feature.
To enable the MCQA feature, select this check box. For more information about the MCQA feature, see Query acceleration.
- In the Add MaxCompute Database dialog box, click Test Connection. If the connectivity test is successful, click OK to connect Quick BI to the MaxCompute project.
Step 2: Use Quick BI to query and analyze data
- View all tables in the MaxCompute project
After you add the MaxCompute data source, you are automatically redirected to the Data Sources page. Information about all tables in the MaxCompute project is automatically displayed on the Tables tab.
- View the schema of a table
After you add the MaxCompute data source, find the table whose schema you want to view on the Tables tab and click the icon in the Actions column.
- View data in a table
After you add the MaxCompute data source, find the table whose data you want to view on the Tables tab and click the icon in the Actions column. In the dialog box that appears, write SQL code. Then, view and save the data.
- Visualize data
After you write SQL code to create a data table, you can create a dashboard and configure properties to visualize data in the table based on your business requirements. The operations that are used to create a data table are similar to the operations that are used to view data in a table.