FineBI

FineBI Introduction

As a business intelligence product, FineBI has a system architecture of data processing, real-time analysis, multidimensional analysis Dashboard and other functions. FineBI supports rich data source connection and analysis and management of tables with multiple views. FineBI can successfully support the modeling and visualization of internal and external data of Apache Doris.

Precondition

Install FineBI 5.0 or later, Download link: https://intl.finebi.com/

Login and Connection

1. Create account and log in FineBI

   

2. Select the Built-in database, If you need to select an external database configuration, the documentation is available：https://help.fanruan.com/finebi-en/doc-view-4437.html

   Note

   It is recommended to select the built-in database as the information repository of FineBI. The database type selected here is not the target database for querying and analyzing data, but the database for storing and maintaining FineBI model, dashboard and other information. FineBI needs to add, delete, modify and check it.

   

3. Click the Management System button and select the database connection management in Data Connections to create a new database connection.

   

4. On the new database connection page, select MySQL database

   

5. Fill in the link information of the Doris database

   • Parameters are described as follows：

     • Username：The username for logging into Doris。

     • Password：Password of the current user。

     • Host：IP address of the FE host in the Doris cluster。

     • Port：FE query port of the Doris cluster。

     • Coding：Encoding format of the Doris cluster。

     • Name Database：Target database in Doris cluster。

   

6. Click the test link. Connection succeeded is displayed when the connection information is correct

   

Create model

1. In the "Public Data" section, click to create a new dataset. Then click the database table

   

2. You need to import tables in the existing database connection

   

3. You need to refresh each imported table after importing the table. You can analyze the table in the topic only after refreshing the table

   

4. Add the imported public data to the edited topic, and then conduct compass analysis and configuration according to business logic.