Preview HR Analytics in Excel

Getting Started

01 - Introduction to Creation of HR Dashboard and Analytics

02 - Final Data

03 - More on Data

04 - Index Design

05 - Tab Designing

06 - Tab Designing Continues

07 - Employee Frontface

08 - Employee Frontface Continues

09 - Employee Database View

10 - Pivot Data List

11 - Pivot Data List Continues

12 - Change Pivot Table Data Source

13 - MOM Headcount

14 - MOM Attrites and MOM Hires

15 - MOM Attrites and MOM Hires Continues

16 - Departmental and Location Analysis

17 - Departmental and Location Joinees Exits Analysis

18 - Attrition Percentage

19 - Tenure wise Analysis

20 - Employee Demographics

21 - Age wise Analysis

22 - Age wise Analysis

23 - Age wise Analysis Continues

24 - Employee Demo

25 - Quality Circles

26 - Leave Analysis

27 - Leave Analysis Continues

28 - Time Sheet Late Marks Analysis

29 - Evaluate Formula

30 - Full and Final Analysis

31 - More on F and F Analysis

32 - Training Analysis

33 - Employee Compensation Frontface

34 - Employee Compensation Frontface Continues

35 - Payroll and OMS

36 - More on OMS

37 - Job Rating Analysis

38 - Department Salary

39 - Working on Bonus

40 - HR Update

41 - HR Update Continues

42 - HR Update - Recruitment

43 - Conclusion