SprngyBI User Guide

SprngyBI is used to create analytics for the cleaned and filtered data. There are various charts which can be used to create insights on the data.

It is required to have data processed and available in the Business Data Lake (BDL). The data available in BDL is exposed through schema and table definitions. These schema and table definitions are exposed through the query layer of SprngyBI.

Connecting to Data

After logging into SprngyBI go to Dataset page from Data menu option. On Dataset screen click on '+ Dataset' button to add any dataset.

It gives PostgreSQL, Presto, MySQL and SQLite or from a list of other supported databases. Below example shows how to connect with Data Lake using presto.

To add a database, go to Database page from the Data menu option. On Database screen click on '+ Database' button to add any dataset.

Open

Connecting with Data Lake

Open

After selecting Presto, for step 2 it ask for the presto url and database name to connect. Check for the connection by clicking on the connect button, if it succeeds then save the database.

Connecting with RDBMS

Another way is to connect with RDBMS database stored in MySQL. Here select MySQL from the list of supported databases.

On Step 2 it will ask for required credentials and database name to connect to the RDBMS database. Once filled click on Connect button.

Now on step 3 there are some additional settings if you want to add else click on Finish button to connect the database. For now the database list is filtered to show only the hive and presto connections but you should be able to add dataset of all connections from Dataset page.

Add Dataset

To add a dataset, go to Dataset page from the Data menu option. On Dataset screen click on '+ Dataset' button to add any dataset.

Use ‘Sprngy' database to access any of the application data in SprngyBI. On clicking on 'ADD’ button the data for that particular module and entity will accessible in SprngyBI as a dataset.

Creating Charts

Now you can create any charts using this dataset. To create a chart either click on that newly created dataset or go to charts page from the top navigation and select the dataset along with the required chart type.

After selecting the chart type, select the metrics and filters to create the required analytic on the dataset.

As you can see on the above image, it is a bar chart created on a teams dataset which shows maximum wins for all the teams. Once you are satisfied with the chart you can save the chart. To display various analytics of same dataset you can also create a dashboard and add these charts in it.

To create a dashboard, go to Dashboards page from the top navigation. Click on create dashboard button from top right, this would open up a customizable dashboard frame in which you can add any charts, scale them and add texts, filters as required.

Audit Dashboards

There are also sprngy dashboard which monitor the processing of data. You can use these dashboards to check on the workloads running, there success and failure, there time consumption and so on.

Query Editor

SprngyBI provides a query editor to perform ad-hoc analysis using SQL queries. Queries can be saved for future use and collaboration.