Dashboard Creation Wizard

Last modified by Aurelie Bertrand on 2023/05/11 10:24


Preamble

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.

This tool suggests multiple dashboards that are meant to be configurable so they can fit the users' usage as much as possible.

A datasource is where the data comes from. The datamodel structures this data.

A dashboard is a set of pages allowing you to vizualise information flows on the web and to interact with the data.

Prerequisite

Anyone who wants to use the assistant should have the authorization group named "Access Dashboard Assistant".

Using the wizard

From the dashboards editor, select on the top right toolbar the button Dashboard creation assistant.

The first view shows two options :

  • The first consists in loading your file directy from your computer. Supported formats: xls, xlsx, csv, xml and json.
  • The second consists in selecting a data file provided by DigDash. Each corresponds to a pre-configured dashboard.
 
1618573802391-750.png
 
 
1618573922196-567.png
 
 
For Excel files, you can select the sheet to work with.
1618574042910-360.png
 
The tool then does a contextual analysis of the file to suggest the most appropriate dashboards.
 

Case n°1 : no pre-configured dashboard has been detected

It is possible that no pre-configured dashboard correpond to the loaded datasource.

In this case, you will only have the possibility to create an automatic or personalized dashboard.

1618574130805-718.png

Selecting the automatic dashboard

The automatic dashboard pre-selects graphics in your dashboard that you can of course enrich afterwards according to different analysis axis explained below.

automatic.gif

Selecting the personalized dashboard

With the personalized dashboard, you are completely free to choose the graphics to create for your dashboard according to the analysis axis explained below.

personalized.gif

Data source edition

It is highy recommended to have knowledge of the way the data is structured and to bring any potentiel corrections.

The button  1618577139021-759.png will allow you to learn more about your source. Wou will be able to vizualize your data and configure them.

Preview of the datasource

The tab "Preview data" allows you to visualize a part of your data to understand it.

1618574717251-226.png

Options exist so you can form your data in better ways.

These are different according to the type of the imported source. For example, you can choose the sheet only for an Excel file.

Configuration of the datamodel

The datamodel is an "interlligent" representation of a data source It is composed of measures and dimensions.

The tab "Configure the datamodel" allows you to configure the measures and dimensions detected by DigDash.

You will be able to modify their type, their diisplay name and event create derivated measures from them.

1618575055439-775.png

 

Changing column types

Digdash automatically detects whether the columns of your source are dimensions or measures.

A dimension is composed of an organized set of members according on or multiple hierarchies.

A measure is a quantity to represent that can be aggregated with a formula.

If you decide than a column is a measure instead of a dmension, or vice versa, you can change its type.

Note that the configuration of the data can have consequences in the contextual analysis of the data and then change it.

Adding derivated measures

The button 1618575124988-446.png allows you to add calculated measures to your datamodel.

A calculated measure or derivated meadure is a measure which definition comes from a formula based or not on other dimensions / measures.

There are different ways to create them. you can use the existing preestablished functions (general or transformers) or define your own formulas.

General functions

1618575190524-652.png

General functions are basic formulas.

Transformers

1618575418755-392.png

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.

Formula
Selecting "Formula..." you will have this following dialog appear :
 
1618575507277-616.png
 
This dialog allows you to freely define the formula to apply to the associated columns.
You will need to enter a name for it.

Graphics choice

Selecting an automatic or personalized dashboard will lead you to a view similar to this one below.

The left part shows the list of graphics to choose for the right part of this interface.

The right part shows the content of the dashboard you want to build.1618576683430-948.png

Dimensions and measures of your datasource are automatically recognized. The user can simply create the graphics from them.

  • 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.
  • 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.
    Three types of analyses exist:
    • Trend analysis: at least one dimension of time has been detected. The line chart is automatically suggested.
    • Geographic analysis: at leat one geographic dimension has been detected. The representation by a map is automatically suggested.
    • List: one or multiple dimensions have been detected. The table representation is automatically suggested.

If you choose to have an automatic dashboard, dimensions et measures are pre-selected and graphics are automatically selected for the dashboard.

If you choose an personalized dashboard, you can select the dimensions and measures yourself for each analysis.

Click on 1602843729099-538.png  to add the graphic to the dashboard.

Case n°2 : pre-configured dashboards have been detected

DigDash can detect if a pre-configured dashboard matches to your datasource.
 
You can then select this pre-made dashboard with pre-configured and pre-selected graphics or choose to create an automatic or personalized dashboard.
 

Selecting a pre-configured dashboard

In your example, the source file retail_v7_de_world.xls matches the "Retail" dashboard.

retail.gif

When selecting it, the dashboard will be composed of graphics dealing with Retail (Sales, Turnover, etc.).
 

Graphics choice

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.

The pre-configured graphics associated to the selected dashboard are directly added to the content of the dashboard to build.

1618576885443-947.png

Moreover, you can enrich the content of your dashboard adding your own graphics.

1618576982169-684.png

Dashboard construction

You have mutiple options to handle the vizualisation of your dashbord.

Dashboard name

Give a name to you dashboard. It is mandatory.

Indded, it will be used as the name of a category in the wallet.

A wallet is a work space which rights are given according to each user.

Graphics arrangement

DigDash offers multiple layouts to conviniently arrange your graphics in your dashboard. The default layout is the automatic one.

1602856226445-298.png

The automatic layout automatically arranges your content adjusting it at its best, without any graphics limation.

Each layout has a maximum of graphics capacity, you can know it hovering it.

1618576556792-934.png

Drag and drop the graphics of your dashboard to order them. The first is the most important..

1618576621291-327.png

Validate and finish the dashboard construction

Click on the button 1618577093224-824.png to terminbate the dashoard construction.

Wait a few seconds.

The assistant will close eventually and your final dashboard will be dsisplayed in the Editor.

If you wish, you can enrich it in the Dashboards Editor.

Datamodel edition

A datamodel issued from this assistant can be modified afterwards. You can add more derivated measures for example if you need to.

1618577825471-465.png

To access the edition interface, you have two possibilities:

- Click on the wheel on a graphic and select the menu "Edit the datamodel.

1618577862402-653.png

1618577880079-750.png

- via the button "Edit" when creating new graphics using a datamodel.

1618577918061-878.png