Bipp allows creation and management of multiple dashboards or insight boards that can be used to group and present one or many Bipp sheets. They also allow filtering of data across multiple sheets and embedded dashboards and drilldown of specific data points to view details.
Dashboards may be created, edited or viewed from the dashboard management screen which can be accessed from the “Dashboards” option in the application menu. This screen also provides options to export, import, share, search and delete dashboards.
You can create a new dashboard, by clicking the “New dashboard” button available at the top-right of the screen. You will be requested to enter the dashboard name. You can also mark the dashboard as secondary if it is intended for use inside another dashboard.
A new dashboard would be created on click of the “Create” button. You can now add content to this dashboard using the visual editor for the dashboard as shown.
The dashboard can be viewed by saving the model created. The following image shows a basic dashboard created by including one sheet that visualizes data in a map format.
Let us now look at the other functionality available that enables optimal efficiency of dashboards.
Enhancing a Dashboard
Dashboards can be edited to include advanced filtering and drill down functionality. Following are the two ways in which dashboards may be edited.
Editing the Ding Model
Dashboards may be edited by clicking on the “Edit” link in the Dashboard options menu. This will open the Ding file for the selected dashboard in edit mode. Ding syntax corresponding to the selected sheets and dashboards will be available in the Ding model file. This may be edited depending on the requirements for the dashboard. For more information on using Ding to edit the dashboard, refer to the Ding Specification.
Using the WYSIWYG editor
Dashboards may be edited using the visual editor. This supports add, edit, delete, resize, rearrange functionalities for tiles, sheets, filters, embedded dashboards and channels. The changes made in the visual editor are updated to the the Ding model file for the dashboard. Click here for a detailed walkthrough on using the editor.
Dashboard Version Control
You can both save or commit dashboards after editing them. When a dashboard model is committed in Bipp, it does not overwrite the previous version of the dashboard. Instead a new version of the dashboard is created with alias “latest”. At any point of time you may revert to a previous version of the dashboard by using the “Version” dropdown. The required version may be selected from the version dialog box.
Bipp allows both online and offline sharing of dashboards. Following are the ways in which dashboards or dashboard data may be shared with other Bipp users or external stakeholders.
Access Permissions: A dashboard may be shared with other Bipp users in the organization/user-network by using the “Permissions” menu option on the dashboard listing screen or the “Share” button on the dashboard screen. This will show the permissions dialog box. Dashboards may be shared with co-workers by entering their email-id’s on this screen.
Export/Import: Dashboards may be exported to a
tarfile using the “Export” option in the dashboard menu. Only users with admin or creator permissions on the dashboard will be allowed to export it.
This file can then be imported by other users into their workspace. This can be achieved by using the “Import Dashboard” button on the top-right of the dashboard listing screen.
The tar file contains not only the definition of the dashboard but also the definition of the associated datasource, projects, sheets and all committed versions of the dashboard. This means all of these will be created when the dashboard is imported.
Export PDF: A snapshot of the dashboard visible on screen may be exported to PDF format by clicking on the “Export PDF” icon on the top-right of the dashboard screen.
Download Data: Data corresponding to an embedded sheet may be downloaded by clicking on the “Download Data” menu option on the sheet. This will provide options to select the number of rows to be downloaded, file format for download and an optional filename as shown.
Threads: You can capture a screenshot of the dashboard and annotate it or start a discussion about it with other members of your group/team by using the threads feature on the Dashboard UI. An email will be sent to all included members on creation of the thread
You can also view all threads related to the dashboard by clicking on the “View Threads” button.
You can tag dashboards so that you can search them easily in the future. This can be achieved by using the “Add Tag” feature on the dashboard screen. You can then search for similarly tagged dashboard by keying in the tag in the search box available inside the application header.
You can create alerts corresponding to the data on the dashboard by clicking the “Create Alert” option on the embedded sheet. Alerts are created corresponding to sheets and can be viewed directly in the sheet editor as well.
An alert may be triggered whenever there is a specific change in data that is displayed on the sheet. The condition for the alert may be defined in natural language using the (NLP) section of the alert. The condition may be validated by clicking “Enter/Return” after keying in the condition. Any errors or warnings will be displayed at the bottom of the NLP section.
A condition may be defined based on the row count in the resultset. A condition may also be defined by using a combination of aggregate functions, columns, comparison operators and user defined values in the condition section of the alert. All the conditions defined in the different sections should be true for the alert to be generated.
The alert may be configured by specifying the title, frequency, schedule and recipients of the alert. Alerts may also be configured to include a file attachment with data from the sheet.
You can delete an existing dashboard using the “Delete” option on the dashboard options menu. The dashboard will be deleted upon confirmation.
The dashboard may be pinned for easy access by clicking on the Pin button in the Dashboard listing screen. Links to all the pinned sheets and dashboards will be available on the home page under the “Pinned” tab so that they may be accessed directly. Pinned dashboards may be unpinned later.