Workday Prism Analytics Interview Questions and Answers

The following are the workday prism analytics interview question and answers:

1. What is Workday Prism Analytics?

Prism Analytics is a workday device that permits you to join your workday information with outer information. It unifies it for utilization inside Workday reports, dashboards, and revelation sheets in the Workday. This will enable us to plan, examine, execute, make moves and make decisions in one single spot.

2. Determine the benefits of Workday Prism Analytics?

With workday prism analytics, you can examine your Workday and non-workday data together without having to expert it into a different information distribution center and BI (business intelligence) application. This makes investigation quicker, more accessible, more secure, and performed in a location where users can act on it.

3. What is a Prism Analytics Workday data source?

A Prism Analytics Workday data source is a kind of workday information source that makes you distribute a dataset. A dataset is a user-specified object in the prism analytics information inventory that portrays changed information.

When you post a dataset, Workday makes a prism data source and loads it with the changed information arranged in the dataset. Normally, datasets unify Workday and non-workday information.

4. How to analyze and visualize the data?

After a prism data source is available, you can utilize it to create visualizations and reports.  

5. List out the prism data sources?

Prism data sources are different from workday-delivered data sources ways:

• Are created by a colleague at your organization.
• Have their primary business object that isn’t linked to any other business object in Workday.
• Can have their data removed. When someone removes the data in a prism data source, all reports that use it will be broken until a prism data analyst populates the prism data source again.
• It can be deleted from your tenant by unpublishing the corresponding dataset.

6. What kind of security tool does workday prism data analytics provide?

Prism data source also has their security. Security group access controls who can see a prism data source.

With the appropriate permissions, you can:

• Create a visualization in a discovery board using the prism data source.
• Create a custom report using the prism data source.
• View a prism data source by accessing the view prism data source report.
• Delete the data (rows) in a prism data source from the view prism data source report by selecting actions >prism data source > delete published rows.
• Remove the prism data source from Workday by unpublishing the dataset that created the prism data source.

7. What sorts of custom reports can be created using prism data sources?

You can create these types of custom reports using a prism data source:

• Advanced: some features aren’t supported, such as sub-filters. Workday only displays features that it supports. Also, only add a field from a related business object when necessary. Areas from a corresponding business object might impact report performance.
• Composite: The prism data source must include at least one instance field.
• Matrix: Most features are supported. Lookup prior value isn’t supported.
• Simple: All features are supported.
• Transported: All features are supported.

8. What types of fields are created using prism data sources?

You can create these calculated fields using prism data source:

• Arithmetic calculations
• Build date
• Date constant
• Date difference
• Evaluate expression
• Format date
• Format number
• Format text
• Numeric constant

9. Are there any limitations in creating calculated fields?

Workday only makes available calculated fields that are supported for the prism data sources.

There are some limitations when creating some calculated fields:

Calculated fields only work on supported fields types. For example, date-related functions work only on the lot of type date.

You can’t use instance or multi-instance fields in some calculated fields, such as format text and substring text. This is because instance and multi-instance fields in prism data sources only include the unique identifier information (also known as a WID), not the display name.

10. Determine dataset?

Dataset is a Prism Analytics entity that controls some basic information and describes some processing logic to manipulate the data. A dataset can define either Workday or non-Workday (external) data. This enables you to analyze your Workday and non-Workday data together without exporting it into a separate electronic data warehouse and business intelligence (BI) application. A dataset can also describe data from another table or dataset by deriving the dataset from an existing table or dataset.

11. List out the dataset field types?

Dataset uses these field types:

• Boolean: A workday-specific field type that contains Boolean values.
• Date: Date combined with a time of day with fractional seconds based on a 24-hour clock
• Integer: 32-bit integer(whole number)
• Long: 64-bit long integer(whole number)
• Text: variable length non-Unicode

12. How can we create a dataset using workday data?

You can create a dataset using Workday data. You do this by creating a dataset using an existing Workday custom report as the source for the dataset. You configure how often the dataset gets new data from the information. Workday retains only the fields with field types that datasets currently support. Creating a dataset from a custom report creates a base dataset.

13. What are the prerequisites required to create a dataset?

To create Prism Datasets, you need to create a domain in the Prism Analytics functional area.

14. How to create and edit tables and datasets?

The first stage in the data management workflow is to bring data into the Prism Analytics Data Catalog. You get information by creating a table or a base dataset, and you transform data by creating a derived dataset. Datasets include metadata and a subset of data as a small collection of example rows. Tables have metadata and all data rows in the table. When it comes to security with tables and datasets, you control access to the metadata and data together.

15. In what way does Workday control datasets and tables?

Workday controls who can do what with tables and datasets in these ways:

Security administrator grants access: Your Workday security administrator can configure Workday security domains to grant groups of users to be able to create, edit, or manage tables and datasets

Table sharing and dataset sharing: The user who created a table or dataset can share it with particular users and grant different access levels to each user.

16. What is prism expression language?

Prism Analytics includes its expression language that’s composed of functions and operators. You use the Prism expression language to create an expression, and you can create new values or filter existing values.

17. What are the critical features of workday prism analytics?

• Data integration and management: Access finance and HR transactional data from Workday.
• Data governance: Govern data using the workday security framework.
• Self-service preparation: preview data transformation to ensure what was expected.
• Productionalized insights: Use data from workday prism analytics in workday reports, dashboards, and discovery boards.

18. What are the benefits of workday prism analytics?

Some of the benefits of workday prism analytics are listed hereunder:

It’s web-based. No requirement to install any desktop clients on your machine to use the platform.

It’s most appropriate for a big data Hadoop environment.

Client presentation wise it’s good. You can get different kinds of graphs.

It’s very easily understandable, and for the new people who want to try the platform, the learning curve is low

You can create your datasets on the platform. You can store your results as a dataset in the medium and can share them across

19. List out the analytics features of workday prism analytics?

The following are the essential features of workday prism analytics:

• Data integration
• Data management
• Data preparation
• Data discovery
• Reporting
• Data governance

20. State some disadvantages of workday prism analytics?

Data movement- data needs to be moved from Hadoop to the platform to create a platform lens and do analytics.

To support data movement, the infrastructure cost is high.

To support data movement, network bandwidth consumption is high.

No trial versions for companies to evaluate.