12.4 Discovery Boards, Dashboards & Prism Analytics Integration

12.4 Discovery Boards, Dashboards & Prism Analytics Integration

Quick Answer: Beyond static reports, Workday delivers an enterprise analytical ecosystem encompassing Dashboards, Discovery Boards, and Prism Analytics. Custom reports are secured through the Share tab (defaulting to private) and can be scheduled to deliver outputs to W-Drive or email. Alerts run custom reports on scheduled intervals to trigger real-time notifications when operational thresholds are breached. For interactive exploration, Discovery Boards provide a drag-and-drop visual canvas for ad-hoc multidimensional analysis directly on live data. For enterprise-wide data blending, Prism Analytics ingests external third-party data (e.g., Salesforce, badge readers), transforms it through data pipelines, and publishes it as native Workday Data Sources that blend seamlessly with core HCM records.

---

Custom Report Security, Sharing Models & Governance

When a custom report is created, it is subject to strict governance protocols that balance self-service analytics with sensitive workforce data protection.

The Three Sharing Options

On the Share tab of any custom report, the author defines user access:

1. Do Not Share (Private): The default configuration. Only the report author and administrative users with the Report Administrator security domain can view, edit, or run the report.
2. Share with specific authorized groups and users: Restricts report execution to designated security groups (e.g., HR Partners, Compensation Administrators) or specific named workers. Users must still possess domain security permissions to see the underlying data fields.
3. Share with all authorized users (Public): Makes the report accessible to any user in the tenant who possesses functional security access to the report's underlying data source and fields.

+-----------------------------------------------------------------------------------------+
|                                REPORT SHARING OPTIONS                                   |
+-----------------------------------------------------------------------------------------+
|  [X] Do Not Share (Private to Author)                                                   |
|  [ ] Share with specific authorized groups and users (Role/User-Based Security Groups)  |
|  [ ] Share with all authorized users (Public across tenant subject to domain security)  |
+-----------------------------------------------------------------------------------------+

Report Ownership & Transfer of Ownership

Every custom report has a single Owner (initially the author). If the report owner leaves the organization or transitions roles, other administrators cannot modify the report definition unless they possess elevated system permissions. Organizations manage this using the Transfer Ownership of Custom Reports task, reassigning report maintenance to active administrators or Integration System Users (ISUs).

---

Scheduling Reports & Operational Alerts

To automate recurring business processes and prevent system bottlenecks during peak business hours, Workday provides robust scheduling and alerting frameworks.

Scheduling Custom Reports (Schedule a Report Task)

Reports that evaluate massive populations or generate extensive calculation trees can be offloaded to run asynchronously in the background:

• Frequency: Can run Now in Background, Once in the Future, or on recurring schedules (Daily, Weekly, Monthly, Quarterly).
• Output Formats: Excel (.xlsx), CSV, PDF, XML.
• Delivery Mechanisms: Output files can be stored in the user's encrypted Workday Drive (W-Drive), sent as notifications, or delivered via email.

Critical Security Warning (Exam Trap): When a scheduled report delivers an Excel spreadsheet or PDF as a direct email attachment, the recipient receives static data evaluated under the scheduled runner's security context. This completely bypasses the recipient's personal security permissions! To prevent data breaches, organizations should schedule outputs to deliver secure W-Drive links or ensure recipient-level security re-evaluation is strictly enforced.

Automated Alerts Driven by Custom Reports

Workday Alerts transform passive reports into proactive, event-driven monitors. Administrators configure alerts via the Create Alert task:

1. Underlying Report: The alert evaluates an Advanced custom report on a scheduled cadence (e.g., daily at 6:00 AM).
2. Trigger Criteria: The report identifies instances meeting an operational condition requiring attention (e.g., workers with visas expiring in 60 days, probation periods concluding in 14 days, or open requisitions vacant for > 90 days).
3. Recipient Routing: When qualifying rows appear in the report output, the alert engine dynamically dispatches notifications (via Workday Inbox notifications, push alerts, or emails) to designated roles (e.g., the worker's Manager, HR Partner, or Recruiter).

---

Dashboards, Book Dashboards & Worklets

Workday's landing experience organizes analytical metrics and operational tasks into modular user interface components.

Worklets as Modular Tiles

A Worklet is a compact, self-contained application tile displayed on a user's Home page or within a Dashboard. Worklets are categorized into:

• Report Worklets: Display an embedded chart, matrix summary, or table generated directly from a custom report.
• Task Worklets: Provide direct navigation links to frequently executed operational tasks.
• External Worklets: Link securely to third-party portals or corporate intranet pages.

Role-Based Dashboards (Maintain Dashboards Task)

A Dashboard is a dedicated landing page grouping multiple related worklets, reports, and analytical charts focused on a specific business domain (e.g., Executive Workforce Dashboard, Talent & Performance Dashboard, Open Enrollment Dashboard).

• Security Assignment: Dashboards are governed by domain security policies and are provisioned automatically to workers based on role assignments (such as HR Business Partners or Executive Leaders).
• Book Dashboards: Advanced analytical suites that group multiple related dashboards into a tabbed, book-style container. Executive users can click across tabs (e.g., Tab 1: Headcount; Tab 2: Retention; Tab 3: Diversity & Equity) without leaving the dashboard workspace.

---

Discovery Boards: Ad-Hoc Visual Exploration

While the Report Writer requires pre-defining rows, columns, and filters, Discovery Boards provide an agile, drag-and-drop ad-hoc visual analytics canvas natively embedded inside Workday.

+-----------------------------------------------------------------------------------------+
|                                 DISCOVERY BOARD CANVAS                                  |
+-----------------------------------------------------------------------------------------+
|  DATA PANEL            VISUALIZATION STAGE                     PROPERTIES PANEL         |
|  (Data Source / BO)    +------------------------------------+  (Chart Config)           |
|  - Worker Type [Dim]   |   [ Bar Chart / Pivot View ]       |  Chart Type: Stacked Bar  |
|  - Cost Center [Dim]   |                                    |  Color Palette: Corporate |
|  - Headcount [Meas]    |   Drag fields into Rows, Columns,  |  Sort: Value Descending   |
|  - Base Salary [Meas]  |   and Color Shelves                |  Legend: Display Top      |
+------------------------+------------------------------------+---------------------------+

Discovery Board Mechanics & Architecture

• Live Operational Querying: Discovery Boards query the in-memory object database directly in real time. They do not require a separate data cube or external BI extraction.
• Measures and Dimensions: Data fields are classified into Dimensions (categorical attributes such as Location, Department, Gender, Job Family) and Measures (numerical values such as Headcount, Base Salary, FTE, Service Years).
• Visual Stage Shelves: Analysts drag dimensions and measures onto shelves (Columns, Rows, Color, Size, Filters) to instantaneously generate visualizations.
• Supported Visualizations: Stacked bar charts, grouped column charts, scatter plots, dual-axis line charts, heatmaps, waterfall charts, bubble charts, and multidimensional pivot grids.
• Collaboration: Discovery Boards can be saved, shared with specific security groups, exported to PDF/PowerPoint, or pinned directly onto executive Dashboards.

---

Workday Prism Analytics: Enterprise Data Blending

While Report Writer and Discovery Boards analyze operational data residing inside the Workday tenant, organizations frequently need to correlate HR data with external enterprise systems. Workday Prism Analytics is the native data warehouse and data blending platform embedded directly within the Workday architecture.

+---------------------------------------------------------------------------------------+
|                               EXTERNAL DATA SOURCES                                   |
|   Salesforce CRM (Quotas)  |  ServiceNow (Tickets)  |  Badge Reader (Building Access) |
+---------------------------------------------------------------------------------------+
                                           |
                                           | Ingestion (SFTP / REST API / S3)
                                           v
+---------------------------------------------------------------------------------------+
|                                WORKDAY PRISM ANALYTICS                                |
|  +---------------------------------------------------------------------------------+  |
|  | 1. DATA CATALOG: Raw external tables ingested into encrypted big-data storage   |  |
|  | 2. DATA PIPELINE: Data preparation (Joins, Unions, Field Conversions, Filters)  |  |
|  | 3. PRISM DATA SET: Cleansed, transformed target table                          |  |
|  +---------------------------------------------------------------------------------+  |
+------------------------------------------|--------------------------------------------+
                                           | Publish as Data Source
                                           v
+---------------------------------------------------------------------------------------+
|                                 CORE WORKDAY REPORTING                                |
|  - Custom Reports (Advanced, Matrix) query Prism Data Sources alongside HCM data      |
|  - Discovery Boards visualize blended metrics (e.g., Sales Revenue per HR Headcount) |
|  - Governed by Workday Role-Based Security Policies                                   |
+---------------------------------------------------------------------------------------+

Prism Analytics Architecture & Data Lifecycle

1. Data Ingestion: External data files (CSV, JSON, Parquet) are ingested into Workday via secure SFTP drop-points, REST APIs, or Amazon S3 connectors.
2. Data Catalog & Tables: Ingested files are registered as raw tables within the Data Catalog, encrypted under the tenant's master security keys.
3. Data Pipelines & Transformations: Analysts build visual Data Pipelines that cleanse, transform, and join external records with core Workday data. Pipeline stages include:
   • Joins & Unions: Merging external sales performance records with Workday worker IDs.
   • Calculated Fields & Filtering: Applying business logic and trimming extraneous columns.
   • Aggregation: Rolling up transactional ticket logs into monthly departmental sums.
4. Prism Data Sets: The pipeline outputs an optimized Prism Data Set.
5. Publishing as a Data Source: The defining architectural capability of Prism is that the resulting dataset can be published as a native Workday Data Source. Once published, it behaves exactly like a standard Workday data source: it can be queried using Advanced Reports, Matrix Reports, and Discovery Boards, fully governed by Workday domain and row-level security.

HCM & External Data Blending Use Cases

• Sales Performance vs. Compensation: Blending Salesforce quota attainment data with Workday HCM salary, bonus, and management level to evaluate pay-for-performance equity.
• Workplace Presence vs. Productivity: Combining electronic badge swipe entry timestamps with employee work schedules and engagement surveys to analyze hybrid work patterns.
• IT Service Desk Efficiency: Correlating ServiceNow ticket resolution velocities with IT staff training history, certifications, and tenure.

---

Comparison: Custom Reports vs. Discovery Boards vs. Prism Analytics

---

Certification Pitfalls & Common Exam Traps

1. Scheduled Report Security Leakage: Exam questions regularly test the security implications of scheduling reports. When a report is scheduled and emailed directly as an attachment, it executes under the scheduler's security context, and recipients see all data in the attachment regardless of their personal permissions. To maintain data security, distribute output via W-Drive links.
2. Alert Trigger Misunderstandings: Workday alerts do not execute continuous real-time socket listeners; they evaluate custom reports on a configured schedule (e.g., hourly, daily). If a question asks how an alert detects an expiring contract, the answer involves an Advanced Report that queries expiring contracts run on a recurring schedule.
3. Discovery Boards vs. Prism Analytics: When an exam item asks for the fastest way for an HR Partner to visually analyze internal attrition patterns using drag-and-drop charts without data conversion, the answer is Discovery Boards. If the scenario requires importing external customer satisfaction scores from an external CRM system to compare against worker performance, the required solution is Prism Analytics.
4. Transferring Report Ownership: If an administrator leaves the organization and their custom reports must be maintained by an active team member, the task to execute is Transfer Ownership of Custom Reports, not recreating the reports from scratch.