In this AIKnow.info 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.
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).
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).
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).
Once defined, the category can be added to a specific role using Profile Management – Roles Management Menu (Fig.5)
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).
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.
The Add Widget icon opens the interface in Fig. 9 where it’s possible to choose the elements to add to the cockpit.
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.
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.
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).
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”
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.
City selection can be modified from selection list widget (Fig.15).