Creating a data model

Last modified by Aurelie Bertrand on 2026/06/29 17:23

Here we will look at how to connect to a data source, transform or combine data, process data and configure a data model.

Based on the tabular representation extracted from the data source, the data model enables to :

  • translate technical fields into functional fields adapted to the business language (semantic layer);
  • add calculated measurements derived from the raw measurements in the data source;
  • define analysis dimensions and any hierarchical levels within them;
  • programme the data refresh and define the advanced parameters of the resulting cube.

Based on this data model, you can then create the Flows that you will use to build your dashboard.

To create a new data model:

  1. In the Models tab, click on the role in which you want to create the data model.
  2. Click the New model button.
    Create model
    ➡ The Create a new data model box appears, allowing you to select the data source type.

Note that you can still change the role in which the model will be created via the drop-down list at the top of the window. The field can also be used as a search bar for a large number of roles.

Create new data model

It is possible to connect to data from many different sources: files, databases, data catalogue, reports, etc.
See Connecting to a data source for more information.

It is also possible to transform the data of a model (Transformers) or to combine the data of several data models (Union, Join).

To find out more...