How to do Prism Reporting Extracting Data through Prism Analytics

Posted On Jan 31, 2023 |

In this blog, you will get to know about Prism Analytics, Data Acquisition, Blending Datasets, and Data set Concepts.

In order to address the global market challenges, organizations require a software system with intuitive tools that blends all data sources from the order management system, CRM system, social media data, corporate travel expenses, and much more to form a data hub by maintaining conformity and generating business analytics and insights. That intuitive software system is nonetheless Prism Analytics Workday.

On hearing Prism, one might wonder ‘What is Prism?’ Prism supports the ingestion of structured data from the source that is delimited and able to be parsed.

Now technically, let’s answer the query ‘What is Workday Prism Analytics? or What is Workday Prism?’

Workday Prism Analytics is a tool that can ingest, blend, and transform Workday data with any other external sources of data to produce Prism source data. With the help of Prism Data Analysis, the data from the data hub can be streamlined to produce Workday reports, dashboards, or scoreboards which helps in giving a holistic view of the business operations, pain areas to be addressed, and financial growth.

To understand the functionality better, let’s dive into the process flow and data acquisition,


Workday Prism Data sources

The terminology Prism datasets are none other than the central location or data hub where users can access and create Prism datasets. The Prism Datasets store internal data from both Workday and external systems. Technically to answer the question, ‘What is Prism?’ A Prism object is linked with raw source data and/or the processing is defined on it.

Prism Reporting Steps

Workday Prism Analytics a functional area that has several security domains that permits access to the Data Catalog for performing tasks such as creating datasets and publishing Prism data sources. The access configuration to these domains allows the Prism data analysts and Prism data administrators to perform needed responsibilities in Prism.



A tool that enables the user to ingest, blend and transform the Workday data with the various external sources and gives the Prism data source as output is the Workday Prism analytics. This enables the business decision-makers, stakeholders, and leaders to give a significant holistic picture of the business through its insights which helps in understanding the right and next move.


Based on the reporting required, the external data is identified that’s imported into the Data Catalog through methods like sFTP, REST API, or from a Workday custom report becomes the base dataset that’s used as a source of all future transformations. While using an external system to export data, the user has to make sure the file is saved as a CSV file, and saving it as an XLSX file leads to the loss of special characters.


A table is a Workday Prism Analytics object that stores (materializes) data and represents it in a tabular format. A table is one that has a user-defined schema and has data that's valid against the schema. A dataset is a description of the data, called metadata. Datasets can be created by the trainees to prepare data for analysis. Field type attributes are specific to each table and dataset field. The field type is nonetheless referred to as a data type in other data applications.

Understanding the creation of datasets and the various lists of transformation stages, the usage of Manage fields for modifying existing field types for future joins and transformations, and adding prism-calculated fields for transforming and deriving new columns of data are essential for the trainees who can use them to work by creating and importing an existing dataset.


Transformation stages involve joins and unions that blend datasets together into a single dataset. Trainees can use worker, agent, ticket data, and various survey data for the transformation stages. Transformation stages can also reduce the number of rows in the datasets based on the conditions by implementing Filters and Group by. The filter stage acts on the rows based on the conditions specified. The aggregation of data in a dataset by the groups specified using the GROUP BY function. This function accepts detailed data and returns aggregated data. Basic or advanced levels can be used for Prism expression language. Filter conditions impact the number of rows, not the columns. The available aggregate functions include Average, Count, Max, Min, and Sum.


Once the transformation is done on the dataset as per the requirements, the user can publish the dataset to a Prism data source for the Workday Report. Reports, scorecards, and dashboards are the sources of visual representation for the benefit of analysts performing visual analytics. Publishing can be scheduled based on need.

Business executives, Account Managers, stakeholders, and other decision-makers across the business rely on information to arrive at a decision. The information comes from channels like CRM, vendor management, Leave Management systems, engagement, or industry-specific systems, but this doesn't give a clear picture of their business. Workday does it through its reporting tool to bring all that data together with integration and data management capabilities. The user manages and transforms the data at the transformation stage for reporting, viewing insights, and data lineage capabilities without any coding.


Data discovery is a tool that allows users to perform ad hoc analysis on Prism data sources in order to create visual analytics using discovery boards, which can then be exported and saved as Workday custom reports for future reference.

Visualization is a graphical representation of certain fields selected from a data source, including column charts, line charts, tables, and more. Trainees learn to use vizzes for exploring and analyzing the data. Trainees can use the same data or different data for multiple vizzes on a sheet.


Maintenance of Prism data includes scheduling dataset publishing, unpublishing and deleting datasets when they are no longer in use, Prism management, troubleshooting, and creating a Prism Administration dashboard for managing your datasets and Prism reports.

The key benefits of Workday Prism analytics and Prism reporting include,

  • A secured and fidelity-driven system that keeps the financial and other important organizational data intact
  • Streamlines the various data from the Workday Prism data warehouse and provides a unified and holistic analytic view.
  • The intuitive tool manages large-scale datasets with an in-memory high-performance analytics engine.
  • Workday Prism Analytics and Workday Reporting is fully cloud-based, can manage heavy lifting to maintain software updates, and is available on mobiles, or laptops.

From the above key benefits, it is absolutely clear that for any organization, Workday Prism Analytics is a game changer.


Workday Prism Analytics offers training on Tenant for Prism Data and Discovery Boards. This training guides you to create, edit, secure and prepare Prism Analytics Data and to discover board concepts and visualization. The curriculum is extensive with design and configuration in Workday in addition to end-user training. It is highly beneficial for Workday aspirants who are ready to take their careers to the next level. There are no prerequisites for the course, anyone with Basic English is enough to take the course. Once you complete this course you could become a Workday Analytics Analyst, Workday HR Analyst, Workday Business Data Analyst, Workday Technical Lead, Workday Report Writer, Workday Reporting Analyst, Workday Reporting Developer, Workday HR Operations Analyst or Workday Financials Reporting Developer

We provide Job Support for a lifetime, and placement without interviews on internal, external, and full-time jobs billed at 150-450 dollars per hour. Workday Certification will be provided by partners/clients after placement. Our courses are curated for the job market, and we are the only institute offering workday training. Enroll now and become a Workday expert today

Categories: Workday prism