This topic guides you through the visual analytics steps in this tutorial using Quick BI, including creating data sources, datasets, and configuring data dashboard charts.
Step 1: Create a data source
Log on to the Quick BI console.
Follow the instructions in the figure below to access the Create Data Source dialog box.
In the Mysql-alibaba Cloud section, enter the connection parameters as follows:
Parameter
Description
Database source
Choose Alibaba Cloud.
Connection parameters
Select Auto Connect.
Connect to database
Choose the created database.
Display name
System auto-fills, no input required.
Database address
System auto-fills, no input required.
Port
Default port is 3306.
Database
Select the flink_dataphin database.
Username and password
Input your username and password for the database.
Database version
Choose version 8.0.
Click OK to finalize the data source creation.
Step 2: Create a dataset
Follow the instructions in the figure below to navigate to the New Dataset page.
Select the created data source and drag the ads_gross data table onto the canvas.
Click Save.
In the Save Dataset dialog box, set the following save parameters:
Parameter
Description
Name
Enter flink_dataphin.
Location
Default location is the root directory.
Click OK.
Step 3: Create a data dashboard
Follow the instructions in the figure below to go to the Data Dashboard page.
Refer to the instructions in the figure below to add a Basic Leaderboard chart to the canvas.
Select the newly added Basic Leaderboard chart and set up the chart parameters as follows:
Parameter
Description
①Dataset
Choose flink_dataphin.
②Field
Category/Dimension: Choose the prod_code field.
Metric/Measure: Choose the sale_num measure.
③Auto-refresh
Enable Auto-refresh and set the interval to 3 seconds.
Click Update to display the data leaderboard information on the Leaderboard chart.