View Source

BellaDati BI has its own integrated data warehouse and ETL engine. This warehouse contains virtual databases that represents data with similar characteristics. These virtual databases are called data sets and reports are built based on them. Each data set can be connected to multiple data sources.

Following objects are defined and managed in data set:

Following actions can be performed within data sets:

Only users with data manager role are allowed to manage the data sets. If you don't have this role, please contact your BellaDati administrator.

Circulation of Data Changes

BellaDati User Documentation > Data sets and ETL > ssm.jpg

All changes in repositories are automatically propagated to all reports and dashboards, eventually to all resources available over REST API. See these links for more details:

Tutorial video

<iframe width="560" height="315" src="https://www.youtube.com/embed/-CFhx-if1lM" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

Data set summary window

Data set summary window displays:

Basic informations about data set
Import history
List of reports

Typical data set summary window looks like following:

BellaDati User Documentation > Data sets and ETL > image2018-3-19 10:50:21.png

The boxes located under the name of the data set contain following information:

date of last change
records count
date and status of last import
date and status of alerts (one box for each alert)
date of last cube execution (for big data sets).

Action list (submenu layout)

Data set summary
Attributes settings
Drill down paths
Indicators settings
Joins settings

Import data: Allows data manager to import new data from clipboard or files.
Data source: Management of connection to external databases, URLs or third party systems.
Data collecting forms (if enabled)
Browse data: Data browsing, editing and export.
Create alarm: Data changes watching option.
Erase data: Deletes all data from the data set.

Share with users: Grants access to the data for other users or user groups, including data filter settings.
Duplicate: Creates copy of data set.
Backup structure: Stores the whole structure of the data set and related reports to XML file.
Import report from XML - import XML backup of report
Remove data set: Allows removing the whole data set and related reports from BellaDati.

date, time, timestamp, geojson, point, boolean, text, varchar