Advanced tutorial

Last modified by Aurelie Bertrand on 2023/11/13 16:45


Source file download

In order to be able to carry out this tutorial, you will need to recover two Excel files "telecomen.xls" and "retailen.xls" (click on each file name to download them).

Creation of the “telecom” data model

Objective : Import into DigDash Enterprise the Excel file “telecomen.xls” (downloaded previously) which represents the data of a (fictitious) telecommunications company. Enrich this source to build a data model to create relevant graphs.

This data model will then be used by several graphs.

  • From the home screen, click on Web Studio
  • 1600030302328-951.png
  • In the login box, enter your account information in the Username and Password fields.

In any case, you must use in the login interface the username and password provided by your administrator to log in. This person will be able to help you in the event of a connection problem.

2021-login.png

Step 1 : Import a data source

This tutorial assumes that you are going to import your data sources and create your charts in your personal wallet.

  • In the toolbar at the top of the main window, click on the Sources... button, then All types in the Files section2021R2-Sources-Studio2.png

The Search for Remote Documents box appears:

1652102891300-756.png

  • Click Select at the top of the dialog then choose the “Common Datasources” document server.
  • Click the Add File to Server... button. The Select Local File or URL box will appear.
  • Select Choose a local file and then click Browse to select the "telecomen.xls" file retrieved earlier.

Reminder: The telecomen.xls file can be downloaded by following this link.

1600031148404-257.png

  • Click on OK.

The file is now saved on the DigDash "Common Datasources" server and accessible to all users.

NB: if the UserDocs document server is selected, the documents are only accessible to the user who uploaded them.

  • In the Search for remote documents box, select “telecomen.xls”.

1600031248631-694.png

  • Click on OK

The box Load data from an Excel spreadsheet appears.

2021R2-previsu.png

  • Check the box First row as header.
    1600031668568-919.png
  • Click on the button Add…, to the right of the button Disable empty columns.

The popup Edit filter rule appears : 

2021R2-previsu-date.png

  • Let the default values (Date in the first drop-down list and “is not empty” in the second drop-down list)
  • Click on OK then Next >.

Step 2 : Configure the data model

  • Name the data model “telecom” :

2021R2-modele_telecom.png

Next steps :

Create a manual hierarchy of corporate departments. Create an automatic hierarchy on phone hardware.

Create a communication cost target. Create a calculated measure that varies communication costs based on the €/$ exchange rate.

Creation of a Manual hierarchy

  • Select Departement, then click on Add and choose Manual grouping.
    2021R2-hierarchie-manuelle.png
  • The popup Creating a hierarchy on the dimension 'Department" appears.
    2021R2-hierarchie-manuelle.png
  • The default name of the group is Groupe 0. Rename it to Type of service.
     

A first level named Level 0 contains all the values of the column.

  • Rename this level to Function.
  • To create groups on this level, click on Add… on the bottom left of the popup.

The popup Group name appears.

1600071797076-676.png

  • Type Commercial and do the same with Management, Production and Administration.

Allocation of members to groups :

  • Select Administration then check Purchasing, Legal and IT in the list on the right.
    2021R2-hierarchie-manuelle-liste-groupe-administration.png

Do the same with :

  • Commercial : Marketing and Sales
  • Management : Management, Finance and HR
  • Production : Production and R&D

Add a second level by clicking the "+" button and name it Activity.

Add two groups Main and Support, and add the following members to them:

  • Main : Commercial, Production
  • Support: Management, Administration

1600072199298-363.png

  • Click OK to validate the two-level hierarchy.

Creation of an Automatic grouping

  • Select Phone Hardware then click Add and select Automatic grouping.2021R2-hierarchie-auto.png

The pop-up Group editor appears.

  • The default group name is Group 0, rename it to Hardware Type.2021R2-hierarchie-auto-titre.png

The full path to the hierarchy is displayed on the Complete path line. Each hierarchical level is separated from the next by a /. Phone hardware is the first level of th hierarchy.

  • Open the drop-down list of the second level then select Type of line.2021R2-hierarchie-auto-niveau.png
  • Click OK to validate.

Creation of decreasing communication costs target to 21 000€

  • Select the Communication Cost column and click Add...2021R2-objectif.png
  • Name the target Decreasing cost.
  • In the drop-down list Type of target select Decreasing.
  • In the drop-down list Type select Allocation then type the value 21 000.
    2021R2-objectif-valeurs.png
  • Click OK to validate.

Creation of a Euro / Dollar conversion variable.

  • Click on the Variables tab and then the "+" icon to add a variable2021R2-variables.png

In the variable editing window, fill in the following fields, then click the Apply button:

  • Name: Euro Dollar
  • Default value : 1.4
  • Minimum : 0.6
  • Maximum : 2
  • Increment: 0.01

2021R2-variables-creation2.png

Creation of a measure calculating communication costs based on the Euro/Dollar exchange rate

  • Switch to the "Columns" tab, then click Create calculated measure (advanced)... under the list of columns.2021R2-mesure-calculee.png

The pop-up for editing calculated measures appears.

  • Name the measure Cost Euro Dollar and press Enter.
  • Double click on communication cost within Available measures.
    2021R2-mesure-calculee-euro-dollar.png
  • Type *1.4/ and add the variable created earlier.
    2021R2-mesure-calculee-ajout-variable.png

Our data model is now complete.

  • Click Finish then Ignore the dialog box Add a comment on the modification.
    2021R2-telecom-appliquer.png

The list of data models created in your wallet appears, you can click on the "Flows" panel to go to the next step.

Creation of the graph “Communication cost by Type of service”

Objective : Display a bar graph showing Communication Cost by Service Type. From his dashboard, the user will be able to navigate in the Type of service hierarchy.

  • Click Flows..., then Bar chart on the Compare category.
    2021R2-graph-barres.png
  • Then select the model created previously.2021R2-graph-barres-modele.png
  • Drag and drop the Communication Cost measure onto the Stack axis.
  • Drag and drop the Department dimension onto Bar axis.
  • Select the hierarchy Type of service and the level Activity.
  • Check Add the action “Navigate hierarchies”.

2021R2-graph-barres-config.png

In the Interaction tab ( two twirling arrows icon), you can verify that the Navigate Hierarchies action has been applied.

2021R2-graph-barres-interaction.png

  • Use the “Refresh” button to preview the graph.

The drop-down menu also allows you to enable automatic preview.

2021R2-graph-barres-raffraichissement.png

Main and Support bars can now be clicked to drill-down the manual hierarchy prepared in the data model.

1600102614507-459.png

  • Rename the new chart to Communication Cost by Service.

1600102642116-267.png

  • Click OK to save the chart.

Creating the "Communication Cost by Region" Chart

Objective : Creation of a map showing communication costs by continent. When viewing the dashboard containing this graph, the user can navigate to the continents to view costs by country and then by region.

This graph uses the telecom data model created earlier.

Formation_Niveau_1_Tutoriel_2020R1_FR-_2__html_d51edeef6e19accb.jpg

Step 1: Selecting the chart type and an existing data source

  • In the toolbar at the top of the main window, click Flows then New In the Maps categoryselect Map chart.
    1600116153079-739.png
  • Select the telecom data source previously created.1600116200232-630.png

The pop-up Flow properties appears.

Step 2 : Flow properties

  • Drag and drop the measure Communication cost on the measure axis.
  • Drag and drop the dimension Area on the Geography axis
  • Keep the default hierarchy, then check Add the action "Navigate hierarchies".

config_carte.jpg

  • After refreshing the chart preview, you can click on Europe to view the cost details in that area.
  • Name the chart Communication Cost by Region
  • Click OK to save the visualization.

Creation of the “Cost target” graph

Objective : The company wants to reduce its communication costs. Create a gauge comparing communication costs to a goal.

Formation_Niveau_1_Tutoriel_2020R1_FR-_2__html_9e2b012aaf68747d.jpg

Step 1: Selecting the chart type and an existing data source

This graph uses the telecom data model created earlier.

  • As seen previously, create a Gauge type chart, always using the telecom source.1600117630243-609.png

Step 2 : Flow properties

Formation_Niveau_1_Tutoriel_2020R1_FR-_2__html_35b8406fbe0d1c51.jpg

  • Set the measure Communication cost  in measure axis. The target Decreasing cost should be enabled by default.
  • Rename the chart to Cost target.
  • Click OK to save the visualization and add the graph to your wallet.

Creation of the “Euro Dollar Simulation” chart

Objective : The company wishes to visualize the impact of the variation of the Euro/Dollar exchange rate on its communication costs.

ac81e432d3ac998.jpg

This chart uses the telecom data model.

Step 1: Selecting an existing data source

  • Create a lines graph (in the Compare category) always using the telecom source.
    1600117838009-422.png

Step 2 : Flow properties

  • Drag and drop the measures Communication cost and Euro Dollar on the Line axis.
  • Drag and drop the dimension Date on the Abscissa axis. Edit the hierarchy to Month Year and the level to Year.Check Add the action "Navigate hierarchies".

b683a866f5e99938.jpg

Rename the chart to Euro Dollar Simulation and click OK to save the chart.

Creation of the "retail" data model

Step 1: Import a data source

Objective : Import into DigDash Enterprise the Excel file “retailen.xls” (retrieved earlier) that represents the product sales of a fictitious company.

  • In the left of the window, click on Models, New then Any types in the Files category.
    1600117909123-199.png

The pop-up Search remote files appears :

  • Click Select at the top of the dialog then choose the "Common Datasources" server URL.1600118027406-371.png
  • Click Add a file to the server... The popup Select local file or URL appears.
    1600118289399-143.png
  • Select Choose a local file then click Browse to select the retailen.xls file that you previously downloaded.

Reminder: The retailen.xls file can be downloaded by following this link.

  • Click OK

The file is now saved on the DigDash server and accessible to all users.

  • In the pop-up Search remote files, select retailen.xls then click OK.

1600118581045-776.png

NB: if the UserDocs document server is selected, the documents are only accessible to the user who uploaded them.

The window Load data from an Excel spreadsheet appears.

1600118640524-894.png

Check the box First row as header

1600118756797-755.png

  • Click Add…, to the right of Disable empty columns.
    1600118865065-390.png

The pop-up Edit filter rule appears :

  • Keep the default values (Date on the first drop-down list and is not empty to the second drop-down list)
    1600118896120-639.png
  • Click OK then Next.

Step 2: Configure the data model

  • Name the model “retail”.1600118993918-365.png
  • Click Finish to close the Data model advanced configuration window.

Creation of the graph “ top 3 sales by products”

Objective: Create a cross table showing the sales made on the 3 best products. The trend of sales and the target regarding to the marginare displayed in the table as icons.

61b03ecd54797732.jpg

This chart uses the “retail” data model.

  • Create a cross table graph, then add two columns and drag and drop :
    • Column 1 : Product
    • Column 2 : Sales, Target margin et Trend
    • Line 1 : Area then remove the hierarchy.

1600120768276-313.png

  • Right click on Target margin and apply a format Target (icon). Do the same with Trend with the “Trend (icon)” format.
    1600121501859-223.png

    1600121558656-322.png
  • Click the cog wheel at the top right of "Column 1" and then click Properties...1600121652793-225.png
  • Make a ranking of the 3 best sales (revenue) by product.
  • Apply a descending sort on the sales mesure.
    1600121708655-516.png
  • Name the chart “Top 3 Products sales” and close the visualization setup.

Creation of the dashboard

Return to the DigDash Enterprise home screen, then click on "Dashboard Editor"

1618492515265-387.png

editeur-tdb.png

  • Log in with the same credentials as before.
  • You should see your username at the top of the page, along with a "My Dashboard" page.. Right click on it, then "Display mode" then "Templates.."

04.png

A pop-up appears, select the model "Charts + filters on top" :

04.png

  • Your page now contains areas where you can drag graphics or filters. Drag and drop the following charts into the “My Dashboard” page:
    • Communication cost by service
    • Communication cost by region
    • Cost target
    • Top 3 Products sales
  • To do this, in the left side menu, select Information flow (Existing Graphics) then drag and drop the graphs related into the zones "Drag and drop chart" of your page.

06.png

To add filters on the page, select the "Filters / Variables" side menu, then drag and drop Type of line in a template named "Dimension"

06.png

  • Click on the “+” icon to the right of My Dashboard to create a Simulation page.
  • Select the Proportional (%) page mode
  • From the left side panel click Information flow (Existing Graphics), drag and drop the Simulation Euro Dollar chart into the new page.
  • From the Filters/Variables tab add the Euro Dollar variable.
  • Do the same with Type of line.

Formation_Niveau_1_Tutoriel_2020R1_FR-_2__html_69592df1b663b635.jpg

Save the dashboard by clicking on the floppy icon located at the top right of the window.

Dashboard display

  • Click the gauge icon in the top right to access the dashboard.

2022R1-editeur_3.png

You can now manipulate your dashboard by clicking on charts, filters, or changing pages.