Understanding Connections, Datafeeds and Datasets


Intuitive Dashboards uses three entities to make information available to end-users. They are ConnectionsDataFeeds and DataSets.

The Connection defines the location of the database, spreadsheet or file. Connections function in similar ways for the differing source types; Exceltext file and ODBC databases, providing a level of abstraction so that, for example, an administrator could setup a database connection for designers to use without the designers having to know details such as the database instance name, authentication parameters or engine-type.

The DataFeed defines what information will be taken from the Connection and can be used to define a schedule for when this data is refreshed with new data from the source system. Once again datafeeds work in similar ways for different source types and thus can be used to abstract the complexity of the underlying source system away from end users.

The DataSet defines how the data from the DataFeed will be used within the dashboards. The Dataset contains potentially complex rules dictating calculations the dashboard will perform as it summarizes and drills into the source information. These include creating expressions to extract more useful data, remapping the dataset to a new Datafeed and adding security filters to protect and restrict sensitive data from unauthorized users. The DataSet is intended to be provided to end-users allowing them to access powerful BI functionality without having to understand the often difficult database and BI concepts underpinning it. Users of a Dataset cannot know the source-type or location of the underlying data unless the admin or designer chooses to inform them.

Have more questions? Submit a request


Powered by Zendesk