Monthly Business Review Month 2013

1. Monthly Business ReviewMonth 2013 JOHn DOE Head – Human RESOURCES “The Key is: Listen Closely” JACK WELCH

2. Sample HR Dashboard for MBR (Dummy Data used) Talent Acquisition Group 0% Vendor Hiring in Biz J 0% Vendor Hiring in for Biz X 440 Total Hires • 42 NEW positions closed in Biz Y, across locations. • 56 REPL positions closed in Biz X. • ZERO – Cost Avoidance in Biz Z Hiring. Incl. of Remote Locations. • 3 Mgrs & 5 Asst. Mgrs Recruited for BIZ X in MAR’13. • XYZ position closed, identified and offered in 30 days, reducing the TAT by 60 days. • Campus Hiring for IT. 107 Offered. • 4 IT REPL positions – closed in 4 days, post approval. • All positions closed in Biz J, achieved saturation. MONTH’13 Joiners Specify Each Biz Name

3. Sample HR Dashboard for MBR (Dummy Data used) Onboarding vs Attrition (JAN’13 - MAR’13) Offered vs Joiners vs Attrition M1 Attrition – For MAR’13 NJ’s • Inference • Brief on the data, give an overall explanation in metrics point of view. • Draw your inference and share your insights.

4. Sample HR Dashboard for MBR (Dummy Data used) Headcount vs Attrition (APR’12 – MAR’13) Headcount Attrition Write your inference on the attrition and headcount. Also, try to specify, the BUs, which are having high attrition and vice-versa. 24% Headcount (YoY) 96% YTD 2% Attrition (MoM)

5. Sample HR Dashboard for MBR (Dummy Data used) Retention vs Attrition (YoY) (2001 - 2012) You may attach the associated working file with the presentation, you may do it by going to INSERT TAB > OBJECT > CREATE FROM FILE > DISPLAY AS ICON > OK in MS Powerpoint. It’s a personal preference though, not mandatory.

6. Sample HR Dashboard for MBR (Dummy Data used) Cost Please Note: Associate Referral- includes – Sources: Job Portals & Emp. Referral Direct & Job Portals 100% Cost Avoidance for Business Figures in Crores. Approximated for graphical representation

7. Sample HR Dashboard for MBR (Dummy Data used) Launches & Initiatives (MAR’13) Employee Engagement Programs HRMS Automation Update • Leave Policy Module • Attendance regularization Module • Women’s Day Celebration • HoliCelebrations • “Concept Day“ Policy Roll-Outs • Band/Grade & Level Policy • Leave Policy • Separation Policy • Relocation Policy • Pay Revision Policy

8. HR Dashboards differ w.r.t the Target Audience Attrition Analysis Dashboards HRM Dashboards Headcount by Dept: It is the employee count segregated by the departments, by this we can govern the employees on the basis of their KRA’s and the delegation of the workflow can be done accordingly, with the measure of their individual competency. Dashboards also provide the previous trends of employees and the competency assortment individually hence the right individual is selected for the right job. Payroll Breakdown: payroll is the sum of all financial records of salaries for an employee, wages, bonuses and deductions. In accounting, payroll refers to the amount paid to employees for services they provided during a certain period of time. Under this KPI, NIVIDH Dashboards will keep the track of the payrolls synchronizing on the basis of salary, bonus, overtime and miscellaneous. Metrics Median: This explains the business plan comprising different factors and balancing those factors to view the monitory growth and the cash flow of the organization. The factors covered in the metrics median are Expense factor, Income Factor, Revenue Factor and Earning Factor. HR Scorecard: HR scorecard consist of the divisions, groups and Subgroups consolidated for all the KPI’s and presenting the actual and targeted values and the % variance between them. • Attrition Analysis: Attrition implies to reduction in number of employees through resignation separation. It is major concern for most of companies in the current competitive scenario. It causes lots of expenses such as Recruitment cost, Training development and Administrative cost. • Reasons for leaving (Exit interview): Employee exit interviews monitors employee retention and satisfaction. It is important to understand why an employee leaves and what information we can use to avoid future employee losses. The dashboard represents the analysis of reasons for leaving of employees on the bases of selection of years form combo box. • Attrition rate and tenure: The attrition rate has always been a sensitive issue for all organizations as it increases the expenses for recruitment. The given dashboard shows the historical data analysis related to Attrition Rate and tenure which enables manager to take effective decision to reduce the attrition rates. • Voluntary numbers and Percentage: To provide information on voluntary labor turnover in the company to aid the HR department in strategic decision making. Through quantitative data analysis the research will try to identify areas in the company where voluntary labor turnover is higher than the average. • Net Addition numbers and addition percentage: Represents number of new recruits joined in company on behalf of terminated employees. This Analysis reflects information towards HR department to keep track on recruitment process.

9. HR Dashboards differ w.r.t the Target Audience Compensation Analysis Dashboards Human capital management Dashboards: HrScorecards: It is used to keep track and analyze the factors influencing HR KPIs such revenue/FTE ,Profit/FTE and etc. HR Scorecard has made it possible for HR managers to understand how to align HR strategy with the overall business objectives. It Increases focus on strategy and results.HR Metrics/ FTE (Full time equivalent): To convert part-time staff into FTEs, total numbers of hours worked by part-time employees are divided by the total number of hours in the work year. FTE is a way for the organizations to measure, manage and track term-by-term instructional activity, Enrolment trends and enrolment patterns.Variance Percentage : Variance Percentage is the difference between Last year and Current year KPI factors . It is used to measure the performance of a HR function and analyze business results to better understand market conditions.Continent wise Data analysis: Shows KPIs historical data by Continents. Pie Chart shows the Overall total of HR KPIs and by click on Pie chart shows historical data on bar chart .Leadership Metrics: Show information related to soft skills, the abilities and innate insights born out of experience, and training.  • Compensation Analysis: It is the analysis of the compensation to the employees according to the distinct category and competency, the analysis is comprised of the factors as job function, division, tenure, age, and workforce.Financial Matrices: This KPI will reflect the financial health of the organization globally driven by the employees and other influencing factors. Profit and cost center is analyzed and the allocation of the revenue is done accordingly, dashboards can show the entire financial status in such matrices. Compensation actual versus Budget: This is the area under which budgeted values are compared with the actual ones, this can be used to analyze the growth or the difference in a given period of time.Average compensation by jobs: This KPI for HR represents comparable analysis valuation of overall compensation of the company by jobs. It will help managers for better decision making and planning budget for compensation.Total Compensation by type: This reflects comparable analysis of overall compensation of the company by type such as salary, bonus, basic salary and etc . This is the area which provides ability to managers planning effective compensation budget and try to achieve more benefits.

10. HR Dashboards differ w.r.t the Target Audience Termination Factors Dashboards Want to know more? Say.. hello@jeyaganesh.in • Top Ten Reasons for terminations: Termination of employment is the end of an employee's duration with an employer .This dashboard shows analysis to rectify the major reasons for terminations of employees of a company and provide decision making ability to control the attrition rate.Termination by per job function: It represents top ten reasons for termination department wise such as Finance,IT,HR,Sales, marketing and etc.The pie chart shows percentage of termination for each department while the scorecard shows the trend of terminations based on historical data .Termination by all divisions : It represents top ten reasons for termination Region wise. The pie chart shows percentage of termination for each Region while the scorecard shows the trend of terminations based on historical data. • Facts from: http://www.nividh.com/bi/ondemand/hrm-bi-dashboards.jsp • QlikviewInteractive Demo: http://www.inverra.com/our-demos/#/hr-dashboard-demo-10042 This work is licensed under a  Creative Commons Attribution-NonCommercial-ShareAlike 2.5 India License.