Workday Prism Analytics Exam Questions

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, a matrix report in Workday is designed to display summarized data in a grid format, with built-in capabilities to calculate aggregations like minimum, maximum, total, average, and median. According to the official Workday Prism Analytics study path documents, to produce a Prism data source for a matrix report that needs to display the minimum, maximum, total, average, and median purchase order amount by location and month, you should publish your detail data and build the summarizations in the matrix report (option A).

Publishing the detail data (i.e., the raw purchase order data with fields like location, month, and amount) as a Prism data source allows the matrix report to access the granular data. The matrix report can then apply the required aggregations (MIN, MAX, SUM, AVG, MEDIAN) directly, grouping by location and month as specified in the report configuration. This approach leverages Workday's reporting capabilities, reducing the need for additional transformations in Prism and ensuring flexibility for future reporting needs.

The other options are less efficient:

B . Add a Group By stage to your derived dataset: A Group By stage in the derived dataset can compute some aggregations (e.g., SUM, AVG), but Prism does not natively support calculating the median in a Group By stage, and it would require multiple stages or calculated fields to compute all metrics, making it less practical than using the matrix report.

C . Publish your detail data and build the summarizations in the advanced report: While an advanced report can perform some summarizations, it is not as well-suited as a matrix report for displaying multiple aggregations (like median) in a grid format by location and month.

D . Add two Group By stages to your derived dataset: Using two Group By stages is unnecessary and still does not address the limitation of calculating the median in Prism, making this approach overly complex.

Publishing the detail data and letting the matrix report handle the summarizations is the most efficient and effective way to meet the requirements.

Workday Prism Analytics Study Path Documents, Section: Publishing and Visualizing Data, Topic: Preparing Data for Matrix Reports

Workday Prism Analytics Training Guide, Module: Integrating Prism with Workday Reports, Subtopic: Leveraging Matrix Reports for Aggregations

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, a Filter stage in a derived dataset is used to include only rows that meet specific criteria. The requirement here is to show expense reports that satisfy two conditions: (1) submitted in the current month, and (2) total amount higher than 2000 USD. According to the official Workday Prism Analytics study path documents, this can be achieved by using a simple filter with two conditions and the 'If All' operator (option A).

The first condition would check the submission date, using a function like MONTH() to compare with the current month (e.g., MONTH(submission_date) = MONTH(CURRENT_DATE())). The second condition would compare the total amount (e.g., total_amount > 2000). The 'If All' operator ensures that both conditions must be true for a row to be included, which aligns with the requirement that both criteria (current month AND amount > 2000 USD) must be met. A simple filter is sufficient because the logic involves straightforward comparisons without nested conditions.

The other options are incorrect:

B . Use a simple filter, two conditions, and 'If Any' operator: The 'If Any' operator would include rows where either condition is true (e.g., submitted in the current month OR amount > 2000 USD), which does not meet the requirement for both conditions to be true.

C . Use a simple filter, three conditions, and 'If All' operator: Only two conditions are needed (submission month and amount), so three conditions are unnecessary.

D . Use a simple filter, three conditions, and 'If Any' operator: This combines the issues of option B (wrong operator) and option C (too many conditions).

Using a simple filter with two conditions and the 'If All' operator ensures the dataset includes only the expense reports that meet both criteria.

Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Applying Filters in Derived Datasets

Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Configuring Simple Filters with Multiple Conditions

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, a Data Change task is used to load or update data into a table, which can involve importing data from multiple source files. According to the official Workday Prism Analytics study path documents, when loading rows from multiple source files into an empty table, the source files must share the same schema. The schema defines the structure of the data, including the column names, data types, and their order, which ensures that the data from all source files can be consistently mapped and loaded into the target table without errors.

The schema is critical because the Data Change task relies on a predefined table structure to process the incoming data. If the schemas of the source files differ (e.g., different column names or data types), the task will fail due to inconsistencies in data mapping. The other options are not required to be the same:

Source: The source files can originate from different systems or locations (e.g., Workday, external systems, or file uploads) as long as the schema aligns.

Naming convention: The names of the source files do not need to follow a specific convention for the Data Change task to process them.

Size: The size of the source files (e.g., number of rows or file size) can vary, as the task processes the data based on the schema, not the volume.

Thus, the requirement for the source files to have the same schema ensures seamless data loading into the table, maintaining data integrity and consistency during the transformation process.

Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Data Change Tasks and Schema Requirements

Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Loading Data into Tables Using Data Change Tasks