4. Dashboards

4.1. Where the Magic Happens

The Dashboard is where the interaction between the user and the data occurs. The operational principle is that there are multiple sources of information represented by different tables. One of the tables must serve as the Primary Table that will anchor all other tables. This can be as either a Primary to Foreign key relationship or a Many-to-Many relationship. How these relationships are constructed are reviewed in the Data Import training module.

The import facts to remember are that data in tables are related by matching items in columns. It must be an exact match. This creates the dynamic functionality of the widgets.

These relationships are outlined below:

Data Table relationships

Data Table Relationships

4.2. Types of Data and Widgets

As was discussed in data importing, data type is an import feature of the data in a table. The type of data controls how NoviLens operates.

The following table displays the most common pairing of data types with their respective widgets:

Widget Matrix

Matrix of Widget and Data type

Here are the points to consider:

  • Bar Graphs can be “Stacked” if the primary X axis value is a record count

  • Dictionaries can have pairs

  • The Select widget provides a rapid method of filtering categorical data.

  • Categorical text can be searched by a dictionary and then used by a dictionary widget

  • you cannot change the legend names, they are “fixed” as the column names in the table

Example:

The following is a data table of Mortality Regarding COVID-19 virus:

Covid Data

There are multiple data types in the table:

  • Date is a timestamp

  • Province, Country, and Type are text

  • Lat and Longitude are floats

  • Value is numeric

Based on the data type, the following widgets can be deployed:

  • Timestamp: Line graph

  • Text: bar graph (if treated as category), dictionary if treated as a dictionary search

  • Lat and Longitude: convert to points for use in Map widget

  • Value: bar graph, scatter plot.

4.3. Bar Widget

The Bar Widget is the workhorse widget in NoviLens, handling a variety of data types and offering a number of configuration options. Starting with the following Data Table, the functionality of this widget will be described.

Insurance Screen Shot

Data Table of Auto Insurance Fields

The first Bar Widget configured is a Binned Bar Widget of the number of counts in the field Customer Lifetime Value.

Binned bar graph widget

Bar Widget of Customer Count vs Value Bins

The X axis is a representation of the numeric data, the bins Ranges were set in the Widget configuration window. The Y axis are the number of counts that meet the binning criteria. Configuration is described in the following video:

The Bar Widget can perform simple mathematical functions on column information such as sum, average, min, max, etc. Configuration of this functionality is highlighted in the following video:

4.4. Stacked Bar Widget

Stacked Bar Graph

Stacked Bar Widget of Customer Value by Gender

In viewing the Stacked Bar Widget, the Y axis represents the record counts. The X axis is the primary X axis of Binned Value, the Stacked X is the categorical data of the Gender. Because the Y value is a count, binning is possible.

4.5. Line Widget

The line widget is used to visualize relationships between temporal data or to show relationships between two sets of data points. In NoviLens, the most common use is to couple the Line Widget with the date widget to perform a filtering function on the fused data set.

Referring back to the COVID-19 data, the following represents a screen shot of a time line widget coupled with the Date Filter widget.]

Covid timeline

COVID TimeLine Widget with Date Filter Widget

The Line Widget has multiple configuration options that can cause some confusion. To review:

  • the X-Axis: there can be multiple lines displayed on the X-Axis by using the

    Multi-Line Mode. If you Split-by…. you can select Multiple X-Axis Fields. Remember that the X-axis between the field will probably differ and provide distinct populations on the graph. You can stack multiple X axis in this manner.

RedWine Line

Line Graph - Selecting Multiple X Fields

  • the alternative Multi-Line: here you split by a selected Field. You only can select one field but can limit the number of rows displayed. In this case, the legend displays the value of the items in the field.

Redwine2

Line Graph - Selecting Split by single field

The timeline widget has multiple configuration options:

  • the timeframe Scale

  • the Y axis variable (follows same “rules”; numeric can make use of math operators)

  • if multiple variables are to be plotted

  • the maximum number of lines to display (prevents “crowded graph”)