Wiki source code of Créer un modèle de données
Last modified by Aurelie Bertrand on 2026/06/29 17:23
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
21.1 | 1 | (% class="wikigeneratedid" %) |
| |
36.1 | 2 | Here we will look at how to connect to a data source, transform or combine data, process data and configure a data model. |
| 3 | \\Based on the tabular representation extracted from the data source, the **data model **enables to : | ||
| |
4.1 | 4 | |
| |
36.1 | 5 | * translate technical fields into functional fields adapted to the business language (semantic layer); |
| 6 | * add calculated measurements derived from the raw measurements in the data source; | ||
| 7 | * define analysis dimensions and any hierarchical levels within them; | ||
| 8 | * programme the data refresh and define the advanced parameters of the resulting cube. | ||
| |
4.1 | 9 | |
| |
36.1 | 10 | (% style="background-color:#ffffff; color:#333333; font-family:~"Open Sans~",sans-serif; font-size:10.5pt; font-style:normal; font-variant:normal; font-weight:400; text-decoration:none; white-space:pre-wrap" %)Based on this data model, you can then create the Flows that you will use to build your dashboard. |
| |
11.1 | 11 | |
| |
36.1 | 12 | To create a new data model: |
| |
4.1 | 13 | |
| |
36.1 | 14 | 1. In the** Models** tab, click on the role in which you want to create the data model. |
| 15 | 1. Click the **New model** button. | ||
| 16 | **[[image:Create_model_en.png||alt="Create model"]]** | ||
| 17 | ➡ The **Create a new data model** box appears, allowing you to select the data source type. | ||
| |
4.1 | 18 | |
| |
14.1 | 19 | (% class="box infomessage" %) |
| 20 | ((( | ||
| |
36.1 | 21 | 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. |
| |
14.1 | 22 | ))) |
| |
4.1 | 23 | |
| |
36.1 | 24 | [[image:Create_new_DM_en.png||alt="Create new data model"]] |
| |
4.1 | 25 | |
| |
36.1 | 26 | (% style="background-color:#ffffff; color:#333333; font-family:~"Open Sans~",sans-serif; font-size:10.5pt; font-style:normal; font-variant:normal; font-weight:400; text-decoration:none; white-space:pre-wrap" %)It is possible to connect to data from many different sources: [[files>>doc:.Data_connection.Connect_datasource_file.WebHome]], [[databases>>doc:.Data_connection.Connect_datasource_database.WebHome]], [[data catalogue>>doc:.Data_connection.connect_data_catalog.WebHome]], [[reports>>doc:.Data_connection.Connect_datasource_report.WebHome]], etc. |
| 27 | See [[Connecting to a data source>>doc:.Data_connection.WebHome]] for more information. | ||
| 28 | \\It is also possible to [[transform the data>>doc:.transform_data.WebHome]](%%) of a model (% style="background-color:#ffffff; color:#333333; font-family:~"Open Sans~",sans-serif; font-size:10.5pt; font-style:normal; font-variant:normal; font-weight:400; text-decoration:none; white-space:pre-wrap" %)(**Transformers**) or to [[combine the data >>doc:.Combine_data.WebHome]]of several data models (**Union**, **Join**). | ||
| |
8.1 | 29 | |
| |
36.1 | 30 | = (% style="background-color:#ffffff; color:#333333; font-family:~"Open Sans~",sans-serif; font-size:15pt; font-style:bold; font-variant:normal; font-weight:400; text-decoration:none; white-space:pre-wrap" %)**To find out more...**(%%) = |
| |
19.1 | 31 | |
| |
18.1 | 32 | {{ddchildren}}{{/ddchildren}} |