Datasets
Last updated
Last updated
A dataset is a structured collection of data used for analysis and visualization. In ViewZen Analytics, a dataset can correspond to a database table, a database view, or a database query.
Each column in a dataset represents a specific variable within the data.
Each row contains a collection of variables that form a single data record.
A dataset in ViewZen Analytics can source its data from
ViewZen Analytics Store - A dataset may get created in either a PostgreSQL or an ElasticSearch Store when data is imported via ViewZen Pipelines. ViewZen Pipelines may connect to any relational database such as MySQL etc. or a business application or a spreadsheet like Google sheet or excel.
Live Databases - It can connect directly to Databases (SQL, NoSQL, Cloud-based databases) post registration. The registration process allows you to associate the dataset to a table or view or a query.
In ViewZen Analytics, a dashboard can be created using multiple different datasets each residing in a different database. This makes ViewZen Analytics a very powerful platform capable of providing integrated analytics from multiple sources.
A dataset can be added to a dashboard in the one of the following ways
While creating a new dashboard - You can select one or more datasets at the time of creating a new dashboard.
From within the dashboard - New datasets can be added from within a dashboard by opening the dashboard in the edit more i.e. Designer option. This following steps can be followed to add additional datasets to a dashboard
Navigate to the Dashboard: Locate the dashboard to which you want to add additional datasets. Open the dashboard in Edit mode.
Click on "Add dataset" Icon - The "Add Dataset" icon is the first icon located at the right end of the designer toolbar.
Select Additional datasets - Select additional datasets from the "Add Dataset" list and confirm.
The fields section lists the following
Dataset columns - Dataset wise-columns present in each dataset that is added to the dashboard and their types.
Expressions - Expressions created on added datasets.
Context fields - If a context field is mapped to an added dataset field, the context field will be listed.
Formuale - Any formula created on the added dataset will be listed.
