Datasets function as an additional layer between Data Sources and elements created in Metric Insights. This functionality gives users without technical background the ability to utilize the data. With datasets there is no need to understand the structure of source database, know SQL or syntax of other BI tools. Datasets allow:
- Data to be easily staged to support business users in creating their own Metric Insights content without having to understand or have access to underlying Data Sources
- Snapshots of data from any Data Source without having to create and maintain "staging reports".
- Creation of exception and change reports from any Data Source without having to understand Data Source-specific syntax or SQL
- Utilization of dynamic filtering to identify exceptions and changes in large, complex data sets without any dimensional restrictions
For more details refer to: Create a Dataset