Wiki source code of Créer un modèle de données
Last modified by Aurelie Bertrand on 2026/06/29 17:23
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | (% class="wikigeneratedid" %) | ||
| 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 | |||
| 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. | ||
| 9 | |||
| 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 | |||
| 12 | To create a new data model: | ||
| 13 | |||
| 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. | ||
| 18 | |||
| 19 | (% class="box infomessage" %) | ||
| 20 | ((( | ||
| 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. | ||
| 22 | ))) | ||
| 23 | |||
| 24 | [[image:Create_new_DM_en.png||alt="Create new data model"]] | ||
| 25 | |||
| 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**). | ||
| 29 | |||
| 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...**(%%) = | ||
| 31 | |||
| 32 | {{ddchildren}}{{/ddchildren}} |