Creating & Editing Dashboards on Sprinkle & Feature Details
Business Intelligence Dashboard is a data visualization
tool that displays the current status of metrics and key performance indicators (KPIs) for an enterprise.
Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department.
The essential features of a dashboard product include a customizable interface and the ability to pull real-time data from multiple sources.
Dashboards on Sprinkle can be created by combining reports or visualizations from different Explore and Segments.
Click on Analytics -> Dashboards on the left navigation pane, to start using the Dashboard feature on Sprinkle. The listing page lists all the dashboards that have been created by you in the My Dashboards tab and other team members in the Shared with Me tab.
Dashboard Listing Page
Click on New on the top right corner of the page to create a new dashboard. Provide a Name to the Dashboard and
Create a New Dashboard
Now start Adding Explores & Segments Reports and Visualizations to the Dashboard by clicking on the "+" icon or by selecting Add report from the more options, Three Dots icon on the right. Other options in the more options list are explained in the More Options Sections Below
Add Segments & Explores, More Options
Filter Mapping: Filter data on your dashboard
Filter Mapping empowers you to filter data on your dashboard, on the go. Customize your dashboard with filter operators.
To start using the Filter Mapping,
click on More Options -> Filter Mapping
Click on New to create a new filter.
More Option -> Filter Mappings
Put a Name to the Filter & Select its type. Add Description in the field. Select the Column on which the Filter is to be applied. Click on Create
Click on the existing filter to edit it.The Filter can also be Renamed, once created, just change the name in the Edit form, Simple!
Enabling Restricted Operators lets you restrict the operators that can be used in the filter on the Dashboard. In the Below
Example, The Product Id filter has been restricted to "is any" & "is equal to".
Restricting Operators for the Filter
Multiple Columns mapping to a single filter
You can select multiple columns of the same type under one filter.
In the example below
, the reporting model has two state columns named “Seller_State” and “Buyer_State”. While mapping filters to the dashboard a common filter called “state” was created by selecting these two states columns. The filter applies AND logic to the outputs, and the same values are passed for both columns.
Multiple Colum Mapping
On Dashboard Page
Save and Run
Save Changes & Run the Job to update the dashboard with updated data.
Switch to Tab/Grid
Switch between Grid & Tab Views
Switch To Tab: Tab View of the Dashboard
Customize the view of your layout best suited to your needs, through the Edit Layout Option. Easily drag & drop, enlarge reports on the dashboard.
Sprinkle also has a feature to download the complete dashboard or the individual visualization charts as PDF. Just click on Download as PDF button on the dashboard page to download the complete dashboard.
In order to download the individual visualization reports from the dashboard, you can click
on any report and then click on Download as PDF button.
The Dashboard owner or other users with the access can add Business Metadata to the Dashboard. Go through the detailed documentation on the Business Metadata.
From the Filter Section in the Dashboard, you can quickly filter data that is represented in the dashboard. Hover over the
icon to view the description of the filter.
Re-Order Filters using the option on the right, based on the requirement.
Apply values to the filters, Save and Run. Voila!
You haveupdated the data on the Dashboard.
Filter Section on Dashboard
The Job section shows the last three jobs that were run and related information. Jobs are run when
Clicking Save and Run or Run on the top right corner.
Click on Show Details to view the details of the Job & the SQL query that was run in the background to produce the required output.
Auto-Run: Set Auto-Run, to run the Dashboard periodically and update the results automatically
Add Report: Add more Explores & Segments to the Dashboard using Add Report
Clone Dashboard: Dashboards can be Cloned (or Copied) and used to build over the top of existing Dashboards.
Add Merge Settings: Merge reports on the Dashboard to display a consolidated report
Settings: Manage Folder, Owner, Concurrency, Merge Fetch Limit through the settings
Share: Dashboards can be shared with users and user groups like Admin, Developer, Analyst, Report Viewer
Schedule Emails: Schedule Email
Notification when the Dashboard is Set to Auto-Run, by defining the Trigger, Notification Type, To & Subject of the Email
Filer Mapping: Explained Above
Delete Dashboard: To Delete the Dashboard
View Activity: User activity on the Dashboard can be viewed using this option
Embed URL: Embed Dashboard to third party applications using the Embed URL Feature