HR Analyzer

HR Analyzer built in as part of HR system

we have built in HR Analyzer for creating new charts using different database cubes. This is not a 3rd party tools, it is pre built in to the system and ready to be use for analyzing.

We have prebuilt cubes and user request customize cube

Data Name Data Description
Performance Goal by Employees Performance Goal by Employees
On Board Count By pivot
Employee Request Comparsion
Request Details by Module
Loan Register Loan Register Query
Employee List Employee List
Provident Fund Statemnet Provident Fund Statement
BankTransfer Advice BankTransfer Advice
Profession Tax and Details Profession Tax and Details
Employee Performance Range Employee Performance Range
Top 10 Competencies with highest gaps This data schema has which competency has more no of employee has gap in any level
Average Performance Rating This Data container performance rating of last year
Master vs Actual Master vs Actual
Gross to Gross Analysis Employee Gross – Gross Report -2
Employee Loan Detail Detail information about employee loan
Loan Summary Report-1 Loan Summary Report-1
Reimbursement Claim Report Reimbursement Claim Report
ProfessionTax Tax and Summary Details
Time to Accept (TTA) Time to Accept (TTA)
Candidate by Source Candidate by Source
Hiring Cycle Time Hiring Cycle Time
Top Performers Top Performers
Employee Voluntary / In- Voluntary Termination Employee Voluntary / In- Voluntary Termination
Employee Volunatary Termination voluntary Termination Rate= sum of employee( EmploymentStatus Not in(Resign,Retirement”)) / sum of employee(EmployeeActiveStatus > 1)*100
Employee Involuntary Termination `Involuntary Termination Rate= sum of employee( EmploymentStatus in(‘Removed’,’Resigned’)) / sum of employee(EmployeeActiveStatus > 1)*100
Employee Course Employee Course
HR Professional to Employes HR Count/ Total Emp
Employee Position Grade Position Grade
Employee Avg Service Year Employee Avg Service Year
Voluntary Termination By Reason Code Voluntary Termination By Reason Code
Employees Eligible for Retirement Employees Eligible for Retirement  in next 5 yrs
Employee Request Employee Request
Billable hours per employee Billable hours per employee

 

Employee Age Sum of Employee Age where EmployeeActiveStatus=1
Employee Group Age Employee Group Age
Employee Service Year Employee Service Year