Joined data sets allow you to analyze data from more data sets together and therefore use data from more data sources in a single report.
The principle is similar to joining SQL database tables. |
Creating Join
To create join in BellaDati:
- Navigate to one of the Data Sets you want to use in join
- Click on Joined Data Sets in Settings section of the left action bar
- Choose Create Join
- Select Data Set to be joined with
Join condition
Each join has to have specified following parameters:
- Name: Joined data set name.
- Join with: Name of the source data set to join with.
- Join condition: Date/time in both records are taken in account or not.
- With Time Match: Date/time in both records are taken in account.
- Without Time Match: Date/time in both records are not taken in account.
- Custom: Cross join with option to specify own condition.
- Join type: Standard join types available - match always depends on attributes.
- Left outer join: Record in the target data set is not mandatory.
- Inner join: Record in the target data set is mandatory.
- Cross join: No attribute match required.
The resulting joined data set will contain all the attributes and indicators from all source data sets. |
Custom Join Condition
BellaDati allows you to define you own joining condition. To do so:
- Select Custom in Join Condition
- Cross join will be automatically applied
- Type joining condition to restrict the output
BellaDati offers you autocomplete to easily construct joining conditions. |
Multiple Join Points
One data set could be joined with more data sets (eg. join by department ID to get department full name, address, country, total sales and then join by product ID to get products name, price, weight and mass). Each join is called join point.
To add another joining point into existing join:
- Click on add joining item
- Select desired Data Set
- Continue with Join Conditions
Joining Facts and Restrictions
- Data in the joined data set will be the intersection of all joins.
- Data in joined data sets are updated automatically when data are changed or imported to the source data sets. You cannot import data directly to the joined data sets.
|
- Please note, that the permissions setting based on data filter has to be set for both (source and joined) data sets!
- Data join is also available on data source level (database). Please consider this option when you plan to analyze millions records of data. Joining on database level may provide better performance.
- Joined data set is rebuilt after the import into one of the data sets which is joined. All data sets which are used in this joined are locked during this time - import into these data sets will not run.
|
Joined data set supports these functions the same way like in ordinary data set:
Tutorial video
Next Steps