Knowage – Monitor data with Cockpit

In this Blog article, that follows the one on Knowage Query by Example, we will see how to use Knowage to create Cockpits to monitor data trends. We will create an example where, starting from resident population data, it will be possible to see the evolution of this value by year for a specific city. Clearly this example can be translated into other areas, for example those connected to business metrics.

Fig.1 Knowage Cockpit to monitor resident population for city and year

First of all we need a Data Set, with the information of interest. We can create one from Data Providers – Data Set Menu (Fig.2).

Fig. 2 – Data Set creation

 From Data Set definition interface, using pencil icon, it’s then necessary to define if a field is an Attribute or a Measure (Fig.3).

Fig. 3 Field metadata definition

For user profilation purposes, it’s useful to define a specific Category for the Data Set (in this example Dati_Italia). This can be done from Server Settings – Domain Management Menu (Fig.4).

Fig. 4 New Category type definition

Once defined, the category can be added to a specific role using Profile Management – Roles Management Menu (Fig.5)

Fig. 5 Category association to a role

From Data Set interface, selecting TYPE Tab, it’s possible to define data set features (Fig.6) and have a preview of the Data Set created (Fig.7).

Fig.6 Data Set features definition

Fig.7 Data Set preview

Now, logging to Knowage like a user, in the Analysis area under the Workspace menu item, it’s possible to click on the Create Analysis icon and choose Cockpits.

This will open a blank page that can be edited using tools available in the sandwich icon menu.

Fig.8 Cockpit menu

The Add Widget icon opens the interface in Fig. 9 where it’s possible to choose the elements to add to the cockpit.

Fig.9 Cockpit widget

In our example we will add a table and a chart. In Fig. 10 you can see the interface to configure the Table Widget. This is made by 4 tabs where it’s possible to define colums, style, cross navigation and filters behavior.

Fig.10 Table widget configuration interface

In Fig.11 you can see the interface to configure the chart widget. This is made by 5 tabs where it’s possible to configure Dataset, design Chart with a specific engine, and define style, cross navigation and filters behaviour.

Fig.11 Chart widget configuration interface

The Chart Engine Designer allows to choose chart style (Fig.11), Chart structure (Fig.12) made by Categories  (x axis) and Series (y axis). Note that for Categories you have to choose an attribute, while for Series a measure (Fig.3).

Fig.12 Chart widget configuration interface

In Fig.13 you can see the result of the above steps: a table containing all the records selected from the dataset and a chart representing by year the sum of the measure called “Dato”

Fig.13 Cockpit resulting from the above configuration

One interesting Knowage function is the one represented in Fig.14 where, choosing a city and double clicking on “Territorio” column, table data are filtered for this attribute and chart content is consequently updated.

Fig.14 Cockpit resulting once selected a city

City selection can be modified from selection list widget (Fig.15).

Fig.15 Selection list widget