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.

Prerequisites

Before you start, make sure that you complete the steps in the Activate services and Data modeling and analytics topics.

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

  1. Log on to the Quick BI console by using your Alibaba Cloud account.
  2. 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.
  3. On the page that appears, perform the steps that are shown in the following figure to connect the workspace to a data source.
    Add a MaxCompute data source
  4. 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.

    Data source connection parameters
    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.

  1. 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.
    Create a dataset
  2. On the Datasets page, modify the display formats of fields.
    1. Modify the display format of the date dimension type of the dt field.
      dt
    2. Modify the display format of the geographic dimension type of the province field.
      province
    3. Modify the display format of the geographic dimension type of the city field.
      city
    4. Create a hierarchy for the province field.
      New hierarchy
    5. Drag the city field to the province hierarchy. The drilling effect is shown in the following figure.
      City

Step 3: Display data analytics results on dashboards

Quick BI provides you with charts to display data analytics results. For more information, see Overview.

  1. On the Datasets page, click Create Dashboards.
    Create a dashboard
  2. Create a dashboard.
    1. Create a pv dashboard as shown in the following figure.
      pv dashboard
      Set the pv dashboard filter as shown in the following figure. Set the pv dashboard filter
      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.
    2. Create a uv dashboard as shown in the following figure.
      uv dashboard
      Set the uv dashboard filter as shown in the following figure. Set the uv dashboard filter
  3. Create a line chart as shown in the following figure.
    Line chart
    Set the line chart filter as shown in the following figure. Set the line chart filter
  4. Create a filled map.
    filed map
  5. After you complete the configuration, click Save on the Dashboards page.
  6. On the Dashboards page, click Preview to view the display effect.