SpringyBI 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 SpringyBISprngyBI.
Connecting to Data
After logging into SpringyBI 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.
...
Connecting with Data Lake
...
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 Add dataset 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 the database name, schema name and the table inside of that schema.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 springybiSprngyBI. On clicking on 'ADD’ button the data for that particular module and entity will accessible in springybi 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.
...
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.
...