Language	Title	Date
en	-	-
fr	-	-
es	-	-

Wiki source code of Assistant de création de tableau de bord

Last modified by Aurelie Bertrand on 2025/02/07 10:08

version	line-number	content
161.1	1	{{ddtoc}}{{/ddtoc}}
1.1	2
161.1	3	----
1.1	4
272.1	5	= Preamble =
1.1	6
77.5	7	(((
272.1	8	The dashboard creation wizard aims at helping you to create a complete dashboard in few clicks from a datasource and this, in an intuitive manner.
1.1	9
272.1	10	This tool suggests multiple dashboards that are meant to be configurable so they can fit the users' usage as much as possible.
77.5	11	)))
	12
11.2	13	(((
77.5	14	{{info}}
272.1	15	A datasource is where the data comes from. The datamodel structures this data.
77.5	16	{{/info}}
11.2	17
77.5	18	{{info}}
272.1	19	A dashboard is a set of pages allowing you to vizualise information flows on the web and to interact with the data.
77.5	20	{{/info}}
	21
272.1	22	= (% style="color:inherit; font-family:inherit; font-size:29px" %)Prerequisite(%%) =
77.5	23	)))
	24
	25	(((
272.1	26	Anyone who wants to use the assistant should have the authorization group named "Access Dashboard Assistant".
11.2	27	)))
	28
272.1	29	= Using the wizard =
1.1	30
272.1	31	From the dashboards editor, select on the top right toolbar the button Dashboard creation assistant.
1.1	32
272.1	33	The first view shows two options :
259.2	34
272.1	35	* The first consists in loading your file directy from your computer. Supported formats: xls, xlsx, csv, xml and json.
	36	* The second consists in selecting a data file provided by DigDash. Each corresponds to a pre-configured dashboard.
170.3	37
272.1	38	:
	39	: [[image:1618573802391-750.png]]
	40	:
	41	:
	42	: [[image:1618573922196-567.png\|\|queryString="width=1228&height=771" height="771" width="1228"]]
	43	:
	44	:
	45	: For Excel files, you can select the sheet to work with.
269.1	46
272.1	47	: [[image:1618574042910-360.png\|\|queryString="width=1230&height=772" height="772" width="1230"]]
1.1	48	:
272.1	49	: The tool then does a contextual analysis of the file to suggest the most appropriate dashboards.
4.1	50	:
166.1	51
	52	(((
272.1	53	= (% id="cke_bm_230S" style="display:none" %) (%%)Case n°1 : no pre-configured dashboard has been detected =
184.1	54
272.1	55	It is possible that no pre-configured dashboard correpond to the loaded datasource.
166.1	56
272.1	57	In this case, you will only have the possibility to create an automatic or personalized dashboard.
167.1	58
272.1	59	[[image:1618574130805-718.png\|\|queryString="width=1231&height=773" height="773" width="1231"]]
170.1	60
272.1	61	== Selecting the automatic dashboard ==
193.1	62
272.1	63	The automatic dashboard pre-selects graphics in your dashboard that you can of course enrich afterwards according to different analysis axis explained below.
167.1	64
272.1	65	[[image:automatic.gif\|\|queryString="width=1230&height=771" height="771" width="1230"]]
170.1	66
193.1	67
272.1	68	== Selecting the personalized dashboard ==
166.1	69
272.1	70	With the personalized dashboard, you are completely free to choose the graphics to create for your dashboard according to the analysis axis explained below.
184.1	71
272.1	72	[[image:personalized.gif\|\|queryString="width=1235&height=775" height="775" width="1235"]]
171.4	73
179.1	74	(((
272.1	75	== Data source edition ==
170.1	76
272.1	77	It is highy recommended to have knowledge of the way the data is structured and to bring any potentiel corrections.
166.1	78
272.1	79	The button [[image:1618577139021-759.png]] will allow you to learn more about your source. Wou will be able to vizualize your data and configure them.
184.1	80
272.1	81	=== Preview of the datasource ===
170.2	82
272.1	83	The tab "Preview data" allows you to visualize a part of your data to understand it.
166.1	84
272.1	85	[[image:1618574717251-226.png\|\|queryString="width=1237&height=776" height="776" width="1237"]]
25.5	86
272.1	87	Options exist so you can form your data in better ways.
1.1	88
272.1	89	These are different according to the type of the imported source. For example, you can choose the sheet only for an Excel file.
174.1	90
272.1	91	=== Configuration of the datamodel ===
200.1	92
272.1	93	{{info}}
	94	The datamodel is an "interlligent" representation of a data source It is composed of measures and dimensions.
	95	{{/info}}
38.1	96
272.1	97	The tab "Configure the datamodel" allows you to configure the measures and dimensions detected by DigDash.
156.1	98
272.1	99	You will be able to modify their type, their diisplay name and event create derivated measures from them.
38.1	100
272.1	101	[[image:1618575055439-775.png\|\|queryString="width=1249&height=784" height="784" width="1249"]]
	102	)))
174.1	103
272.1	104	:
38.1	105
232.2	106	(((
272.1	107	==== Changing column types ====
39.1	108
272.1	109	Digdash automatically detects whether the columns of your source are dimensions or measures.
155.1	110
272.1	111	{{info}}
	112	A dimension is composed of an organized set of members according on or multiple hierarchies.
	113	{{/info}}
155.1	114
272.1	115	{{info}}
	116	A measure is a quantity to represent that can be aggregated with a formula.
	117	{{/info}}
155.1	118
272.1	119	If you decide than a column is a measure instead of a dmension, or vice versa, you can change its type.
155.1	120
272.1	121	Note that the configuration of the data can have consequences in the contextual analysis of the data and then change it.
200.1	122
272.1	123	==== Adding derivated measures ====
155.1	124
272.1	125	The button [[image:1618575124988-446.png]] allows you to add calculated measures to your datamodel.
155.1	126
272.1	127	{{info}}
	128	A calculated measure or derivated meadure is a measure which definition comes from a formula based or not on other dimensions / measures.
	129	{{/info}}
258.2	130
272.1	131	(% class="wikigeneratedid" %)
	132	There are different ways to create them. you can use the existing preestablished functions (general or transformers) or define your own formulas.
155.1	133
272.1	134	===== General functions =====
155.1	135
272.1	136	[[image:1618575190524-652.png]]
155.1	137
272.1	138	General functions are basic formulas.
155.1	139
272.1	140	===== Transformers =====
174.1	141
272.1	142	[[image:1618575418755-392.png]]
174.1	143
272.1	144	Les fonctions de transformations s'appliquent sur des mesures et vous permettent d'afficher les valeurs pour l'année précédente, le mois précédent la semaine précédente ou le jour précédent.
155.1	145
272.1	146	===== Formula =====
155.1	147	)))
	148
272.1	149	: Selecting "Formula..." you will have this following dialog appear :
174.1	150	:
272.1	151	: [[image:1618575507277-616.png]]
	152	:
	153	: This dialog allows you to freely define the formula to apply to the associated columns.
	154	: You will need to enter a name for it.
155.1	155
272.1	156	== Graphics choice ==
155.1	157
272.1	158	Selecting an automatic or personalized dashboard will lead you to a view similar to this one below.
155.1	159
272.1	160	The left part shows the list of graphics to choose for the right part of this interface.
155.1	161
272.1	162	The right part shows the content of the dashboard you want to build.[[image:1618576683430-948.png\|\|queryString="width=1255&height=787" height="787" width="1255"]]
24.2	163
272.1	164	Dimensions and measures of your datasource are automatically recognized. The user can simply create the graphics from them.
1.1	165
272.1	166	* The part Custom graphics allows you to do a free analysis: according to the number of dimensions and measures of the graphic you want to create, you will also be able to choose the type of graphic to display.
	167	* The part Suggested graphics corresponds to list of suggested analyses. This list depends on the columns of your datamodel. For example, the suggestion of a geographic analysis will ony appear if at least one geographic dimension exists.
	168	Three types of analyses exist:
	169	** //Trend analysis//: at least one dimension of time has been detected. The line chart is automatically suggested.
	170	** //Geographic analysis//: at leat one geographic dimension has been detected. The representation by a map is automatically suggested.
	171	** //List//: one or multiple dimensions have been detected. The table representation is automatically suggested.
78.5	172
272.1	173	If you choose to have an automatic dashboard, dimensions et measures are pre-selected and graphics are automatically selected for the dashboard.
1.1	174
272.1	175	If you choose an personalized dashboard, you can select the dimensions and measures yourself for each analysis.
1.1	176
272.1	177	: Click on [[image:1602843729099-538.png]] to add the graphic to the dashboard.
	178	)))
55.2	179
175.1	180	(((
272.1	181	= (% style="color:inherit; font-family:inherit; font-size:29px" %)Case n°2 : pre-configured dashboards have been detected(%%) =
175.1	182	)))
	183
272.1	184	: DigDash can detect if a pre-configured dashboard matches to your datasource.
	185	:
	186	: You can then select this pre-made dashboard with pre-configured and pre-selected graphics or choose to create an automatic or personalized dashboard.
	187	:
216.2	188
59.2	189	(((
272.1	190	== Selecting a pre-configured dashboard ==
229.6	191
272.1	192	In your example, the source file retail_v7_de_world.xls matches the "Retail" dashboard.
229.6	193
272.1	194	[[image:retail.gif\|\|queryString="width=1251&height=784" height="784" width="1251"]]
229.6	195
272.1	196	: When selecting it, the dashboard will be composed of graphics dealing with Retail (Sales, Turnover, etc.).
	197	:
229.6	198
254.2	199	(((
272.1	200	== Graphics choice ==
254.2	201	)))
	202
272.1	203	: Selecting this dashboard will generate a list of relevant graphical representations that will copose yout dashboard: these graphics below are specific for a Retail dashboard.
73.2	204
272.1	205	The pre-configured graphics associated to the selected dashboard are directly added to the content of the dashboard to build.
73.2	206
272.1	207	[[image:1618576885443-947.png\|\|queryString="width=1261&height=792" height="792" width="1261"]]
76.2	208
272.1	209	Moreover, you can enrich the content of your dashboard adding your own graphics.
73.2	210
272.1	211	[[image:1618576982169-684.png]]
73.2	212
272.1	213	= (% style="color:inherit; font-family:inherit; font-size:29px" %)Dashboard construction(%%) =
66.6	214	)))
	215
272.1	216	: You have mutiple options to handle the vizualisation of your dashbord.
66.6	217
66.2	218	(((
272.1	219	== (% id="cke_bm_322S" style="display:none" %) (%%)Dashboard name ==
84.2	220
	221	(% class="wikigeneratedid" %)
272.1	222	Give a name to you dashboard. It is mandatory.
84.2	223
272.1	224	(% class="wikigeneratedid" %)
	225	Indded, it will be used as the name of a category in the wallet.
	226
84.2	227	{{info}}
272.1	228	A wallet is a work space which rights are given according to each user.
84.2	229	{{/info}}
	230
272.1	231	== Graphics arrangement ==
66.2	232
272.1	233	DigDash offers multiple layouts to conviniently arrange your graphics in your dashboard. The default layout is the automatic one.
59.2	234
	235	[[image:1602856226445-298.png]]
	236
272.1	237	The automatic layout automatically arranges your content adjusting it at its best, without any graphics limation.
59.2	238
272.1	239	Each layout has a maximum of graphics capacity, you can know it hovering it.
59.2	240
272.1	241	[[image:1618576556792-934.png]]
59.2	242
	243
84.2	244	(% class="wikigeneratedid" id="HOrdredesgraphiques" %)
272.1	245	Drag and drop the graphics of your dashboard to order them. The first is the most important..
59.2	246
272.1	247	[[image:1618576621291-327.png]]
59.2	248
272.1	249	== Validate and finish the dashboard construction ==
66.2	250
272.1	251	(% id="cke_bm_291S" style="display:none" %) (%%)Click on the button [[image:1618577093224-824.png]] to terminbate the dashoard construction.
66.5	252
272.1	253	Wait a few seconds.
66.5	254
272.1	255	The assistant will close eventually and your final dashboard will be dsisplayed in the Editor.
66.5	256
272.1	257	If you wish, you can enrich it in the Dashboards Editor.
61.1	258	)))
1.1	259
97.2	260
272.1	261	= Datamodel edition =
175.1	262
272.1	263	A datamodel issued from this assistant can be modified afterwards. You can add more derivated measures for example if you need to.
225.2	264
272.1	265	[[image:1618577825471-465.png]]
225.2	266
97.2	267
272.1	268	To access the edition interface, you have two possibilities:
97.2	269
272.1	270	- Click on the wheel on a graphic and select the menu "Edit the datamodel.
99.2	271
272.1	272	[[image:1618577862402-653.png]]
99.2	273
272.1	274	[[image:1618577880079-750.png]]
97.2	275
98.2	276
272.1	277	- via the button "Edit" when creating new graphics using a datamodel.
98.2	278
272.1	279	[[image:1618577918061-878.png]]

Wiki source code of Assistant de création de tableau de bord

Sommaire