Introduction
The Master Data section contains Datasets, which are central to building reports, dashboards, and visualizations in AIV.
What is a Dataset?
A dataset is a collection of data—one or more columns from a single table or multiple tables—organized for use by business intelligence software. Datasets enable users to extract insights, generate reports, create charts, maps, and develop visualizations.
| Characteristic | Description |
|---|---|
| Source | JDBC, flat files, web services, NoSQL, and more |
| Purpose | Structured data for reports and dashboards |
| Access | Assigned by administrator; visible based on user privileges |
The Dataset tab is accessed by clicking Dataset or by selecting the option next to the Dataset tab to open it in a new tab. Dataset and other Master Data sections are visible only if the logged-in user has the appropriate privileges. Contact your administrator if you cannot access these sections.
What You Can Do with Datasets
Using the Datasets section, you can create, edit, and manage datasets as well as perform common operations such as download, upload, versioning, and auditing.
Create Dataset
Learn how to create a dataset in AIV using various data sources.
Learn more: Create Dataset
Edit Dataset
Learn how to edit a dataset after it has been created and used in dashboards.
Learn more: Edit dataset
Download, Upload, Version & Audit
Learn how to download, upload, and manage versions of datasets, and perform audit checks.
| Task | Guide |
|---|---|
| Download dataset | Download |
| Upload dataset | Upload |
| Version dataset | Version |
| Audit dataset | Audit |
Copy, Move, and Delete Dataset
Learn how to copy, move, and delete datasets in AIV.
| Task | Guide |
|---|---|
| Copy dataset | Copy |
| Move dataset | Move |
| Delete dataset | Delete |
Schedule, Property & Share
Learn how to schedule datasets for automated updates and manage properties and sharing.
| Task | Guide |
|---|---|
| Schedule dataset | Schedule Dataset |
| Dataset properties | Property |
| Share dataset | Share |
Archive and Purge
Learn how to archive and purge datasets to manage storage and data relevance.
| Task | Guide |
|---|---|
| Unarchive dataset | Mark as Unarchive |
| Unpurge dataset | Mark as Unpurge |
More Features of Master Data
| Feature | Guide |
|---|---|
| Create datasource | Datasource |
| Datasource mapping | Datasource mapping |
| Group dataset | Group Dataset |
| Create parameter | Parameters |
Advanced Dataset Features
| Feature | Guide |
|---|---|
| DML with multiple join condition | DML with Multiple Join Condition |
| External dataset | Dataset using External sources |