You can connect Quick BI to a MaxCompute project to perform real-time online analysis. Quick BI features drag-and-drop operations and rich visualizations to help you analyze data, explore insights, and create reports. This topic describes how to connect Quick BI to a MaxCompute project and perform visual data analysis.
Background information
Quick BI is an easy-to-use and high-performance big data analytics platform designed for cloud users. It provides business personnel with powerful data visualization tools and accelerates data-driven operations.
Prerequisites
Before you begin, ensure the following prerequisites are met:
-
You have created a MaxCompute project.
-
You have an AccessKey ID and AccessKey Secret with permissions to access the MaxCompute project. You can obtain them from the AccessKey Management page.
-
You have activated the Quick BI service. This topic uses Quick BI Standard (Personal Edition) as an example.
Step 1: Connect Quick BI to MaxCompute
-
Log on to the Quick BI console.
-
Add a MaxCompute data source.
-
Navigate to the data source creation page.
-
Select the Alibaba MaxCompute data source.
-
In the connection configuration dialog box, configure the following parameters.
Parameter
Description
display name
A name for the data source connection. For example, MaxCompute.
database address
The endpoint used to connect to the MaxCompute project. Quick BI can connect to the MaxCompute service through an Alibaba Cloud internal network endpoint.
project name
The name of the destination MaxCompute project.
Enter the MaxCompute project name, not the workspace name. To find your project name, log on to the MaxCompute console, switch the region in the upper-left corner, and then navigate to Workspace > project management.
AccessKey ID
The AccessKey ID with permissions to access the destination MaxCompute project. You can obtain it from the AccessKey Management page.
AccessKey Secret
The AccessKey Secret for the AccessKey ID.
quota resource group
-
If you use the MaxCompute MaxQA query acceleration feature, enter the MaxQA quota name.
-
If other quota resource groups are available for the MaxCompute project, specify one as needed.
-
If you leave this parameter empty, the MaxCompute MCQA 1.0 feature is used for query acceleration by default.
This field is optional.
Enable file upload
If this option is selected, you can upload files. This option is selected by default.
-
-
Click test connection to test the connection.
For information about data source permission control issues, see Solutions to permission control issues and common errors for connecting Quick BI to a MaxCompute data source.
-
After the test is successful, click OK to add the data source.
NoteQuick BI asynchronously loads and updates MaxCompute cloud data sources. When adding a data source for the first time, you may need to wait 1 to 5 minutes for the data to be synchronized.
You can then find the created data source in the data source list.
-
Step 2: Query and analyze data
From the Quick BI interface, use the new data source to query and analyze data in your MaxCompute project.
To add tables or custom SQL queries from your MaxCompute data source, see Create a dataset.
To add visual charts and analyze data, see Create a dashboard and Visual chart overview.
To perform in-depth analysis by using drill-downs, see Step 3: Configure and display drill-down data.