Data preparation, including data access and modeling, is the foundation of data lake visualization Analysis. Usually, users need to perform data access before they can perform visual analysis.
Data Connection is the first step to complete the interface with the database. After completion, a Dataset can be created as input to Data Visual Query Analysis or as input to Data Visualization Modeling. Visualization Modeling refers to the basic data processing, data cleaning, modeling processing, etc. for the existing data. After the processing is completed, the Dataset can be provided to the data Visual Query Analysis. Usually IT personnel, data developers, or data analysts will perform more operations in the Visualization Modeling process.
The logic between Data Connection, Dataset, Visualization Modeling, and more modules is depicted in the following figure:

In the top bar of the product interface, click "Data preparation", and the drop-down bar includes: Data Connection, Visualization Modeling, Dataset. Click on any entry to enter the corresponding module. As shown in the following figure:

• Overview of Data ConnectionCreate a Data Connection, which can be understood as creating a pass certificate to connect to the database and access the data table. Create a Data Connection to quickly obtain table information in the database, create a dataset, and then process or clean the input table during the Visualization Modeling process.
• Dataset OverviewDataset is the foundation for hosting and managing data in DataWind, as well as the foundation for Visual Query and Analysis. In layman's terms, it can be understood as a data table. The user needs to create the data source table that needs Analysis as a Dataset in order to perform subsequent modeling processing, visual Chart production, Dashboard production, and other work. In the Dataset module, you can create, edit, and manage Datasets.
• Overview of Visual ModelingData processing and modeling capabilities provided by DataWind are commonly referred to as ETL (Extract-Transform-Load), or data modeling. Visualization Modeling, as an intermediate link between data sources and visual display, allows users to perform drag-and-drop low-threshold, intelligent Compact data processing on the initial Dataset before Visual Query and Dashboard are produced, so that the data is cleaned, converted, and loaded to output Datasets that are more conducive to business Analysis. At the same time, the module can also achieve model training, algorithm prediction scenario and other capabilities.

The three modules are described above, and you are welcome to go to the specific single document to learn more.