HR Analytics Using Excel Dashboard

Acquihiring good people, developing them and then taking steps to retain them is an intricate task. To help them out perform their mundane tasks and analyze data well, dashboards can play a very effective role. Simply gathering data on excel sheets would not be helpful it requires to speak for further decision making. This is when HR analytics comes to aid for aggregating data in a meaningful way. In turn, that lets your business make data driven decisions. In this training we start right from scratch from planning index designing and tab designing to finishing the entire dashboard supported with interactive charts and graphs. This will help you create a powerful analysis for HR data. You will also learn how to create and use Pivot table and charts effectively to arrange and analyze your data.

Module - Course Content

Section : Introduction


 Introduction to Creation of HR Dashboard and Analytics

Section : Data Introduction


 Final Data

 More on Data


Section : Index Design and Tab Designing

 Index Design

 Tab Designing

  Tab Designing Continues


Section : Employee Frontface

 Employee Frontface

 Employee Frontface Continues

 Employee Database View


Section : Pivot Data List

 Pivot Data List

 Pivot Data List Continues

 Change Pivot Table Data Source


Section : MOM Headcount

 MOM Headcount

 MOM Attrites and MOM Hires

 MOM Attrites and MOM Hires Continues


Section : Departmental and Location Analysis


 Departmental and Location Analysis

 Departmental and Location Joinees Exits Analysis

 Attrition Percentage


Section : Tenure wise Analysis


 Tenure wise Analysis

 Employee Demographics

 Age wise Analysis


Section : Age wise Analysis


Age wise Analysis

 Age wise Analysis Continues


Section : Emp Demo and Quality Circles


 Employee Demo

 Quality Circles

 Leave Analysis

 Leave Analysis Continues




Section : Emp Demo and Quality Circles


Employee Demo

Quality Circles

Leave Analysis

Leave Analysis Continues


Section : Time Sheet Late Marks Analysis


Time Sheet Late Marks Analysis

Evaluate Formula


Section : Full and Final Analysis


Full and Final Analysis

More on F and F Analysis


Section : Training Analysis


Training Analysis


Section : Employee Compensation Frontface


Employee Compensation Frontface

Employee Compensation Frontface Continues

Payroll and OMS

More on OMS


Section : Job Rating Analysis


Job Rating Analysis

Department Salary

Working on Bonus


Section : HR Update

HR Update

HR Update Continues

HR Update – Recruitment





What We Offer

                                       Knowasap Unique Features are as follows:

Lifetime Access

Every enrolled student gets lifetime access to the course.

Course Completion Certificate

Every Candidate is awarded with course completion certificate dully signed by course director, Which is “Globally” accepted and shared.

Placement Assistance

If enrolled students needs job assistance.  We will surely extends our help in getting you a job in reputed organization.

Ready to get started?

Our Students Reviews

Our Students working with great companies. We think you should join us in your quest for excellent career.

And 5400 more global companies across all sectors

Enhance your career

Enroll NowContact us