Difference between revisions of "Create your own custom dashboards"

From Datonis
Jump to: navigation, search
m (Updated the video links. Earlier links were broken.)
 
(9 intermediate revisions by 2 users not shown)
Line 7: Line 7:
  
 
A page showing Dashboards will come up. These are all the dashboards that are already created on this account.
 
A page showing Dashboards will come up. These are all the dashboards that are already created on this account.
 +
 +
Here is a video on accessing the tool from the Datonis BI link or from Datonis MInt.
 +
 +
{{#ev:youtube|https://youtu.be/B3sAUJkVmw4}}
  
 
'''Note –''' The account used in this manual is our sales demo account which already has some dashboards created. If you are a new user, the list will be blank.
 
'''Note –''' The account used in this manual is our sales demo account which already has some dashboards created. If you are a new user, the list will be blank.
Line 12: Line 16:
 
== Basic Concepts ==
 
== Basic Concepts ==
  
 +
=== Charts and Dashboards ===
 
There are 2 elements to remember while creating a Dashboard in Datonis BI:
 
There are 2 elements to remember while creating a Dashboard in Datonis BI:
 
# '''Charts''' – A chart is a visualisation element (e.g. bar chart, pivot table, pie chart, filter box).
 
# '''Charts''' – A chart is a visualisation element (e.g. bar chart, pivot table, pie chart, filter box).
Line 17: Line 22:
 
The workflow to create a dashboard is as follows:
 
The workflow to create a dashboard is as follows:
  
 +
=== Dashboard creation flow ===
 
[[File:Steps to create Dashboard.png|498x498px]]
 
[[File:Steps to create Dashboard.png|498x498px]]
 +
  
 
== Creating a Chart ==
 
== Creating a Chart ==
Click on the 'Charts' Tab at the top left of the screen.
 
 
[[File:Create a chart.png|600x600px]]
 
 
Similar to the Dashboard page, a page showing the list of charts is shown.
 
 
To create a new chart, click on the (+) sign on the top right or click on '+ New' button on the page and select Chart.
 
 
[[File:Create a new chart.png|600x600px]]
 
 
A new page showing the chart configuration will be shown. The next step is to choose the [[Analytics Data Model|data source]] and visualisation type.
 
 
In the ‘Choose a datasource’ drop down, the user will be able to see all the datasources available in his/her account.
 
 
In the ‘visualisation type’ the user can select a chart from a vast variety of chart types.
 
 
[[File:Create a chart page.png|600x600px]]
 
  
 
=== Chart Types ===
 
=== Chart Types ===
Altizon BI has a rich set of data visualisation components. Some of them are explained below.
+
Datonis BI has a rich set of data visualisation components. Some of them are explained below.
 
# '''Line Chart''' - A line chart displays information as a series of data points connected by a line. This chart can be used to plot a quantity that varies over a time range. E.g. The trend of energy consumption over a period of a week.
 
# '''Line Chart''' - A line chart displays information as a series of data points connected by a line. This chart can be used to plot a quantity that varies over a time range. E.g. The trend of energy consumption over a period of a week.
 
# '''Dual Line Chart''' - A dual-axis line chart uses two axes to display the relationship of two differently scaled components. E.g. The trend of Production and Rejection quantity.
 
# '''Dual Line Chart''' - A dual-axis line chart uses two axes to display the relationship of two differently scaled components. E.g. The trend of Production and Rejection quantity.
Line 54: Line 44:
 
# '''and others...'''
 
# '''and others...'''
  
 +
=== Steps for creating a chart ===
 +
Click on the 'Charts' Tab at the top left of the screen.
 +
 +
[[File:Create a chart.png|600x600px]]
 +
 +
 +
Similar to the Dashboard page, a page showing the list of charts is shown.
 +
To create a new chart, click on the (+) sign on the top right or click on '+ New' button on the page and select Chart.
 +
 +
[[File:Create a new chart.png|600x600px]]
 +
 +
 +
A new page showing the chart configuration will be shown. The next step is to choose the [[Analytics Data Model|data source]] and visualisation type.
 +
In the ‘Choose a datasource’ drop down, the user will be able to see all the datasources available in his/her account.
 +
In the ‘visualisation type’ the user can select a chart from a vast variety of chart types.
 +
 +
[[File:Create a chart page.png|600x600px]]
 +
 +
=== Example video for creating a chart ===
 
Here is an example video of how you can create a chart.
 
Here is an example video of how you can create a chart.
  
{{#ev:youtube|https://youtu.be/k3nuNbrJLL8}}
+
{{#ev:youtube|https://youtu.be/U9ME9SCGcTM}}
 +
 
 +
=== Chart creation example ===
  
 
The below shows a step-by-step way to create a chart.
 
The below shows a step-by-step way to create a chart.
Line 63: Line 74:
  
 
[[File:Create a chart page.png|600x600px]]
 
[[File:Create a chart page.png|600x600px]]
 +
  
 
A new page with two sections will open. The section on the left is the chart type configuration and the section on the right is the chart data rendering section (marked in Red and Blue respectively).
 
A new page with two sections will open. The section on the left is the chart type configuration and the section on the right is the chart data rendering section (marked in Red and Blue respectively).
  
 
[[File:Chart page options.png|600x600px]]
 
[[File:Chart page options.png|600x600px]]
 +
  
 
The left section is used to configure the settings like Time column, Metrics, Series etc. which are dependent on the visualisation type the user chooses.
 
The left section is used to configure the settings like Time column, Metrics, Series etc. which are dependent on the visualisation type the user chooses.
Line 81: Line 94:
 
Some of the features are explained in the example below.
 
Some of the features are explained in the example below.
  
'''1.'''    Let us say, we want to create a chart showing average OEE by Workcenters.
+
==== Create a chart showing average OEE by Workcenters ====
  
 
In this case, the configurations will be Metrics: OEE, Series: Workcenter
 
In this case, the configurations will be Metrics: OEE, Series: Workcenter
Line 88: Line 101:
  
 
[[File:Chart page options - aggregate functions.png|600x600px]]
 
[[File:Chart page options - aggregate functions.png|600x600px]]
 +
  
 
When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.
 
When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.
Line 94: Line 108:
  
  
'''2.'''    Let us say, you want to segregate the average OEE by Shift to identify which Shift contributed to what OEE percent? Also, we need bar values and stacked bars.
+
==== Segregate the average OEE by Shift ====
 +
 
 +
Let us say, you want to identify which Shift contributed to what OEE percent? Also, we want to use bar values and stacked bars.
  
 
In this case, the configurations will be Metrics: OEE, Series: Workcenter, Breakdowns: Shift Name
 
In this case, the configurations will be Metrics: OEE, Series: Workcenter, Breakdowns: Shift Name
 +
  
 
When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.
 
When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.
  
 
[[File:Changing some configuration of the chart.png|600x600px]]
 
[[File:Changing some configuration of the chart.png|600x600px]]
 +
  
 
This completes the first requirement of Avg OEE by Workcenter and Shift. The second requirement is more of a look-and-feel change which can be done using the 'Customize' tab.
 
This completes the first requirement of Avg OEE by Workcenter and Shift. The second requirement is more of a look-and-feel change which can be done using the 'Customize' tab.
Line 109: Line 127:
  
 
'''Note -''' Each visualisation type will have different Data and Customize selections.
 
'''Note -''' Each visualisation type will have different Data and Customize selections.
 +
  
 
Once you are satisfied with the chart and its look and feel, the chart needs to be saved by clicking on the 'Save' button on the top left side of the screen.
 
Once you are satisfied with the chart and its look and feel, the chart needs to be saved by clicking on the 'Save' button on the top left side of the screen.
  
 
Once you click on the Save button, a popup will be shown. The chart needs to be given a name by which it will be visible on the Dashboard.
 
Once you click on the Save button, a popup will be shown. The chart needs to be given a name by which it will be visible on the Dashboard.
 +
  
 
There are 2 ways to add a Chart to a Dashboard.
 
There are 2 ways to add a Chart to a Dashboard.
Line 121: Line 141:
  
 
[[File:Saving a chart.png|600x600px]]
 
[[File:Saving a chart.png|600x600px]]
 +
  
 
Once you save the dashboard, it will be visible as a row in the Charts page list.
 
Once you save the dashboard, it will be visible as a row in the Charts page list.
  
 
[[File:Chart List.png|600x600px]]
 
[[File:Chart List.png|600x600px]]
 +
  
 
If you select 'Add to new Dashboard', a dashboard will also be created, and this chart will be added in the newly created dashboard.
 
If you select 'Add to new Dashboard', a dashboard will also be created, and this chart will be added in the newly created dashboard.
Line 130: Line 152:
  
 
== Creating a Dashboard ==
 
== Creating a Dashboard ==
Here is an example video of how you can create a dashboard.
 
 
{{#ev:youtube|https://youtu.be/dxU1pTMXG8A}}
 
 
  
The below shows a step-by-step way to create a dashboard.
+
=== Steps for creating a Dashboard ===
 +
Please read below for a step-by-step way to create a dashboard.
  
 
Click on the 'Dashboards' Tab at the top left of the screen.
 
Click on the 'Dashboards' Tab at the top left of the screen.
Line 146: Line 165:
  
 
[[File:Dashboard List.png|600x600px]]
 
[[File:Dashboard List.png|600x600px]]
 +
  
 
Click on the Dashboard name to access the dashboard.
 
Click on the Dashboard name to access the dashboard.
  
 
[[File:Open the created Dashboard.png|600x600px]]
 
[[File:Open the created Dashboard.png|600x600px]]
 +
  
 
You can see that a blank dashboard has been created. Now we need to add our created chart into this Dashboard. To do this, click on ‘Edit dashboard’ button on the top right of the screen.
 
You can see that a blank dashboard has been created. Now we need to add our created chart into this Dashboard. To do this, click on ‘Edit dashboard’ button on the top right of the screen.
Line 156: Line 177:
  
 
[[File:Insert Components Tab.png|600x600px]]
 
[[File:Insert Components Tab.png|600x600px]]
 +
  
 
This will list all the charts that have been created using this account.
 
This will list all the charts that have been created using this account.
  
 
[[File:Chart List in components tab.png|600x600px]]
 
[[File:Chart List in components tab.png|600x600px]]
 +
  
 
Select the chart we created and drag it to the blank screen.
 
Select the chart we created and drag it to the blank screen.
  
 
[[File:Adding a chart to the dashboard.png|600x600px]]
 
[[File:Adding a chart to the dashboard.png|600x600px]]
 +
  
 
This will add the chart to the dashboard. You can resize the chart by using the arrow at the bottom right of the chart.  
 
This will add the chart to the dashboard. You can resize the chart by using the arrow at the bottom right of the chart.  
  
 
[[File:Resizing the chart.png|600x600px]]  
 
[[File:Resizing the chart.png|600x600px]]  
 +
  
 
Once you are satisfied with the layout, click on ‘Save changes’ and the dashboard will be ready.
 
Once you are satisfied with the layout, click on ‘Save changes’ and the dashboard will be ready.
  
 
[[File:Final Dashboard.png|600x600px]]
 
[[File:Final Dashboard.png|600x600px]]
 +
 +
=== Example video for creating a dashboard ===
 +
Here is an example video of how you can create a dashboard.
 +
 +
{{#ev:youtube|https://youtu.be/boDpU3N4MjA}}
  
 
== Adding a Filter ==
 
== Adding a Filter ==
Line 178: Line 208:
 
Similar to any other chart, the chart to use here is 'Filter Box'. Rest of the steps for adding it to the dashboard are the same as mentioned in the 'Creating a Chart' section.
 
Similar to any other chart, the chart to use here is 'Filter Box'. Rest of the steps for adding it to the dashboard are the same as mentioned in the 'Creating a Chart' section.
  
 +
=== Example video for adding a filter ===
 
Here is an example video of how you can create a filter.
 
Here is an example video of how you can create a filter.
  
{{#ev:youtube|https://youtu.be/fFWRQGXfsMQ}}
+
{{#ev:youtube|https://youtu.be/Sgv_Ktcrs_4}}
  
 
== Publishing a Dashboard ==
 
== Publishing a Dashboard ==
 
Once you create a dashboard, for other users to view the dashboard it needs to be published. To do that, go to the Dashboard tab and click on the 'Edit Record' button on the actions tab. Scroll down to the selection of 'Published'. Tick the Published checkbox and save your changes.
 
Once you create a dashboard, for other users to view the dashboard it needs to be published. To do that, go to the Dashboard tab and click on the 'Edit Record' button on the actions tab. Scroll down to the selection of 'Published'. Tick the Published checkbox and save your changes.
  
 +
=== Example video for publishing a dashboard ===
 
Here is an example video of how you can publish a Dashboard.
 
Here is an example video of how you can publish a Dashboard.
  
{{#ev:youtube|https://youtu.be/DOb6dsaPfBA}}
+
{{#ev:youtube|https://youtu.be/-Ib7BJHrJLI}}
  
 
== Customizing the look and feel ==
 
== Customizing the look and feel ==
Line 202: Line 234:
 
'''Note -''' Each chart will have its own Customize options. Not all charts will have all the customisations listed above.
 
'''Note -''' Each chart will have its own Customize options. Not all charts will have all the customisations listed above.
  
 +
=== Example video for customising look-and-feel ===
 
Here is an example video of how you can customise the look and feel of a chart.
 
Here is an example video of how you can customise the look and feel of a chart.
  
{{#ev:youtube|https://youtu.be/V5RGvZywKtU}}
+
{{#ev:youtube|https://youtu.be/AnS6fpDhX8s}}
 +
 
 +
== Advanced Features ==
 +
 
 +
=== SQL Lab ===
 +
For advanced users, the tool supports an SQL Lab functionality. Using this functionality the users can create custom tables based on existing tables by using SQL code. For more details, please visit the [[SQL Lab]] page.

Latest revision as of 05:06, 5 February 2021

Getting started with Datonis BI

The tool can be accessed by logging into the following link: https://bi.datonis.io/

The same Datonis MInt credentials can be used to log into the tool. If you have already logged into Datonis MInt, the tool will automatically load by visiting the above-mentioned link.

Altizon BI Homepage.png

A page showing Dashboards will come up. These are all the dashboards that are already created on this account.

Here is a video on accessing the tool from the Datonis BI link or from Datonis MInt.

Note – The account used in this manual is our sales demo account which already has some dashboards created. If you are a new user, the list will be blank.

Basic Concepts

Charts and Dashboards

There are 2 elements to remember while creating a Dashboard in Datonis BI:

  1. Charts – A chart is a visualisation element (e.g. bar chart, pivot table, pie chart, filter box).
  2. Dashboards – Dashboard is a collection of one or many charts which together provide some business value.

The workflow to create a dashboard is as follows:

Dashboard creation flow

Steps to create Dashboard.png


Creating a Chart

Chart Types

Datonis BI has a rich set of data visualisation components. Some of them are explained below.

  1. Line Chart - A line chart displays information as a series of data points connected by a line. This chart can be used to plot a quantity that varies over a time range. E.g. The trend of energy consumption over a period of a week.
  2. Dual Line Chart - A dual-axis line chart uses two axes to display the relationship of two differently scaled components. E.g. The trend of Production and Rejection quantity.
  3. Table - A table lets you select the data from a set of components and displays in a tabular form.
  4. Pivot Table - A pivot table allows you to summarise your data easily. This chart helps you to answer your questions with minimal effort.
  5. Bar Chart - A bar/ column chart displays categorical information with vertical bars showing the value of the categorical component.
  6. Time Series Bar Chart - Similar to a bar chart, this displays categorical information with it's value over a time range.
  7. Pie Chart - A pie chart is used to show relative sizes of data.
  8. Histogram - A histogram shows the shape and spread of the data being visualized.
  9. Treemap- A treemap shows categorical component magnitude as a colour difference. E.g. Part Cycle Time Ratio - The values <=1 show a GREEN color while the values >1 show RED; meaning that the Cycle Times falling in RED are taking more time the standard cycle times.
  10. Big Number - This chart just shows a component value. E.g. to monitor the total number of alerts generated for the selected duration.
  11. Box Plot - The box plot shows the distribution of data using 5 metrics ( min, first quartile, median, third quartile, and max).
  12. Bubble Chart - Bubble/ Scatter chart plots a series of data points to see if there is any correlation between 2 components.
  13. and others...

Steps for creating a chart

Click on the 'Charts' Tab at the top left of the screen.

Create a chart.png


Similar to the Dashboard page, a page showing the list of charts is shown. To create a new chart, click on the (+) sign on the top right or click on '+ New' button on the page and select Chart.

Create a new chart.png


A new page showing the chart configuration will be shown. The next step is to choose the data source and visualisation type. In the ‘Choose a datasource’ drop down, the user will be able to see all the datasources available in his/her account. In the ‘visualisation type’ the user can select a chart from a vast variety of chart types.

Create a chart page.png

Example video for creating a chart

Here is an example video of how you can create a chart.

Chart creation example

The below shows a step-by-step way to create a chart.

Clicking on the ‘Table’ button (default selection of Table) will pop up a screen showing all the supported visualisations. The user will have to select one and then click on ‘Create New Chart’.

Create a chart page.png


A new page with two sections will open. The section on the left is the chart type configuration and the section on the right is the chart data rendering section (marked in Red and Blue respectively).

Chart page options.png


The left section is used to configure the settings like Time column, Metrics, Series etc. which are dependent on the visualisation type the user chooses.

The example shown in this case is for a Bar Chart. The bar chart will have a Categorical variable on the X- axis and a Numeric variable on the Y-axis.

On top of the left section, there are 2 tabs:

1.    Data - This tab contains the configuration related to the data being viewed in the chart.

2.    Customise - This tab contains the look and feel settings for the selected visualisation type.


Some of the features are explained in the example below.

Create a chart showing average OEE by Workcenters

In this case, the configurations will be Metrics: OEE, Series: Workcenter

Note – In metrics, you will need to provide an aggregation function amongst the list already provided. Check below image for more details.

Chart page options - aggregate functions.png


When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.

Rendering the chart.png


Segregate the average OEE by Shift

Let us say, you want to identify which Shift contributed to what OEE percent? Also, we want to use bar values and stacked bars.

In this case, the configurations will be Metrics: OEE, Series: Workcenter, Breakdowns: Shift Name


When you select the configuration, click on 'Run Query' button on the top left for the chart to render in the right section.

Changing some configuration of the chart.png


This completes the first requirement of Avg OEE by Workcenter and Shift. The second requirement is more of a look-and-feel change which can be done using the 'Customize' tab.

In Customize tab, we need to tick options: Bar Values and Stacked Bars. The final output looks like this:

Rendering the chart with changes in the configuration section.png

Note - Each visualisation type will have different Data and Customize selections.


Once you are satisfied with the chart and its look and feel, the chart needs to be saved by clicking on the 'Save' button on the top left side of the screen.

Once you click on the Save button, a popup will be shown. The chart needs to be given a name by which it will be visible on the Dashboard.


There are 2 ways to add a Chart to a Dashboard.

1.    Directly from the Save menu saying, ‘Add chart to existing dashboard’ or ‘Add to new dashboard.’

2.    Create a dashboard from the Dashboards page, open the dashboard and then add a Chart to it.

Saving a chart.png


Once you save the dashboard, it will be visible as a row in the Charts page list.

Chart List.png


If you select 'Add to new Dashboard', a dashboard will also be created, and this chart will be added in the newly created dashboard.


Creating a Dashboard

Steps for creating a Dashboard

Please read below for a step-by-step way to create a dashboard.

Click on the 'Dashboards' Tab at the top left of the screen.

To create a new dashboard, click on the (+) sign on the top right or click on '+ New' button on the page and select Chart.

A configuration page will open. On this page, the user has to enter the Title, Owners (if multiple people need to edit the dashboard) and select/unselect 'Published' checkbox and then click on 'Save'. By selecting Published checkbox, all users having access to the underlying data source can view the dashboard.

The dashboard will be visible as a row in the Dashboards page list.

Dashboard List.png


Click on the Dashboard name to access the dashboard.

Open the created Dashboard.png


You can see that a blank dashboard has been created. Now we need to add our created chart into this Dashboard. To do this, click on ‘Edit dashboard’ button on the top right of the screen.

This will open an 'Insert Components' tab in which you need to select your charts and filters.

Insert Components Tab.png


This will list all the charts that have been created using this account.

Chart List in components tab.png


Select the chart we created and drag it to the blank screen.

Adding a chart to the dashboard.png


This will add the chart to the dashboard. You can resize the chart by using the arrow at the bottom right of the chart.

Resizing the chart.png


Once you are satisfied with the layout, click on ‘Save changes’ and the dashboard will be ready.

Final Dashboard.png

Example video for creating a dashboard

Here is an example video of how you can create a dashboard.

Adding a Filter

A filter is a chart type that is used to narrow down the data selection based on user selection. E.g. Shift Filter can be used to specify which shifts to consider, Workcenter Filter specifies which workcenters' data to consider etc.

Similar to any other chart, the chart to use here is 'Filter Box'. Rest of the steps for adding it to the dashboard are the same as mentioned in the 'Creating a Chart' section.

Example video for adding a filter

Here is an example video of how you can create a filter.

Publishing a Dashboard

Once you create a dashboard, for other users to view the dashboard it needs to be published. To do that, go to the Dashboard tab and click on the 'Edit Record' button on the actions tab. Scroll down to the selection of 'Published'. Tick the Published checkbox and save your changes.

Example video for publishing a dashboard

Here is an example video of how you can publish a Dashboard.

Customizing the look and feel

For all of the chart types as mentioned above, there is a 'Customize' Tab in each of the charts. This tab is used to customize the look and feel of the chart.

Some of the customizations include:

  • Changing the color scheme
  • Sorting the data by a column
  • Adding Data Labels
  • Changing the X/Y Axis labels
  • Changing the X/Y Axis Data Formats
  • Filtering the data by a condition

Note - Each chart will have its own Customize options. Not all charts will have all the customisations listed above.

Example video for customising look-and-feel

Here is an example video of how you can customise the look and feel of a chart.

Advanced Features

SQL Lab

For advanced users, the tool supports an SQL Lab functionality. Using this functionality the users can create custom tables based on existing tables by using SQL code. For more details, please visit the SQL Lab page.