Concept: Datasets

A dataset is a Prism Analytics object that describes some processing logic to manipulate some underlying data. You create datasets to transform, blend, and combine data to prepare it for analysis.

You can create these types of datasets:

Base dataset. A base dataset is a dataset that brings data into the Prism Analytics Data Catalog and controls the underlying data that it brings in. A base dataset can bring in either Workday or non-Workday (external) data. Workday data comes from the output of a custom report, and external data comes from external source files.

Derived dataset. A derived dataset is a dataset that imports data from 1 or more existing tables or datasets. The source data of a derived dataset comes from the output of existing tables and datasets. You use derived datasets to blend together data from different sources, such as Workday data and non-Workday data. Some stage types, such as Join and Union, are only available to derived datasets.

By bringing in both external and Workday data, you can create derived datasets to blend, transform, and enrich them together. This enables you to analyze your Workday and non-Workday data together without having to export it into a separate electronic data warehouse and business intelligence (BI) application.

You create base and derived datasets from the

Data Catalog

report using the

Create

button. You create a base dataset when you select these options from the

Create

button menu:

from File

. This option creates a base dataset with external data that you upload in the browser.

from SFTP

. This option creates a base dataset with external data that Workday retrieves from an SFTP server using an integration.

from Custom Report

. This option creates a base dataset with Workday data.

You create a derived dataset when you select the

Derived Dataset

option from the

Create

button menu.

If you're new to Workday, you don't have access to create or edit base datasets.