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 established on them. Each data set can be connected to multiple data source.

In data set following objects are defined and managed:

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.

Tutorial video

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 > dataset.png

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