Can we connect several data sources to each other in Bold BI?
Integrating data from various sources is a common requirement for businesses to gain comprehensive insights. Bold BI supports multiple methods to connect one or more data sources, ensuring that users can create rich, interactive dashboards from their combined data. Here are the two primary ways to integrate data sources in Bold BI:
1. Data Source Joining
Data source joining is a method where you can create relationships between different data sources. This allows you to perform operations such as inner join, left join, right join, and full join, depending on your requirements. Joining data sources is particularly useful when you need to merge data from different databases or tables that share a common key.
For detailed steps on how to join data sources in Bold BI, please refer to this documentation: Shared Tables.
2. Appending Data Sources
Append data sources is another powerful feature in Bold BI that enables you to merge data from multiple sources into a single data source. This can be done by appending data from one source to another or by blending them based on common dimensions. Append data sources is beneficial when you have data in different formats or from different systems that you want to analyze together.
For guidance on how to append data sources in Bold BI, visit the following documentation: Append Data Sources.
By utilizing these methods, you can effectively consolidate data from various origins, paving the way for more insightful analysis and decision-making.
Additional References
