This post shares Fusion HCM Analytics sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize FDI content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description: An AI-enabled workforce overview analytics workbook that enables users to ask natural language questions and gain insights into headcount, workforce composition, demographics, talent movements, attrition, and workforce trends.
Application: Fusion HCM Analytics
Fusion Module: Oracle Global HCM
Target Persona: HRBP, Line Manager
Subject Areas: HCM - Workforce Core, HCM - Workforce Overview LSA
Business Use Case/Questions: This Workbook along with the AI Agent can answer business questions like below
- What is the total headcount by country for the current quarter?
- How is employee headcount distributed across business units by gender for year 2025?
- What is the average service years by job family for the current quarter?
- What is the average compa ratio by job function for the current quarter?
- Show Top Performer Headcount by Business Unit Name for the current year?
- What is the employee headcount by gender for the current month?
- Show Contingent Headcount Ratio by Country Name and Worker Category for the current year?
- What is the headcount by job family for the current year?
- Show Average Service Years by Job Family and User Person Type for the previous years?
- How does average service years differ between user person types across job functions in the current month?
- List the top 3 business units with the highest contingent headcount ratio in the current quarter
- How does top performer headcount compare to employee headcount by job family for the current year?
- Are there differences in compa ratio by gender across countries for the current year?
- How has total headcount changed in the past 12 months by business unit?
- Which are the Top 5 job families with employee headcount in the current year?
- List the Top 10 job families by employee headcount in the current year and also provide their average service years?
- List the Top 10 job families by average service years for the current quarter and also provide their employee headcount?
- Show Contingent Headcount by Country and Job Function for the current year?
- Show Top Performer headcount by Business Unit Name for the current year?
- Which are the Top 10 job functions in the current quarter with high compa ratio?
Pre-Requisites: Workforce Management Functional Area must be enabled
Download: Available in the FDI Content Library.
Best Practices:
Be Specific About What You Want
Good Examples:
- How does workforce tenure compare across business units for the current year?
- Show me the contingent headcount ratio over last 12 months by country and job function?
- Show Average Service Years, Compa Ratio, and Top Performer Headcount by Job Family for current year?
- Show Employee Headcount, Contingent Headcount by Country for last 12 months ?
Avoid:
- Tell me about worker history
- Give me the assignment details
- What is the attrition information?
We’d love to get your feedback and business use cases to help build more sample FDI Content
