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
Â
Conclusion
Â
Â
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.















