About Self-Service Dataset

How to Create a Self-Service Dataset?

Self-service dataset provides a powerful and convenient way to prepare and integrate data. Whether IT personnel or business personnel, they can integrate and clean the data through the connection between nodes, and do a good job in data preparation.

By adding data nodes, users can use data from different types of datasets as input nodes, such as Excel datasets, embedded datasets, SQL datasets, Mongo and other arbitrary datasets. After the input node, access various connection and conversion nodes. Each node can be combined and edited arbitrarily. Finally, connect the result node of the dataset to complete the data preparation.

➢Example:

Users can add existing datasets to self-service datasets in the form of data nodes, and then add operation nodes as required to perform data transformation and output the final results.

The following figure shows the sales volume, order ID, store and membership level of multiple orders in the dataset:


Self-service datasets can be processed to output information in a more accurate and concise form.

➢For example: sort out the total sales volume of various members and rank them from high to low.

1) Create a dataset and select a self-service dataset.



2) Add the diagram dataset as a data node to the self-service dataset.



3) Add the operation node "Aggregate" to group the original node by member level and summarize and display the sales volume.



4) Add the operation node “Sort”  to sort the grouping and summary nodes in descending order of sales volume and output them to the dataset results.



5) Click Save to save the self-service dataset. A new dataset is obtained after simple processing as required.