Skip to content

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.

CharacteristicDescription
SourceJDBC, flat files, web services, NoSQL, and more
PurposeStructured data for reports and dashboards
AccessAssigned 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.

TaskGuide
Download datasetDownload
Upload datasetUpload
Version datasetVersion
Audit datasetAudit

Copy, Move, and Delete Dataset

Learn how to copy, move, and delete datasets in AIV.

TaskGuide
Copy datasetCopy
Move datasetMove
Delete datasetDelete

Schedule, Property & Share

Learn how to schedule datasets for automated updates and manage properties and sharing.

TaskGuide
Schedule datasetSchedule Dataset
Dataset propertiesProperty
Share datasetShare

Archive and Purge

Learn how to archive and purge datasets to manage storage and data relevance.

TaskGuide
Unarchive datasetMark as Unarchive
Unpurge datasetMark as Unpurge

More Features of Master Data

FeatureGuide
Create datasourceDatasource
Datasource mappingDatasource mapping
Group datasetGroup Dataset
Create parameterParameters

Advanced Dataset Features

FeatureGuide
DML with multiple join conditionDML with Multiple Join Condition
External datasetDataset using External sources