Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, after importing a table into a derived dataset (DDS), you can inspect the data for quality issues, such as NULL values, before proceeding with transformations. According to the official Workday Prism Analytics study path documents, to check for NULL values in a specific field like Worker ID, the most direct method is to click on the field name and check the stage statistics. When viewing a dataset in the Prism Analytics interface, clicking on a field name (e.g., Worker ID) in the dataset preview displays stage statistics, which include metrics such as the count of NULL values, distinct values, and other data quality indicators. This feature allows users to quickly assess the presence of NULLs without modifying the dataset or adding unnecessary stages.
The other options are not the best approach for this task:
A. Add a Manage Fields stage: The Manage Fields stage is used to modify field properties (e.g., type, visibility), not to inspect data for NULL values.
C. Create a Prism calculated field: While a calculated field could be used to flag NULLs (e.g., using ISNULL), this is an indirect and unnecessary step compared to checking stage statistics.
D. Join on the Worker ID field: Joining with another dataset does not help identify NULL values in the Worker ID field and is irrelevant to this task.
Using stage statistics by clicking on the field name provides a straightforward and efficient way to gain insight into NULL values in the Worker ID field.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Data Quality Checks in Derived Datasets, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Inspecting Data Using Stage Statistics, ]
