1.ERP Analytics • Oracle Financial Analytics • Oracle Procurement and Spend Analytics • Oracle Human Resources Analytics • Oracle Supply Chain and Order Management Analytics • Oracle Spend Classification Analytics • Oracle Project Analytics
2.CRM Analytics • Oracle Sales Analytics • Oracle Service Analytics • Oracle Marketing Analytics • Oracle Contact Center Analytics • Oracle Loyalty Analytics • Oracle Price Analytics
3.Industry Applications • Oracle US Federal Financial Analytics
HR Reporting Types of Reports
HR Reporting - Types of HR Reports
Security - LDAP or Alternative.
All reports should be driven off a Position/ Job or Organisation style Hierarchy
Points to take note of - Multiple Subordinates within a Position.
Take Note of Key KPI's - Such Absences level of Visibility - Salary etc.
All Reports should support Date Tracking - Historical Changes
1. Headcount - Reporting - By Department - Team - Other Hierarchy
Headcount - To make sure all the Employees are accounted for and Company headcount is correct within OBIEE
2. Starters - Leavers - Transfers Reporting by Hierarchy drill
Have Visibility over SCD Type 2 (Slowly Changing Dimensions the Flow of employees moving departments / Positions etc, Leaving and starting the company is correct)
3. Gather and store Employee Information within Dimensions
Next Move on to all other HR Related Reporting
4. Absences - Reporting - KPI Reports - Trends / Patterns -Absences -Long Term Absences -Open Ended Absences -SSP / SMP / OSP etc -Holiday Requests - Absence Calendar Style Reporting
5. Diversity Reporting - Ethnic Origin / Disability / Age Reporting > 65 etc...
6. Competency and Training Stats - Employees competency vs Position or Job Competencies
7. Salary Reporting - Under 25k , Over 100k Etc
8. Recruitment – - Conversion percentage from sourcing to