After you process the rpt_user_info_d table by backfilling data, you can create a dashboard in the Quick BI console to visualize the profile analysis results of website users in this table.

Prerequisites

The data that you want to visualize is processed. For more information, see Process data. You have logged on to the Quick BI console.

Background information

The rpt_user_info_d table contains fields such as region, device, gender, age, and zodiac. You can view the following data on a dashboard: core metrics, periodic changes, regional distribution, age and zodiac distribution, and records of users. If you want to view changes in data over a specified period of time, we recommend that you backfill data of at least one week.

Procedure

  1. In the Workspaces section of the Quick BI console, click DefaultWorkspace to go to the default workspace. You can also click Personal Workspace to go to your personal workspace.
  2. On the page that appears, click Data Sources in the left-side navigation pane. On the Data Sources page, click Create Data Source in the upper-right corner. In the Add Data Source dialog box, select MaxCompute on the Cloud Data Sources tab.
  3. In the Add MaxCompute Database dialog box, enter the following information: the display name of the MaxCompute data source, the name of your MaxCompute project, your AccessKey ID, and your AccessKey secret. Use the default value for Database Address. For more information about the endpoint of MaxCompute, see Endpoints.
    Click Test Connection. When the message The data source can be connected. appears, click Add.
  4. On the page that appears, find the rpt_user_info_d table and click Create Dataset in the Actions column.

    In the Create Dataset dialog box, enter the dataset name, select a location to store the dataset, and then click OK.

  5. On the Datasets page, click the created dataset to edit the dataset.
    You can perform the following operations on a dataset: change dimensions and measures, change the dimension type, add calculated fields, create hierarchies, change the data type of a field, modify the aggregate mode of measures, and create association models.
  6. Change the dimension types of fields. After you change the dimension types of fields, you can filter data based on the field values.
    1. Change the dimension type of the dt field.
      In the left-side navigation pane, right-click the dt field. Then, choose Change Dimension Type > Date/Time (Source Format) > yyyyMMdd.
    2. Change the dimension type of the region field.
      In the left-side navigation pane, right-click the region field. Then, choose Change Dimension Type > Geo > State/Province/Municipality. After you change the dimension type of the region field, a location icon appears to the left of the field in the left-side navigation pane.
  7. Create a dashboard.
    You can create a dashboard to display the most recent data. To create a dashboard, configure the display content, layout, and style. Then, create charts, and associate charts to enable filter interaction.
    1. On the Datasets page, find the rpt_user dataset and click Create Dashboard in the Actions column. In the Create Dashboard dialog box, select Standard for Select Dashboard Type. The dashboard edit page appears.
      Note
      • If you use Quick BI Basic or Quick BI Pro, a dashboard of the standard type is created after you click Create Dashboard in the Actions column.
      • If you use Quick BI Enterprise Standard, the Create Dashboard dialog box appears after you click Create Dashboard in the Actions column. You can create a dashboard of the standard type or full screen type in the Create Dashboard dialog box. In this topic, a dashboard of the standard type is created.
    2. In the upper part of the page, click the Kanban icon. A chart sample appears in the blank area.
      On the Data tab on the right, select the rpt_user dataset from the drop-down list in the upper-right corner. Then, drag pv from the Measures list to the Metrics (Mea.) field. The rpt_user_info_d table is a partitioned table. You must select a dimension under dt, drag the dimension to the Filters field, and then click the Filter icon next to the dimension. In the Set Filter dialog box, specify a time range. In this example, the specified time range is 2019 to 2019. Then, click Update in the lower part of the Data tab.
    3. Create a trend chart. In the upper part of the page, click the Line Chart icon. A line chart sample appears in the blank area.
      Set the parameters on the Data tab and click Update.
      • Value Axis (Mea.): Set the value to pv.
      • Category Axis (Dim.): Set the value to dt(day).
      • Color Legend (Dim.): Set the value to age_range.
      • Filters: Drag dt(year) to this field.
    4. Create a filled map. In the upper part of the page, click the Colored Map icon. A map sample appears in the blank area. On the Data tab on the right side, select the rpt_user dataset from the drop-down list in the upper-right corner, drag region from the Dimensions list to the Geo Location (Dim.) field, and then drag pv from the Measures list to the Colorscale (Mea.) field. Then, click Update.
    5. In the upper-right corner, click Save and then click Preview to view the created dashboard.