peopletechguide.com

Tag: workday reporting tips

  • Workday Reports: Advanced vs. Matrix vs. Composite Guide

    You open a reporting request from your CFO:

    “I need headcount by department, broken down by location and job level, with month-over-month trends and turnover rates.”

    You stare at the request. Should you build an Advanced Report? A Matrix Report? A Composite Report? Or maybe three separate reports?

    This is where most Workday professionals get stuck. They know how to build reports technically, but they don’t know which report type to use when. So they default to Advanced Reports for everything, then spend hours manipulating data in Excel to get the view they actually need.

    Here’s the truth: choosing the wrong report type doesn’t just waste time. It creates slow, unmaintainable reports that confuse users and break during updates.

    This guide teaches you how to choose the right report type for every scenario. You’ll learn what each report type does, when to use it, and how to build it correctly with real-world examples.

    The Three Report Types: What They Actually Do

    Advanced Reports: The List Builder

    What It Is:
    An Advanced Report displays data from a single business object as a list of rows. Think of it as a detailed table where each row represents one record.

    Structure:

    • One row per record (employee, position, transaction, event)
    • Multiple columns showing different fields
    • Can include filters, prompts, sorting, and grouping
    • Can include subtotals and aggregations

    Visual Example:

    Employee NameHire DateDepartmentLocationJob TitleAnnual Salary
    Sarah Johnson2022-03-15EngineeringSan FranciscoSenior Engineer$125,000
    Mike Chen2023-01-10SalesNew YorkAccount Executive$95,000
    Emily Davis2021-06-20HRChicagoHR Business Partner$105,000

    Best For:

    • Employee lists (active headcount, new hires, terminations)
    • Transaction logs (compensation changes, job changes, time off)
    • Detailed records for audits, integrations, or EIB loads
    • Reports that answer: “Show me all [records] where [criteria]”

    Not Good For:

    • Pivoting data across multiple dimensions
    • Showing trends over time periods
    • Combining data from multiple business objects

    Matrix Reports: The Pivot Table

    What It Is:
    A Matrix Report summarizes numeric data across rows and columns. It’s Workday’s version of an Excel pivot table or crosstab.

    Structure:

    • Rows define one dimension (e.g., Department)
    • Columns define another dimension (e.g., Location or Time Period)
    • Cells show aggregated metrics (count, sum, average)
    • Interactive drilling (click to see detail records)

    Visual Example:

    Headcount by Department and Location

    DepartmentSan FranciscoNew YorkChicagoTotal
    Engineering4512865
    Sales10381563
    HR581225
    Total605835153

    Best For:

    • Summarizing data across two dimensions
    • Headcount analysis (by org, location, job level)
    • Trend analysis over time (monthly, quarterly, yearly)
    • Financial rollups (cost by department and account)
    • Reports that answer: “Show me [metric] broken down by [dimension 1] and [dimension 2]”

    Not Good For:

    • Showing raw transaction details
    • Combining multiple unrelated metrics
    • Reports with more than two grouping dimensions

    Composite Reports: The Dashboard Builder

    What It Is:
    A Composite Report combines multiple Matrix Reports into a single unified report. It’s how you build executive dashboards and scorecards.

    Structure:

    • Multiple sub-reports (each is a Matrix Report)
    • Each sub-report can have different data sources
    • Aligned by common dimension (department, location, time period)
    • Metrics calculated across sub-reports at the composite level

    Visual Example:

    HR Scorecard by Department

    Sub-Report 1: Headcount Trend

    DepartmentJan 2025Feb 2025Mar 2025
    Engineering606365
    Sales586163

    Sub-Report 2: New Hires

    DepartmentJan 2025Feb 2025Mar 2025
    Engineering543
    Sales354

    Sub-Report 3: Terminations

    DepartmentJan 2025Feb 2025Mar 2025
    Engineering211
    Sales022

    Composite Calculation: Turnover Rate

    DepartmentJan 2025Feb 2025Mar 2025
    Engineering3.3%1.6%1.5%
    Sales0%3.3%3.2%

    Best For:

    • Executive dashboards (HR scorecard, Finance KPIs)
    • Multi-metric analysis aligned by common dimension
    • Combining HCM + Finance data
    • Reports that answer: “Show me 4-5 related metrics side-by-side”

    Not Good For:

    • Simple lists or single-metric analysis
    • Ad-hoc analysis (too complex for quick requests)
    • Reports without a common aligning dimension

    Decision Framework: Which Report Type Should I Use?

    Use this flowchart to decide:

    Question 1: Do I need multiple related metrics from different data sources?

    • Yes → Use Composite Report
    • No → Go to Question 2

    Question 2: Do I need to aggregate/summarize data across dimensions?

    • Yes → Use Matrix Report
    • No → Go to Question 3

    Question 3: Do I need a detailed list of records?

    • Yes → Use Advanced Report

    Real-World Scenario Examples

    Scenario 1: “Show me all employees who were hired in the last 90 days”

    Report Type: Advanced Report

    Why: You need a list of individual employee records. No aggregation needed.

    Data Source: Workers

    Columns: Employee Name, Employee ID, Hire Date, Department, Manager, Location

    Filter: Hire Date is within the last 90 days

    Scenario 2: “Show me headcount by department and location”

    Report Type: Matrix Report

    Why: You need to aggregate (count employees) across two dimensions (department and location).

    Data Source: Workers

    Rows: Department (grouping)

    Columns: Location (grouping)

    Measure: Count of Workers

    Scenario 3: “Show me monthly headcount, new hires, terminations, and turnover rate by department”

    Report Type: Composite Report

    Why: You need multiple related metrics (4 different calculations) aligned by common dimensions (department and month).

    Sub-Report 1 (Matrix): Headcount by Department and Month

    Sub-Report 2 (Matrix): New Hires by Department and Month

    Sub-Report 3 (Matrix): Terminations by Department and Month

    Composite Calculation: Turnover Rate = (Terminations ÷ Average Headcount) × 100

    Building Your First Advanced Report

    Let’s build a practical Advanced Report: New Hires in Last 90 Days

    Step 1: Create the Report

    1. Search for Create Custom Report
    2. Report Type: Advanced
    3. Data Source: Workers
    4. Report Name: New Hires – Last 90 Days
    5. Click OK

    Step 2: Add Columns

    Click Add in the Columns section to add fields:

    Column 1: Worker (displays employee name)

    Column 2: Employee ID

    Column 3: Hire Date

    Column 4: Primary Position

    Column 5: Worker’s Manager (manager name)

    Column 6: Location

    Column 7: Cost Center

    Column 8: Time Type (Full-Time, Part-Time)

    Pro Tip: Rename column labels for clarity. “Worker” → “Employee Name”, “Worker’s Manager” → “Manager”

    Step 3: Add Filter

    Click Filter tab.

    Filter Condition: Hire Date is within the last 90 days

    Configuration:

    • Field: Hire Date
    • Operator: Is Within
    • Value: Last 90 days (Workday calculates dynamically)

    Alternative: Use Prompt instead of hard-coded filter to let users choose the date range at runtime.

    Step 4: Add Sorting

    Click Sort tab.

    Primary Sort: Hire Date (descending – newest hires first)

    Secondary Sort: Worker (ascending – alphabetical within same hire date)

    Step 5: Add Grouping (Optional)

    Click Sort tab, scroll to Grouping.

    Group By: Department

    This groups all new hires by their department, with subtotals showing count per department.

    Enable: Summarize Detail Rows (checkbox)

    Result: Report shows:

    • Engineering: 12 new hires
      • Sarah Johnson – 2025-03-15
      • Mike Chen – 2025-03-10
      • …
    • Sales: 8 new hires
      • Emily Davis – 2025-03-20
      • …

    Step 6: Test and Share

    Click OK to save and run the report.

    Validate:

    • Do all employees shown have hire dates within last 90 days?
    • Are columns displaying correctly?
    • Is sorting working as expected?

    Share the Report:

    1. Click Share icon
    2. Select users or security groups
    3. Grant View permission
    4. Save

    Building Your First Matrix Report

    Let’s build: Headcount by Department and Location

    Step 1: Create the Report

    1. Search for Create Custom Report
    2. Report Type: Matrix
    3. Data Source: Workers
    4. Report Name: Headcount by Department and Location
    5. Click OK

    Step 2: Configure Rows

    Rows Axis: Department (Supervisory Organization)

    This defines what appears down the left side of your matrix.

    Row Field: Organization > Name (displays department names)

    Sort: Ascending (alphabetical order)

    Step 3: Configure Columns

    Columns Axis: Location

    This defines what appears across the top of your matrix.

    Column Field: Location > Name (displays location names like “San Francisco”, “New York”)

    Sort: Ascending (alphabetical order)

    Step 4: Configure Measure

    Measure: What you’re counting or summing in each cell.

    Metric: Count of Workers

    Aggregation Method: Count (default for counting records)

    Alternative measures:

    • Sum of Annual Salary (for compensation analysis)
    • Average of Tenure (for tenure analysis)

    Step 5: Add Filter (Optional)

    Click Filter tab.

    Filter: Worker Status = Active

    This excludes terminated employees from the headcount.

    Step 6: Enable Drilling

    Drilling lets users click a cell to see the detail records.

    Configuration: Enabled by default in Matrix Reports

    How It Works:
    User clicks cell showing “45 employees in Engineering – San Francisco”
    → Workday displays list of those 45 employees with details

    Step 7: Add Prompts (Optional)

    Prompts let users filter the report at runtime.

    Add Prompt: As of Date

    Use Case: Users can run the report “as of December 31, 2024” to see historical headcount.

    Configuration:

    1. Click Prompts tab
    2. Add As of Date prompt
    3. Default value: Today (report defaults to current headcount)
    4. Users can override to see historical data

    Step 8: Test and Visualize

    Click OK to save and run.

    Validate:

    • Do row totals match expected headcount per department?
    • Do column totals match expected headcount per location?
    • Does grand total match total active headcount?

    Add Chart Visualization:

    1. Click Add Chart
    2. Chart Type: Stacked Bar Chart
    3. X-Axis: Department
    4. Y-Axis: Headcount
    5. Stack By: Location (different colors for each location)

    Result: Visual chart showing headcount distribution across departments and locations.

    Building Your First Composite Report

    Let’s build: HR Monthly Scorecard (Headcount, Hires, Terms, Turnover)

    Step 1: Build the Matrix Sub-Reports First

    You need to create each Matrix Report separately before combining them.

    Sub-Report 1: Monthly Headcount by Department

    1. Create Matrix Report
    2. Data Source: Workers (Snapshot-based for historical data)
    3. Rows: Department
    4. Columns: Month (from Period Reporting Calendar)
    5. Measure: Count of Workers
    6. Filter: Worker Status = Active (at snapshot date)
    7. Save As: Headcount by Department – Monthly

    Sub-Report 2: New Hires by Department and Month

    1. Create Matrix Report
    2. Data Source: Hire Employee Event
    3. Rows: Position > Organization (Department)
    4. Columns: Event Date > Month
    5. Measure: Count of Events
    6. Save As: New Hires by Department – Monthly

    Sub-Report 3: Terminations by Department and Month

    1. Create Matrix Report
    2. Data Source: Terminate Employee Event
    3. Rows: Position > Organization (Department)
    4. Columns: Event Date > Month
    5. Measure: Count of Events
    6. Save As: Terminations by Department – Monthly

    Step 2: Create the Composite Report

    1. Search for Create Custom Report
    2. Report Type: Composite
    3. Report Name: HR Monthly Scorecard
    4. Click OK

    Step 3: Add Sub-Reports

    Click Add Sub-Report for each Matrix Report you created.

    Sub-Report 1: Headcount by Department – Monthly

    Sub-Report 2: New Hires by Department – Monthly

    Sub-Report 3: Terminations by Department – Monthly

    Step 4: Align Sub-Reports

    Alignment ensures data from different sub-reports lines up correctly.

    Align By:

    • Rows: Department (common dimension across all sub-reports)
    • Columns: Month (common time dimension)

    Result: All three metrics display side-by-side for each department and month.

    Step 5: Add Composite Calculations

    Composite Calculations perform math across sub-reports.

    Calculation: Turnover Rate

    Formula: (Terminations ÷ Average Headcount) × 100

    Configuration:

    1. Click Add Calculation
    2. Calculation Name: Turnover Rate
    3. Formula Type: Custom
    4. Formula:text(Sub-Report[Terminations].Measure / ((Sub-Report[Headcount].Measure + Sub-Report[Headcount].Measure.PriorPeriod) / 2)) * 100

    What This Does:

    • Divides terminations by average headcount (current month + prior month ÷ 2)
    • Multiplies by 100 to get percentage
    • Displays as new row in the composite report

    Calculation: Net Headcount Change

    Formula: Hires – Terminations

    Configuration:

    textSub-Report[New Hires].Measure - Sub-Report[Terminations].Measure

    Step 6: Format the Report

    Add Section Headers:

    • Section 1: Headcount Metrics
    • Section 2: Movement Metrics
    • Section 3: Turnover Analysis

    Conditional Formatting:

    • Turnover Rate > 5%: Red (concerning)
    • Turnover Rate 3-5%: Yellow (monitor)
    • Turnover Rate < 3%: Green (healthy)

    Number Formatting:

    • Headcount: Whole numbers (no decimals)
    • Turnover Rate: One decimal place with % symbol (e.g., 3.2%)

    Step 7: Test and Validate

    Run the composite report.

    Validation Checks:

    • Do headcount numbers match your HRIS records?
    • Do new hires + terminations align with HR transaction logs?
    • Does turnover calculation make sense? (formula working correctly?)
    • Are all departments showing data? (check for alignment issues)

    Common Issues:

    • Misaligned departments: Sub-reports use different organization hierarchies. Standardize to Supervisory Organizations.
    • Missing time periods: One sub-report has data for January, another doesn’t. Add zero-value handling.

    Advanced Techniques: Calculated Fields

    Calculated Fields let you create custom formulas and logic within reports.

    When to Use Calculated Fields

    Scenario 1: Custom Tenure Calculation

    Need: Show employee tenure in “Years.Months” format (e.g., 3.5 years = 3 years, 6 months)

    Advanced Report Column: Tenure (Calculated Field)

    Formula:

    textDATEDIFF(Hire Date, Today, "years") + "." + MOD(DATEDIFF(Hire Date, Today, "months"), 12)

    Result: Employee hired March 1, 2022 shows “3.9” (3 years, 9 months as of Dec 2025)

    Scenario 2: Compensation Ratio (Compa-Ratio)

    Need: Compare employee salary to midpoint of their pay grade

    Matrix Report Measure: Compa-Ratio (Calculated Field)

    Formula:

    text(Annual Salary / Compensation Grade Midpoint) * 100

    Result: Employee earning $90K in grade with $100K midpoint shows 90% (below midpoint)

    Scenario 3: Conditional Text Labels

    Need: Tag employees as “New Hire”, “Tenured”, or “Long-Term” based on tenure

    Advanced Report Column: Tenure Category (Calculated Field)

    Formula:

    textIF(Tenure < 1, "New Hire",
   IF(Tenure >= 1 AND Tenure < 5, "Tenured",
      "Long-Term"))

    Result:

    • Employee with 6 months tenure: “New Hire”
    • Employee with 3 years tenure: “Tenured”
    • Employee with 8 years tenure: “Long-Term”

    Creating a Calculated Field

    1. From your Custom Report editor, click Columns tab
    2. Click Add > Calculated Field
    3. Field Name: Tenure Category
    4. Field Type: Text (or Number, Date, depending on formula output)
    5. Formula: Enter your formula using Workday formula syntax
    6. Available Functions:
      • DATEDIFF (date arithmetic)
      • IF/THEN/ELSE (conditional logic)
      • SUM, AVG, COUNT (aggregations – Matrix only)
      • CONCAT (text concatenation)
      • ROUND, CEILING, FLOOR (number formatting)
    7. Click Validate to check formula syntax
    8. Click OK to save

    Report Performance Optimization

    Why Report Performance Matters

    Slow reports frustrate users, time out during scheduled runs, and consume system resources.

    Performance Best Practices

    1. Filter Early, Filter Often

    Bad: Pull all 50,000 workers, then filter in Excel

    Good: Filter to active workers in last 6 months (reduces dataset to 2,000 records)

    How:

    • Add Worker Status = Active filter
    • Add date range filters (Hire Date, As of Date)
    • Use Prompts to let users narrow scope

    2. Limit Columns in Advanced Reports

    Bad: Include 40 fields “just in case”

    Good: Include only fields users actually need (10-15 columns max)

    Why: Each column adds processing time and data retrieval overhead.

    3. Use Summarize Detail Rows in Advanced Reports

    Scenario: You need totals by department, not every individual employee.

    Solution: Enable Summarize Detail Rows in Sort tab

    Result: Report aggregates data automatically (like a Matrix), runs faster than full detail list.

    4. Avoid Cross-Business Object Relationships When Possible

    Bad: Advanced Report pulling from Workers + Positions + Compensation + Benefits (4 objects)

    Good: Use Matrix Report with single business object, or Composite to separate concerns

    Why: Cross-object joins slow down queries significantly.

    5. Schedule Large Reports to Run Off-Hours

    Scenario: Monthly headcount report with 3 years of historical data (slow)

    Solution:

    1. Navigate to Edit Custom Report
    2. Configure Schedule
    3. Run at 2:00 AM when system load is low
    4. Deliver via email or save to shared folder

    6. Use Data Sources Wisely

    For Historical Trending: Use Snapshot-based Data Sources (Workers – Snapshot) instead of live Workers object

    Why: Snapshots are pre-aggregated and optimized for time-series analysis.

    Common Mistakes and How to Avoid Them

    Mistake 1: Using Advanced Report When Matrix Is Better

    Scenario: Request is “Show me headcount by department”

    What People Do: Build Advanced Report listing all employees, export to Excel, create pivot table

    What They Should Do: Build Matrix Report with Department as Row, Count of Workers as Measure

    Impact: 10 minutes in Excel becomes 30 seconds in Workday.

    Mistake 2: Too Many Calculated Fields in One Report

    Problem: Report has 15 calculated fields with nested IF statements and cross-field references.

    Impact: Report takes 5 minutes to run, times out in production.

    Solution:

    • Move complex calculations to Business Object Calculated Fields (reusable across reports)
    • Simplify formulas (break complex logic into multiple simpler fields)
    • Use Composite Reports to separate calculations across sub-reports

    Mistake 3: Not Sharing Reports with Appropriate Security

    Problem: You built a great report, but users can’t find it or don’t have permission to run it.

    Solution:

    • Share report with Security Groups (not individual users)
    • Grant appropriate permissions:
      • View: Users can run and view results
      • Modify: Users can edit the report definition (usually admins only)
    • Add report to relevant Dashboard or Report Category for discoverability

    Mistake 4: Hard-Coding Filters Instead of Using Prompts

    Problem: Report filters to “Hire Date between Jan 1, 2025 and March 31, 2025” (hard-coded)

    Impact: Report is useful for Q1 2025 only. Next quarter, you have to edit and update the report.

    Solution: Use Prompts

    • Add Start Date prompt
    • Add End Date prompt
    • Users can run report for any date range without editing definition

    Mistake 5: No Testing with Large Data Sets

    Problem: Report works great in test tenant with 100 employees. In production with 50,000 employees, it times out.

    Solution:

    • Test in Sandbox with production-like data volumes
    • Run performance checks before deploying
    • Add filters to limit data scope if needed

    Real-World Report Examples

    Example 1: Compensation Analysis Report (Advanced)

    Business Need: HR needs list of all employees with compensation below market midpoint for their pay grade.

    Report Type: Advanced Report

    Data Source: Workers

    Columns:

    • Employee Name
    • Employee ID
    • Job Profile
    • Compensation Grade
    • Annual Salary
    • Compensation Grade Midpoint (reference field)
    • Compa-Ratio (calculated: Salary ÷ Midpoint × 100)
    • Variance from Midpoint (calculated: Salary – Midpoint)

    Filter:

    • Worker Status = Active
    • Compa-Ratio < 90% (below market)

    Sorting: Compa-Ratio ascending (lowest paid first)

    Use Case: Annual compensation review to identify underpaid employees.

    Example 2: Termination Trend Analysis (Matrix)

    Business Need: Leadership wants to see termination trends over the past 12 months by department.

    Report Type: Matrix Report

    Data Source: Terminate Employee Event

    Rows: Organization (Department)

    Columns: Event Date > Month

    Measure: Count of Terminations

    Filter: Event Date is within the last 12 months

    Chart: Line chart showing termination trend by department

    Use Case: Monthly leadership review to identify retention issues.

    Example 3: Executive HR Dashboard (Composite)

    Business Need: CEO wants single-page HR scorecard showing headcount, hiring, turnover, and diversity metrics.

    Report Type: Composite Report

    Sub-Reports:

    1. Headcount Trend (Matrix)

    • Rows: Time Period (Month)
    • Measure: Count of Active Workers

    2. Hiring by Source (Matrix)

    • Rows: Recruiting Source
    • Measure: Count of Hires

    3. Turnover Rate (Matrix)

    • Rows: Department
    • Columns: Month
    • Measure: Termination Count
    • Composite Calculation: Turnover % = (Terms ÷ Avg Headcount) × 100

    4. Diversity Metrics (Matrix)

    • Rows: Gender
    • Columns: Job Level
    • Measure: Count of Workers

    Alignment: By Time Period (Month)

    Use Case: Monthly executive briefing, CEO board presentation.

    Your Report Type Cheat Sheet

    QuestionReport TypeExample
    Need a list of individual records?Advanced“Show me all new hires in Q1”
    Need to aggregate across 1-2 dimensions?Matrix“Headcount by dept and location”
    Need to combine multiple metrics?Composite“HR scorecard: headcount, hires, terms, turnover”
    Need detailed transaction history?Advanced“All compensation changes in 2024”
    Need trend analysis over time?Matrix“Monthly hiring trend by department”
    Need pivot table / crosstab?Matrix“Average salary by job level and location”
    Need executive dashboard with 4-5 KPIs?Composite“Finance scorecard: budget, actuals, variance, forecast”
    Need to export for integration/EIB?Advanced“All active workers with full demographic data”
    Need drillable interactive analysis?Matrix“Headcount by org (click to see employees)”

    What You’ve Learned

    You now understand:

    ✅ The three core Workday report types and when to use each

    ✅ How to build Advanced Reports for detailed lists and transaction logs

    ✅ How to build Matrix Reports for aggregations, pivots, and trends

    ✅ How to build Composite Reports for multi-metric dashboards

    ✅ How to use Calculated Fields for custom formulas and logic

    ✅ Performance optimization techniques to keep reports fast

    ✅ Common mistakes to avoid and best practices to follow

    The difference between a junior and senior Workday professional isn’t knowing how to build reports—it’s knowing which report type to build for each business need.

    Choose wisely. Build efficiently. Deliver insights, not just data.

  • Discovery Boards That Executives Actually Use

    I built my first Workday Discovery Board with genuine excitement.

    It had everything: KPI cards showing headcount trends, a beautiful waterfall chart displaying hiring pipeline, color-coded heat maps showing turnover by department, and interactive drill-downs into every metric.

    I spent three days perfecting it. The visualizations were stunning. The data was accurate. The interactivity was smooth.

    I shared it with the CFO.

    She opened it once. Never looked at it again.

    Two weeks later, I found her reviewing a spreadsheet someone had exported from a basic Workday report. The spreadsheet had pivot tables and ugly charts, but she used it every Monday morning.

    That is when I learned the hard lesson: Beautiful dashboards mean nothing if executives do not actually use them.

    Over the past five years, I have built Discovery Boards across dozens of Workday tenants. I have watched executives ignore gorgeous dashboards while repeatedly asking for the same basic reports via email.

    But I have also seen Discovery Boards become indispensable tools that executives check daily before their first meeting.

    The difference is not the visualization quality or the data complexity. The difference is understanding what executives actually need versus what we think they need.

    This guide will show you how to build Discovery Boards that executives actually use, based on real implementations where adoption exceeded 80%.

    Why Most Discovery Boards Fail

    Before we discuss what works, understand why most Discovery Boards fail.

    The Three Failure Patterns

    Failure Pattern 1: The Dashboard Museum

    You build a comprehensive Discovery Board with 15 sheets, 47 visualizations, and every possible metric the executive might need.

    The executive opens it once, gets overwhelmed by the sheer volume of information, and never returns.

    They go back to asking their assistant to pull specific numbers via email because it is faster than hunting through your 15-sheet dashboard.​

    Failure Pattern 2: The Beautiful But Useless Dashboard

    You create stunning visualizations with perfect color schemes, elegant transitions, and impressive interactivity.

    The executive looks at it and says: “This is beautiful. But I still cannot answer my question: Which departments are over budget on contractor spend?”

    Your dashboard shows aggregate metrics and trends. It does not answer their specific decision-making questions.

    Failure Pattern 3: The Stale Data Problem

    You build a Discovery Board that requires manual data refresh or uses data sources that update weekly.

    The executive checks it Monday morning to prepare for their leadership meeting. The data is from last Thursday. They make a comment based on your dashboard. Someone corrects them with more recent data.

    They never trust your dashboard again.

    The Root Cause

    All three failures stem from the same problem: You built the dashboard for yourself, not for the executive.

    You built what you thought was impressive. What demonstrated your Workday skills. What showcased Discovery Board capabilities.

    You did not build what the executive actually needs to make decisions on Tuesday morning.

    Understanding What Executives Actually Need

    Executives do not need dashboards. They need answers to specific recurring questions.

    The Five Executive Question Types

    Every executive question falls into one of five categories:

    Question Type 1: Status Check (“Where are we right now?”)

    Examples:

    • What is our current headcount?
    • How many open positions do we have?
    • What is our month-to-date spending versus budget?

    What they need: One number. Current state. Updated in real-time or near real-time.

    What they do NOT need: Historical trends, departmental breakdowns, year-over-year comparisons (unless they specifically ask).

    Question Type 2: Trend Detection (“Are we moving in the right direction?”)

    Examples:

    • Is turnover increasing or decreasing?
    • Are we filling positions faster or slower than last quarter?
    • Is our compensation spend trending toward budget or exceeding it?

    What they need: Simple directional indicator (up, down, flat). Trend line over relevant time period (usually last 3-6 months).

    What they do NOT need: Statistical significance tests, detailed breakdowns, multiple trend lines on the same chart.

    Question Type 3: Problem Identification (“Where are the issues?”)

    Examples:

    • Which departments have the highest turnover?
    • Which roles are hardest to fill?
    • Where are we overspending on contractors?

    What they need: Ranked list. Top 5 or top 10. Clear identification of where to focus attention.

    What they do NOT need: Complete list of all departments, roles, or cost centers. They want to know the problems, not the successes.

    Question Type 4: Comparison (“How do we compare?”)

    Examples:

    • Which department has the highest span of control?
    • How does Q4 hiring compare to Q3?
    • Which business unit is most efficient on cost per hire?

    What they need: Side-by-side comparison. Clear winner/loser identification. Context for whether the difference matters.

    What they do NOT need: Every possible comparison. Just the comparisons that drive decisions.

    Question Type 5: Deep Dive (“Tell me more about this specific thing”)

    Examples:

    • Show me everyone who terminated in Engineering last quarter.
    • Break down contractor spend by hiring manager.
    • What is driving the turnover spike in the Dallas office?

    What they need: Drill-down capability from summary to detail. Ability to filter and explore.

    What they do NOT need: This level of detail on the main dashboard. This is where interactive drill-through becomes valuable.

    The Executive Attention Span Reality

    Executives spend an average of 90 seconds on a dashboard before moving to their next task.

    If your Discovery Board cannot answer their primary question in 90 seconds, they will not use it.

    This means:

    • One primary insight per sheet (not 10 vizzes per sheet)​
    • Three to five sheets maximum (not 15 sheets)
    • Clear hierarchy of information (most important at top left)
    • Minimal scrolling (fits on one screen without vertical scroll)

    The Discovery Board Framework That Actually Works

    Here is the framework that consistently achieves 80% or higher executive adoption.

    The One-Page, Five-Number Rule

    Your Discovery Board should answer five specific questions on one visible page (no scrolling required).

    Not five categories of questions. Five actual questions the executive asks repeatedly.

    Example: CHRO Discovery Board

    Question 1: What is our current headcount?
    Visualization: KPI card showing total headcount with trend indicator​

    Question 2: Are we filling positions faster or slower?
    Visualization: KPI card showing average days to fill with month-over-month comparison

    Question 3: Which departments have the highest turnover?
    Visualization: Horizontal bar chart showing top 5 departments by turnover rate​

    Question 4: How is our diversity representation trending?
    Visualization: Line chart showing diversity percentage over last 12 months​

    Question 5: Where are we overspending on contractors?
    Visualization: Heat map showing contractor spend by department with budget comparison​

    Five numbers. One page. Answers the five questions the CHRO asks every Monday morning.

    The Three-Sheet Maximum

    If you need more than five metrics, use sheets (tabs) to organize by decision type, not by data category.​

    Sheet 1: “At a Glance”

    • Five most important metrics
    • What the executive checks first thing Monday morning
    • KPI cards and simple bar charts only

    Sheet 2: “Problem Areas”

    • Metrics highlighting issues requiring attention
    • Top 5 departments with highest turnover
    • Positions open longer than 90 days
    • Budget variances exceeding 10%

    Sheet 3: “Details” (Optional)

    • Drill-down capability for executives who want to explore
    • Interactive filters for department, location, time period
    • Detailed tables with worker-level data

    Most executives never go past Sheet 1. That is fine. Sheet 1 solves 90% of their needs.

    The Data Source Strategy

    Discovery Boards only support indexed data sources.​

    This is actually good news. It forces you to use performant data sources that load quickly.

    High-Performance Data Sources for Executive Dashboards:

    • Workers (indexed, fast)
    • Positions (indexed if Position Management enabled)
    • Organizations (indexed, fast)
    • Compensation (indexed for current compensation)
    • Recruiting (indexed for active requisitions)

    Data Sources to Avoid:

    • Worker History (not indexed, slow for large datasets)
    • All Benefit Elections (not indexed unless using current elections filter)
    • Custom data sources without indexing

    If your executive needs historical trend data, use Workday Prism Analytics for pre-aggregated data instead of pulling raw historical transactions in Discovery Boards.​

    The Refresh Strategy

    Executives need current data, not yesterday’s data.

    Real-time data sources: Workers, Positions, Organizations update in real-time in Discovery Boards. These are safe for executive dashboards.

    Daily refresh data sources: Compensation, recruiting data may have slight delays. Document this clearly: “Data refreshed daily at 2 AM.”

    Manual refresh data sources: If you are using Prism Analytics or custom data sources, document the refresh schedule prominently: “Turnover data refreshed weekly on Mondays.”

    If the executive makes a decision based on stale data and gets corrected in a meeting, they will never trust your dashboard again.

    The Mobile-First Design

    Executives check dashboards on their phones more often than on their laptops.

    This means:

    • Visualizations must be readable on mobile screens
    • KPI cards work better than complex charts
    • Horizontal bar charts work better than vertical bar charts (easier to read on narrow screens)
    • Avoid tiny fonts and detailed tables

    Test your Discovery Board on a mobile device before sharing with executives. If you cannot read it easily on your phone, they will not use it.

    The Five Discovery Boards Executives Actually Use

    Based on implementations with 80% or higher adoption, here are five Discovery Board templates that consistently succeed.

    Discovery Board 1: Executive Headcount Dashboard (CHRO/CFO)

    Primary Purpose: Answer “Where is our headcount versus budget?”

    Sheet 1: Headcount at a Glance

    Metric 1: Total Headcount

    • Visualization: KPI card​
    • Shows: Current headcount with trend indicator (up/down from last month)
    • Data source: Workers (Active Status equals Active)

    Metric 2: Open Positions

    • Visualization: KPI card
    • Shows: Count of vacant positions with availability equals available
    • Data source: Positions (if Position Management enabled) or Requisitions

    Metric 3: Headcount vs Budget

    • Visualization: KPI card showing variance
    • Shows: Current headcount minus budgeted headcount, percentage variance
    • Data source: Workers + Budget data (may require Prism if budget in external system)

    Metric 4: Headcount by Department

    • Visualization: Horizontal bar chart​
    • Shows: Top 10 departments by headcount
    • Interactivity: Click to drill into department details

    Metric 5: Hiring Pipeline

    • Visualization: Waterfall chart​
    • Shows: Requisitions by status (Approved, Interviewing, Offer Extended, etc.)
    • Data source: Requisitions

    Sheet 2: Problem Areas

    Metric 6: Positions Open Over 90 Days

    • Visualization: Table
    • Shows: Position ID, Title, Department, Days Open, Recruiter
    • Data source: Positions or Requisitions with date filter

    Metric 7: Departments Over Budget

    • Visualization: Horizontal bar chart showing variance percentage
    • Shows: Departments where actual headcount exceeds budget by more than 10%

    Usage pattern: CHRO checks Sheet 1 every Monday morning before leadership meeting. CFO checks Metric 3 (Headcount vs Budget) daily during month-end close.

    Key success factor: Budget data integration. If budget lives in external system, use Prism to bring it into Workday for comparison.​

    Discovery Board 2: Turnover Analysis Dashboard (CHRO/HR Operations)

    Primary Purpose: Answer “Where are we losing people and why?”

    Sheet 1: Turnover at a Glance

    Metric 1: Monthly Turnover Rate

    • Visualization: KPI card
    • Shows: Turnover percentage for current month with comparison to previous month
    • Calculation: (Terminations this month ÷ Average headcount this month) × 100

    Metric 2: Voluntary vs Involuntary Turnover

    • Visualization: Two KPI cards side by side
    • Shows: Voluntary turnover rate and involuntary turnover rate separately
    • Critical distinction: Executives care more about voluntary turnover

    Metric 3: Turnover Trend

    • Visualization: Line chart​
    • Shows: Monthly turnover rate over last 12 months
    • Helps answer: Are we improving or declining?

    Metric 4: Turnover by Department

    • Visualization: Horizontal bar chart
    • Shows: Top 5 departments by turnover rate (not count, rate matters)
    • Sorted: Highest to lowest

    Metric 5: Turnover by Tenure

    • Visualization: Bar chart
    • Shows: Turnover distribution by tenure bands (0-6 months, 6-12 months, 1-2 years, 2-5 years, 5+ years)
    • Insight: High turnover in 0-6 months indicates onboarding problems

    Sheet 2: Termination Details

    Metric 6: Recent Terminations

    • Visualization: Table
    • Shows: Worker Name, Job, Department, Termination Date, Termination Reason, Manager
    • Filter: Last 30 days
    • Purpose: Drill-down for executives who want specifics

    Usage pattern: CHRO checks Sheet 1 weekly. HR Ops uses Sheet 2 daily for exit interview preparation.

    Key success factor: Accurate termination reason coding. If termination reasons are inconsistent or generic, the dashboard provides no actionable insight.

    Discovery Board 3: Recruiting Efficiency Dashboard (CHRO/VP Talent Acquisition)

    Primary Purpose: Answer “How effective is our recruiting process?”

    Sheet 1: Recruiting Efficiency

    Metric 1: Average Days to Fill

    • Visualization: KPI card
    • Shows: Average days from requisition approval to hire date, with trend indicator
    • Data source: Requisitions (Status equals Filled, effective date filter for recent hires)

    Metric 2: Open Requisitions

    • Visualization: KPI card
    • Shows: Count of requisitions with status equals Open
    • Context: Shows recruiting workload

    Metric 3: Hiring Pipeline by Stage

    • Visualization: Waterfall chart or horizontal bar chart​
    • Shows: Count of candidates by recruiting stage (Sourcing, Screening, Interviewing, Offer, etc.)
    • Insight: Identifies bottlenecks in recruiting process

    Metric 4: Requisitions by Age

    • Visualization: Bar chart
    • Shows: Count of open requisitions by age bands (0-30 days, 31-60 days, 61-90 days, 90+ days)
    • Insight: Identifies aging requisitions needing attention

    Metric 5: Time to Fill by Department

    • Visualization: Horizontal bar chart
    • Shows: Average days to fill by department
    • Sorted: Longest to shortest
    • Insight: Identifies departments with recruiting challenges

    Sheet 2: Problem Requisitions

    Metric 6: Requisitions Open Over 90 Days

    • Visualization: Table
    • Shows: Requisition ID, Job, Department, Hiring Manager, Days Open, Recruiter, Candidate Count
    • Purpose: Action list for recruiting leadership

    Usage pattern: VP Talent Acquisition checks Sheet 1 every Monday morning. Recruiting Ops uses Sheet 2 to prioritize aging requisitions.

    Key success factor: Accurate requisition status updates. If recruiters do not update candidate stages promptly, pipeline metrics are meaningless.

    Discovery Board 4: Compensation Analysis Dashboard (CHRO/CFO/Compensation Manager)

    Primary Purpose: Answer “Are we paying competitively and within budget?”

    Sheet 1: Compensation Overview

    Metric 1: Total Compensation Spend

    • Visualization: KPI card
    • Shows: Total annual compensation (base salary + bonuses) with budget comparison
    • Data source: Workers with current compensation

    Metric 2: Average Base Salary

    • Visualization: KPI card
    • Shows: Average base salary across organization with year-over-year comparison
    • Context: Helps track compensation inflation

    Metric 3: Compensation by Department

    • Visualization: Horizontal bar chart
    • Shows: Average compensation by department
    • Insight: Identifies compensation disparities across organization

    Metric 4: Compa-Ratio Distribution

    • Visualization: Bar chart or histogram
    • Shows: Count of workers by compa-ratio bands (Below 0.85, 0.85-0.95, 0.95-1.05, 1.05-1.15, Above 1.15)
    • Insight: Identifies workers paid below or above market range

    Metric 5: Compensation Spend vs Budget

    • Visualization: Waterfall chart showing variance​
    • Shows: Budgeted compensation, actual compensation, variance by category (base, bonus, equity)

    Sheet 2: Compensation Outliers

    Metric 6: Workers Below Market (Compa-Ratio Below 0.85)

    • Visualization: Table
    • Shows: Worker Name, Job, Department, Base Salary, Market Midpoint, Compa-Ratio
    • Purpose: Identifies retention risks

    Metric 7: Workers Above Market (Compa-Ratio Above 1.15)

    • Visualization: Table
    • Shows: Worker Name, Job, Department, Base Salary, Market Midpoint, Compa-Ratio
    • Purpose: Identifies budget optimization opportunities

    Usage pattern: CFO checks Metric 1 and Metric 5 weekly during budget cycles. CHRO checks Metric 4 monthly for equity analysis.

    Key success factor: Accurate job profile to compensation grade mappings. If jobs are not properly mapped to compensation grades, compa-ratio is meaningless.

    Discovery Board 5: Diversity & Inclusion Dashboard (CHRO/Chief Diversity Officer)

    Primary Purpose: Answer “How is our diversity representation changing?”

    Sheet 1: Diversity Overview

    Metric 1: Overall Diversity Representation

    • Visualization: KPI card showing percentage
    • Shows: Percentage of workforce from underrepresented groups with trend indicator
    • Definition: Clearly define what “underrepresented” means for your organization

    Metric 2: Diversity Trend

    • Visualization: Line chart​
    • Shows: Diversity representation percentage over last 24 months
    • Insight: Are we improving or declining?

    Metric 3: Diversity by Department

    • Visualization: Horizontal bar chart
    • Shows: Diversity representation percentage by department
    • Sorted: Lowest to highest (highlights departments needing attention)

    Metric 4: Diversity by Job Level

    • Visualization: Bar chart
    • Shows: Diversity representation by job level (Individual Contributor, Manager, Director, VP, Executive)
    • Insight: Pipeline representation at leadership levels

    Metric 5: Hiring Diversity

    • Visualization: KPI card
    • Shows: Percentage of new hires from underrepresented groups in last 90 days
    • Context: Leading indicator of future representation

    Sheet 2: Diversity Deep Dive

    Metric 6: Pay Equity Analysis

    • Visualization: Scatter plot​
    • Shows: Compensation by gender/ethnicity within same job profile
    • Purpose: Identify potential pay equity issues
    • Note: Use Workday’s delivered Pay Equity Discovery Board template as starting point​

    Usage pattern: Chief Diversity Officer checks Sheet 1 monthly for board reporting. CHRO checks Metric 5 (Hiring Diversity) monthly to validate recruiting effectiveness.

    Key success factor: Data quality and privacy. Diversity data must be accurate and voluntarily provided. Dashboard must comply with privacy regulations in your regions.

    Building Your Discovery Board: Step-by-Step

    Here is the practical implementation process.

    Step 1: Identify the Five Questions (30 minutes)

    Schedule a 30-minute meeting with the executive.

    Ask: “What are the five questions you find yourself asking repeatedly about [headcount/turnover/recruiting/compensation]?”

    Do not ask: “What metrics do you want to see?”

    Do not ask: “What would you like on a dashboard?”

    Ask about questions. Get specific questions. Write them down verbatim.

    If the executive says: “I want to know about turnover,” that is not specific enough.

    Probe: “When you think about turnover, what specific question are you trying to answer? Is it ‘Which departments have the highest turnover?’ or ‘Is turnover increasing or decreasing?’ or something else?”

    Get five specific questions. Write them down. Confirm understanding.

    Step 2: Design on Paper First (15 minutes)

    Do not open Workday yet.

    On paper or whiteboard, sketch how you would answer each of the five questions.

    For each question, choose the simplest visualization that answers it:

    • Status check question: KPI card
    • Trend question: Line chart
    • Problem identification question: Bar chart (sorted, top 5 or top 10)
    • Comparison question: Bar chart or table
    • Deep dive question: Table with filters

    Arrange the five visualizations on your paper. Most important (Question 1) goes top left. Least important (Question 5) goes bottom right.

    Show this sketch to the executive. Get confirmation before building anything.

    Step 3: Build in Workday Drive (60-90 minutes)

    Access Discovery Boards through Workday Drive.​​

    Create new Discovery Board:

    1. Click your profile menu
    2. Select Drive
    3. Click Add New
    4. Select Discovery Board​

    Build Sheet 1:

    1. Name the sheet clearly: “Headcount at a Glance” (not “Sheet 1”)
    2. Add your first visualization (drag data source, choose viz type)
    3. Configure the visualization to answer Question 1 specifically
    4. Repeat for visualizations 2-5
    5. Arrange visualizations to fit on one screen (no scrolling)

    Visualization best practices:

    • Use KPI cards for single numbers​
    • Use horizontal bar charts for rankings​
    • Use line charts for trends over time​
    • Enable drill-by and show details for interactivity​
    • Configure data labels for clarity

    Performance considerations:

    • Limit to 10 vizzes per sheet​
    • Use indexed data sources only​
    • Avoid complex calculations in visualizations
    • Test load time (should load in under 5 seconds)

    Step 4: Configure Security and Sharing

    Discovery Boards use Workday Drive sharing model.​

    Share with executives:

    1. Click Share button​
    2. Add executive as viewer (not editor unless they need to modify)
    3. Consider sharing with security group if multiple executives need access
    4. Discovery Boards respect Workday security model for data access​

    Important: Test security by viewing as the executive’s persona. Ensure they see the data you intend them to see.

    Step 5: Test with Executive (15 minutes)

    Schedule a brief screen share with the executive.

    Walk through the Discovery Board. For each visualization, explicitly state which question it answers.

    Ask: “Does this answer your question [restate their original question]?”

    If yes, move to next visualization.

    If no, ask: “What is missing?” or “What would make this more useful?”

    Take notes. Make adjustments.

    Step 6: Document and Train (30 minutes)

    Create a one-page guide:

    • How to access the Discovery Board (link to Drive location)
    • What each visualization shows
    • When data is refreshed
    • Who to contact with questions

    Send this guide with your initial share of the Discovery Board.

    Step 7: Monitor Adoption (Ongoing)

    Track whether the executive actually uses the Discovery Board:

    • Check view count in Drive (shows how often it is accessed)
    • Ask for feedback after two weeks: “Are you finding the dashboard useful?”
    • Watch for whether the executive still asks for the same data via email (if yes, the dashboard is not meeting their needs)

    If adoption is low, schedule a follow-up to understand why.

    Common Mistakes and How to Fix Them

    Mistake 1: Too Many Visualizations

    Symptom: Executive opens dashboard, looks overwhelmed, closes it.

    Fix: Remove visualizations. You need fewer metrics, not more. Start with three visualizations. Add more only if executive explicitly requests them.

    Mistake 2: Wrong Visualization Type

    Symptom: Executive says “I cannot tell what this is showing me.”

    Fix: Simplify visualization type. KPI cards and bar charts are almost always better than scatter plots, bubble charts, or complex combo charts.

    Mistake 3: No Clear Question Answered

    Symptom: Executive says “This is interesting, but I still need to [pull report/ask assistant for data].”

    Fix: Your dashboard is not answering their actual question. Go back to Step 1. Re-identify the specific question. Rebuild visualization to answer that question directly.

    Mistake 4: Data Does Not Match Other Reports

    Symptom: Executive says “This shows 523 workers, but the HR report shows 541. Which is right?”

    Fix: Document data source and filters explicitly. Add text box on dashboard explaining: “Active workers as of [date], excluding contractors and leave of absence.” Ensure definition matches other reports.

    Mistake 5: Stale Data

    Symptom: Executive makes comment based on dashboard. Gets corrected with newer data in meeting. Stops using dashboard.

    Fix: Document refresh schedule prominently. If data is not real-time, consider whether Discovery Board is right tool or if scheduled report would be better.

    When NOT to Use Discovery Boards

    Discovery Boards are not always the right solution.

    Use traditional reports instead when:

    • Executive needs data exported to Excel for manipulation
    • Executive needs detailed worker-level data (hundreds of rows)
    • Executive needs data that requires complex calculations not supported in Discovery Boards
    • Data security requirements are complex (Discovery Boards inherit Workday security but have limited customization)

    Use Workday Prism Analytics instead when:

    • Data comes from multiple systems (Workday + external data)
    • Historical trend analysis requires years of data
    • Advanced analytics or predictive modeling needed
    • Data volumes exceed Discovery Board performance capabilities​

    Measuring Success

    Track these metrics to evaluate Discovery Board adoption:

    Adoption metrics:

    • View count per week (from Drive analytics)
    • Number of executives actively using (viewed in last 7 days)
    • Reduction in ad-hoc report requests on same topics

    Value metrics:

    • Time saved on manual reporting (hours per week)
    • Executive satisfaction survey (1-10 scale: “Does this dashboard help you make better decisions?”)
    • Decision-making speed (time from question to answer reduced)

    Target benchmarks:

    • 80% of intended executives view dashboard weekly
    • 60% reduction in ad-hoc report requests on dashboard topics
    • Executive satisfaction score 8 or higher (out of 10)

    Conclusion: Less Is More

    The best Discovery Boards are not the most comprehensive. They are not the most visually impressive. They are not the ones that showcase every Discovery Board feature.

    The best Discovery Boards answer five specific questions on one page in 90 seconds.

    Start small. Five metrics. One page. One specific executive.

    Get that working. Get adoption above 80%. Get the executive checking it every Monday morning.

    Then build the next one.

    Your goal is not to build impressive dashboards. Your goal is to build dashboards that get used.

    Tell Me Your Experience

    What Discovery Boards have you built that executives actually use? What made them successful?

    What Discovery Boards did you build that nobody uses? What went wrong?

    Share your experiences in the comments. We learn best from each other’s real-world successes and failures.