After you process the rpt_user_trace_log table, you can create a dashboard in the
Quick BI console to display the profiles of website users in the table.
Background information
The rpt_user_trace_log table contains fields such as country, province, city, device_brand,
use_time, and pv. You can perform the following steps to create a dashboard to display
core metrics of users, periodic changes of user behavior data, and regional distribution
and records of users.
Step 1: Connect to a data source
- Log on to the Quick BI console by using your Alibaba Cloud account.
- On the homepage of the Quick BI console, select the workspace that you want to connect
to a data source.
In this example, the default workspace is used.
- On the page that appears, perform the steps that are shown in the following figure
to connect the workspace to a data source.
- In the Add MaxCompute Database dialog box, configure the parameters that are used to connect to the data source
and test the network connectivity.
After the data source is added, you can view it in the data source list.

Parameter |
Description |
Name |
The name of the data source. The name is displayed in the data source list. The name
must be 1 to 50 characters in length, and can contain letters, digits, underscores
(_), forward slashes (/), backslashes (\), vertical bars (|), parentheses (), and
brackets [].
|
Database Address |
A default address is displayed. In most cases, you do not need to change the address.
Note The address of the data source varies based on the region where the data source is
deployed. For more information, see Endpoints.
|
Project Name |
The name of the MaxCompute project. You can log on to the MaxCompute console and view the project name on the Project management tab.
|
AccessKey ID |
The AccessKey ID of your Alibaba Cloud account or a RAM user of your Alibaba Cloud
account. You can obtain the AccessKey ID on the AccessKey Pair page in the Resource Access Management (RAM) console.
|
AccessKey Secret |
The AccessKey secret that corresponds to the AccessKey ID. You can obtain the AccessKey
secret on the AccessKey Pair page in the RAM console.
|
Step 2: Create a dataset
Datasets are the basis to display data analytics results in Quick BI. You can create
a dataset for the data tables that you want to analyze. For more information about
how to create a dataset, see Create a dataset.
- In the My Data Sources section of the Data Sources page, click the MaxCompute data source to which the workspace is connected. Find
the rpt_user_trace_log table on the right side of the page, and click the Create Dataset icon in the Actions column.
- On the Datasets page, modify the display formats of fields.
- Modify the display format of the date dimension type of the dt field.
- Modify the display format of the geographic dimension type of the province field.
- Modify the display format of the geographic dimension type of the city field.
- Create a hierarchy for the province field.
- Drag the city field to the province hierarchy. The drilling effect is shown in the following figure.
Step 3: Display data analytics results on dashboards
Quick BI provides you with charts to display data analytics results. For more information,
see Overview.
- On the Datasets page, click Create Dashboards.
- Create a dashboard.
- Create a pv dashboard as shown in the following figure.

Set the pv dashboard filter as shown in the following figure.

Note The rpt_user_trace_log table is a partitioned table. Therefore, you must set a time range in the filter. The time range of the filter in the preceding figure is from 2021 to 2021.
- Create a uv dashboard as shown in the following figure.

Set the uv dashboard filter as shown in the following figure.

- Create a line chart as shown in the following figure.

Set the line chart filter as shown in the following figure.

- Create a filled map.
- After you complete the configuration, click Save on the Dashboards page.
- On the Dashboards page, click Preview to view the display effect.