STDashboard is an open source tool developed by StrateBI for the definition of scorecards.
Its objective is to allow the end user to interactively create a scorecard of sencillay quickly, efficiently, without the need for additional knowledge (programming, design, knowledge of the organization's business).
You can also choose predefined templates.
STDashboard users will find a set of features, among which we highlight:
TYPES OF GRAPHICS
Useful when representing weights of a set of elements. The Pie chart allows you to display the members or elements of a dimension by a circle divided into sections, each of which represents the proportion of the individual element to the total. In this type of graphs only a single indicator is allowed to be selected, and it does not allow to set parameters for an advanced configuration.
An additional functionality provided by this chart is the ability to perform the drill-down operation. A dimension or perspective of analysis is a set of data organized in the form of levels that form a hierarchy. A typical example of dimension is the TIME dimension, present in any data model. The structure of a TIME dimension could be:
This dimension has three levels (YEAR, MONTH, DAY), where each one has elements denominated MEMBERS. For example, the members of the MES level will be the month list of the year, and the members of the DAY level will be the days of the month to which they belong.
In this way, the operation of visualizing the days belonging to a given month, is a drill-down operation, that is, show the members of the next level of the hierarchy.
As has been said, this type of graphics allows performing drill-down operations or expansion of a hierarchy. Based on the generated data model, the MARKETS dimension has the following hierarchical structure:
If you select this dimension in the initial dialog, you will get a graph where the chosen indicator is represented according to the first level of the hierarchy (MARKET).
If you then click on one of the sections of the graph representing the different territories, the graph will reload to show the list of territories belonging to that level. This operation can be executed recursively until reaching the lower level of the hierarchy.
For example, selecting the "Quantity" indicator and the "Markets" analysis perspective, the result is as follows:
In this type of chart, the dimension is assigned to the Y axis, in the case of bar graphs, and to the X axis in case of choosing the column type chart. Represents the members or elements of the dimension or dimensions selected as bars or columns according to the selection. In this type of graphs it is possible to select multiple indicators.
This type of graphics does support advanced configurations. By selecting the "Advanced" tab you can choose the color used to display each of the series on the chart. An example:
The value of the chosen dimension is represented on the X axis and the value or values of the desired indicators on the vertical Y axis. These types of graphs are especially useful for the representation of temporal evolutions. Line graphs support the selection of multiple metrics or metrics, and also allow advanced configuration. If several indicators are chosen for the representation, a series of data will be drawn for each of them.
This type of chart has the same drill-down functionality and tooltips explained in the "Pie" chart section.
To represent the value of a single indicator, using as a reference some thresholds determined in a personalized way. The generated graph will show an image in the form of a speedometer, with semaphore sections that facilitate the rapid evaluation of the results.
In this graphic the 'advanced configuration' is different from any other graphic. In this graph you have to define thresholds in a consistent way. For example, if our minimum value is 1 and the maximum 100,000, we must choose thresholds with scale, otherwise, the visualization will not have the desired utility between the 'bad' and 'regular' or 'regular' and 'good'.
This type of chart does not have the drill-down or tooltips features.
Its operation is like that of the type Bar.
If two or more measures are selected, they will be displayed in the same graph. In the 'Advanced' tab, you can select if you want it to show them as: Bars, Lines or Areas.
It has the same functionality and utility reflected in the graphs of type "Line", with the difference that in this particular case the lower zone of the series represented is shaded. With this type of graphs it is easier to appreciate the differences and separations between pairs of series. If the series are similar, or converge at some point, the points overlap and information may be lost.
A tabular data table is generated, without graphical representations, containing the selected data in the initial dialog box. In the rows the members of the selected dimension will be listed, and as many columns as the number of flags will be displayed.
After creating a graphic element will be displayed in the upper right of the corresponding section a toolbar, which offers a series of functionalities for manipulation and editing of the generated element.
The features provided only affect the element contained within the section, and are as follows:
Here is the information shown:
Function that allows an increase of the graph. Sometimes the data generated exceeds the size of the corresponding section, or the values appear agglomerated if the selected dimension has many members. In these cases, this option is very useful for a more comfortable and effective analysis. In the "Zoom" mode the drill-down functions are not enabled.
Any of the graphs built can be displayed in tabular form. With as char you can do a visual analysis. However, if you need to check a specific data in a more agile, this functionality has been enabled. The display works in a similar way to the "Table" element explained in previous sections.
In the rows the members of the chosen dimension are displayed, and in the columns the values of the selected indicators. This special visualization offers the possibilities of the element, sorting and pagination, but it is not possible to perform drill-down operations by clicking on the rows.
Clicking on the edit icon will display the dialog box for editing the graphic component defined in the section. The loaded dialog box will contain the previously selected values for the chart. The edition is free, allowing to modify all the characteristics previously defined, without affecting the rest of elements of the control panel.
Option visible in the different sections of the dashboard, only when a drill-down operation has been performed on one of the members of the dimension. When a dimension has been expanded by clicking on a chart, or on a row in a table, this option is enabled. By clicking on the button, the element will be reloaded with the elements corresponding to its top level in the dimension, and the title will reflect that change.
To save a dashboard created with STDashboard, it is as simple as clicking the Save icon or 'Save As'
Once you click on the icon of 'Edit filters configuration', the following screen appears:
To use one of the dimensions available as a filter for the dashboard, simply click on the green icon to the right of the name of each item.
After clicking on it, the dimension will move automatically to the section "Used”.
You can only filter by those dimensions that are not being used in the graphs, i.e. those that appear in the "Available" section. You must click on the + icon.
Once the desired filter group is selected, the "Save" button should be pressed. Automatically, the new filters configured will be enabled in the Filters section.
After clicking on the button, a new dialog box will be activated where the different options of configuration of the elements will be presented.
This dialog box consists of three configuration tabs: "Main" and "Advanced" and "External Content". The "Main" tab contains the following characteristics: