An In-Depth Overview of Workday Prism Analytics Training

Posted On Aug 09, 2022 |

in this blog, we will give a detailed overview of Workday Prism Analytics training

An In-Depth Overview of Workday Prism Analytics Training

What is Workday Prism Analytics?

Prism Analytics is a tool that provides the ability to ingest, blend and transform Workday data with external data and publish the output as a Prism data source. This feature enables executives to gain a full perspective of their financial and HR performance a good way to correctly and effectively manipulate their commercial enterprise consequences. With Prism Analytics, external data can be modeled, transformed and combined with Workday data. Workday Prism Analytics is an end to be summarized in order to put operational insights into the right hands at the right time.

Workflow in Workday Prism Analytics

Prism Analytics is a workday tool that permits you to mix your workday information with external information. It unifies it for use in Workday reports, dashboards, and discovery sheets in Workday. This will allow us to plan, research, execute, make moves and make decisions all in one place. The primary reason is that Prism gives us the ability to ingest, transform, and combine Workday data with external data, publish it as a Prism Data Source, which can then be used with reporting and search dashboards.

Phase 1: Bring in Data

The first stage of the data management workflow is to transfer the data to the Prism Analytics data catalog. You get the information by creating a table or base dataset, and you transform the data by creating a derived dataset. Datasets include metadata and a subset of the information as a small series of instance rows. Tables have metadata and all statistics rows within the table. When it comes to protection with tables and datasets, you manage to get entry to metadata and data together. A dataset is a Prism Analytics entity that controls some basic information and describes some processing logic for manipulating the data. A dataset can define weekday dates or non-weekday (external) dates. This allows you to analyze your Workday and non-Workday data together without exporting it to a separate digital facts warehouse and enterprise intelligence (BI) application. A dataset can additionally describe data from every other table or dataset with the aid of deriving the dataset from an existing desk or dataset. To create Prism datasets, you must create a domain in the Prism Analytics functional area. You can create a dataset with the use of Workday statistics. You do that by developing a dataset with the use of a present custom Workday file because of the dataset supply. You configure how regularly the dataset receives new statistics from the records. Workday only stores fields with field types that datasets currently support. Creating a dataset from a custom file creates a base dataset.

Phase 2: Transform the Data

After transferring data to a data catalog, you create derived datasets to transform, enrich, and join data. Import data into the data catalog by uploading an external file, loading an external file from an SFTP server, using the REST API, or importing data from a custom Workday report. When creating datasets in Workday, it's important to follow a naming convention. Create a derived dataset to describe the processing logic you need to prepare the data for analysis. Derived datasets contain information about how to process, blend, and transform the data you import into them

Phase 3: Editing and Blending the Data

A derived dataset is created from an existing dataset so that additional transformations can be applied. Once the data is inside Workday, you can manipulate it as well as expose data transformation operations as user interface-based "transformation stages." These operations encompass but aren't constrained to, SQL operators such as FILTER, JOIN, GROUP BY, and UNION. Transformation stages are interconnected to create channels that allow users to interactively navigate and visualize changes. The Edit Dataset Transformations task is where you make changes to the dataset definition to manipulate the data. This task acts as a single-page application, which means that you can dynamically interact with the elements of the task as if it were its own application. You can also make any changes you want, such as adding calculated fields and Prism stages. When you're done, click Save to save all changes to the dataset. A filter stage is a type of stage that limits rows in a dataset based on filter criteria that you define. Add filter stages to limit the data in the dataset for analysis, for example to a specific region or year. You can add or remove filter stages in the middle or at the end of the pipeline, and the Group By stage is a type of stage that allows you to summarize multiple values in a dataset by specified groups. You can summarize values using a summarization type such as MIN, MAX, or SUM. And group by stages to get the data to the appropriate level you need to join the data in one dataset with another dataset. Add join stages to display and use related data from different datasets. You can add or remove a connection stage anywhere in the primary channel of the derived dataset. Then a Union phase is a type of phase that combines data from similar fields in different datasets into a single field.

Phase 4: Applying Security to the Data

Data outside of Workday has no security. By bringing external data into the data catalog, you can take advantage of the strong security model that Workday offers. The next stage of the data workflow is to apply security to the data in the dataset using existing Workday security domains. You apply data security by modifying the data source security on the dataset that contains all the data you need to analyze. When you first create a dataset, there is no security configured in the security of the data source. By default, Workday applies security to data when no data source security is configured. Workday applies security restrictions to published data in the form of a Prism data source.

Phase 5: Make the Data Available for Analysis (Publish)

A way to make data available for analysis is to publish a dataset. Workday will use the security domains configured in Data Source Security on the dataset, or will use the Prism: Default security domain on Dataset Access if no data source security has been configured. You can use Prism data sources in visualizations and reports like any Workday-supplied data source. A published Prism data source will be available for use in Workday reports for members of security groups with domain view permission. Data for the Prism data source is available after publication and will not be updated until the next publication. If you need to include both levels of data for your reporting, you can combine an aggregated dataset with a detailed dataset. Once a Prism data source is available, you can use it to create visualizations and reports. If you want to have aggregated and detailed data available in the reporting dataset, connect the detailed dataset to the aggregated dataset and match the group by fields. For the activity use case, we can republish the Prism data source to include this mixed aggregate and detail data by replacing the final imported derived dataset in our PDS with the newly merged aggregate and detail dataset. Additional aggregated fields will be available in the Prism data source for use in the report. Workday Prism Analytics is essential for tracking employee timesheets and Integrating them right into a gadget that allows employees to track their PTO and previous payslips. The product combines many offerings into a single interface that offers users a synchronized data source for the workplace. Offering this to employees makes the process much smoother.

Phase 6: Reporting on Prism Data

To create a table from a Workday record or to apply a Workday record as a supply in a facts alternate task, the record need to be configured: As a complicated record. Tables and facts alternate responsibilities do now no longer guide uploading different record sorts inclusive of matrix or composite. Check the Enable field for Prism at the superior tab of the custom record. Workday does now no longer guide record choice while the record contains: Fields from an associated enterprise item that have a many-to-1 courting with the number one enterprise item. To optimize overall performance while strolling a facts alternate job, recall those options: Use listed facts sources every time viable. Use facts sources that offer the smallest viable facts set that suits your needs. Example: If you're inquisitive about repayment-associated transactions, use worker repayment occasions in place of all enterprise technique transactions. To create a dataset from a Workday file, the record should be configured: As a complicated record. Improve record overall performance with the aid of using along with calculations in Prism in which feasible. Note that a few calculations, inclusive of calculations finished in Prism, can't be aggregated right into a Workday record and ought to be finished as matrix calculations for the proper consequences section.

Maintenance of Workday Prism Datasets

Making facts to be had for evaluation the Field Management section makes use of the output from the preceding section as a foundation for monitoring adjustments. Data control is a critical part of Workday training. If the baseline adjustments, within side the Manage Workday area level: Shows all new and deleted fields. Workday recommends that you: Add a Manage Fields level to the start of the number one pipeline of the derived dataset in case you need to reveal the schema of the desk or dataset from which it's far derived. Add a Manage Fields level to the quit of the number one pipeline of the dataset you need to publish. If you want to cover fields or display new fields, upload a Manage Fields level to the quit of the channel. Add a Manage Fields level to the center dataset to make certain that no destiny integration can inadvertently eliminate present fields. In a few cases, Workday handles schema adjustments without the usage of the Manage Fields section.

Workday Prism Analytics Challenges

Complete review of overall performance

They are relied upon with the aid of using executives, managers, and choice-makers all through the enterprise company greater than financial and HR statistics to make choices. They want facts from their CRM, supplier control, LMS, engagement, or industry-precise structures to get a whole image of the enterprise's overall performance. Workday Prism Analytics permits a properly timed, dependable, and precise view by using bringing all these records, integration, and manage competencies inside Workday.

Accelerated preview time

When it involves analytics, company analysts conflict to Access the statistics they want to generate insights quickly. Analysts get a specific set of company records with Workday Prism Analytics that they might place together, integrate and have a look at with point-and-click capability. Thanks to the effective audibility and capability of the facts feed included in the platform, customers can efficiently control and edit facts for reporting, evaluation, and making plan functions without coding or extra licenses. They can then proportion their understanding with colleagues and executives who want it.

IT agility and efficiency

IT groups are carrying themselves out seeking to carrier enterprise analytics demands, spinning withinside the shadows of Access, keeping specific protection models, and presenting process tedious and high priced substantial facts infrastructure deployment. Workday Prism Analytics permits IT, groups, to install protection as quickly as with bendy manage that adapts and meets industrial company needs. And due to the fact, that Workday Prism Analytics is completely cloud-primarily based totally, we make it tough to keep and replace its software. It allows IT, groups to put in quicker whilst nonetheless attaining basic overall performance and the scalability of Hadoop, Spark, and the stylish storage and processing technology.

Key Properties
Data Integration and Management

With prism analytics, you could bring information from any deliver via API, SFTP, or browser record upload. You can access monetary and HR transactional records from Workday with the aid of using effects looking, discovering and coping with datasets in a single statistics catalog and timetable computerized updates to keep your records in sync and updated.

API Capability

Workday Prism Analytics' intuitive person interface makes it smooth to expand and keep facts transformation pipelines, plus you could additionally practice to any dataset to join group, and clear out functions. Finally, you could assess the records versions to ensure that your records meet expectancies in advance than it's far run.

Data control

Apply role-primarily based totally and context-primarily based totally protection for personalized Access. You can manage information with the use of the Workday protection framework and set precise permissions for growing, sharing, and publishing datasets.

The valuable records series center

Use records from Workday Prism Analytics in Workday evaluations, dashboards, and discovery boards; plus, you could view large datasets with a high-overall performance in-reminiscence analytics engine and then percent insights with everybody in the enterprise.

Benefits of Workday Prism Analytics

• Anyone in your organization can Access records with the useful resource of creating evaluations and dashboards to be had on any tool.
• Manage multiple facts reassets and provide choice-makers with a single deliver of truth.


• Maintain responsive financial and employees facts in Workday and integrate outdoor assets as wanted
• Set permissions primarily based totally on roles that adapt as your enterprise adjustments.


• Transform facts into motion with analytics and transactions in a single device, related thru an acquainted person interface.
• Take management of the way paintings receives completed with clean equipment that does not require coding and a device it truly is clean to installation, control and keeps.

Analytical Insights assist you solution those questions:

Competitors to Workday Prism Analytics