Before designing a dashboard, it is necessary to decide the data that you are going to visualize, to pick the right widgets for visualization.
So It’s important to understand the difference between a
Connection and a
Difference between Data Sources and Connections
Connection represents your connection to a type of data. It can be a
Microsoft SQL server database
The Connection can also represent a
Microsoft Excel File.
For a complete list of supported connection type, please check the connecting to data section here.
Data Source is a representation of your data. It can be created from a
Examples from one connection
Data source can represent a table from a
Microsoft SQL Server connection like below.
Data source can also represent two tables from the same
Microsoft SQL Server connection like the example below.
If you create a Data Source from two tables or two connections you will have to merge data. Please see the section