In business intelligence (BI), a dataset is a collection of data that is used for analysis and reporting. A data node is an important part of a dataset that represents a specific data point or data element in a dataset. By using data nodes, data can be filtered, grouped, and calculated to derive valuable insights and trends.
The data set of JVS Intelligent BI brings together many data nodes, and I will make a detailed function description of each node.
1. Input node
Function description
The input node is the start node for data ingestion for dataset design to select the data source to work with. When selecting a data source, drag the input node into the dataset design canvas, the system will automatically pop up the data source selection pop-up box, after selecting the corresponding data source, you can freely check the required fields.
Supported types
Data sources currently support MYSQL, MongoDB, MariaDB, Oracle, PostgreSQL, JVS low-code automatically generated data models, and can also support offline dataset Excel. More data sources will continue to be added in the future.
Operating instructions
Ingestion and preview
Click the selected data input node, the configuration interface of the data node will be displayed on the lower side of the system, the amount of data query displayed in the upper left corner (the maximum can only be queried to 50, and the amount of data is too large to be displayed), and the selected data field name and type, and preview the corresponding data, as shown in the following figure
Change the data source
Click Change Data Source, and the data source selection box will pop up again to reselect the data source
2. Data expansion nodes
Data expansion is an important tool in the process of data visualization and processing, and its core role is to process and expand the original data table to achieve the function as shown in the figure below
The function configures the operation process
Operating instructions
1. Drag the data expansion field, connect the field expansion with the previous historical node, click the data expansion node, and enter the node configuration mode
2. Click the "Add Field" button, the system creates a row of field configuration operations, as shown in the following figure, the display information includes the name of the field, the name of the field edit button, the formula setting button of the field, the upper and lower (before and after the position of the display) sorting position dragged and the button to delete the field
3. Click the design content to enter the formula design interface, which includes formula parameters, a list of supported functions, a description of the function configuration, and the configuration of the function
Among them, the function parameter list includes context information, and the original fields of the data table; The built-in grove script function of the function list system, which can be prepared in advance according to your commonly used functions.
4. Configure the function, view the configuration results, when entering parameters, you can click the parameter list at the bottom left, the system automatically completes the use of parameters, and the function supports nesting operations
Finally, observe the effect:
Online demo: http://bi.bctools.cn/
GitHube address: https://gitee.com/software-minister/jvs-bi
Review of JVS Intelligent BI Past Dry Goods
Self-service data analysis platform: Introduction to JVS intelligent BI functions (2) Dataset management
Self-service data analysis platform: JVS intelligent BI function introduction (1) Data source