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.
Background information
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.
Prerequisites
- 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
are obtained.
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
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.