HR Metrics and Dashboard – Upgrade Skill

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Practice File 1 (Formula Based Dashboard)

1 EmployeeDatabase Formulas Dashboard

Practice File 2 (Pivot Based Dashboard)

2 EmployeeDatabase Pivot Dashboard

Course Content

Expand All

Introduction to HR Metrics & Dashboard Course 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

HR Dashboard Course Introduction

Topics and Practice File for HR Course

Day 1 – Creating HR Dashboard using Formulas 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Calculate Total Active Employees

Gender Diversity (Female to Male Ratio)

Nationality wise Report

Department wise

Location wise Report

Tenure wise Analysis Part 1

Tenure wise Analysis Part 2

Age wise Analysis

Day 2 – Year wise, Calculate Attrition & Hiring Cost 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Year wise Hiring

Attrition / Turnover Rate Calculation

Hiring Cost from different Hiring Modes

Day 3 – Data Visualization: Creating Charts on your Reports 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Creating Column, Line & Pie Charts

Creating Beautiful Dashboard Design

Moving Reports to Dashboard

Day 4 – Creating HR Dashboard using Pivot Table 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Converting Data into Table Mode

Total Active / Resigned Employees

Gender & Nationality wise Analysis

Department & Location wise Analysis

Tenure wise Analysis

Age wise Analysis

Attrition Percentage

Year & Month wise Hiring

Hiring Cost from different Hiring Mode

Day 5 – Creating Chart Based Dashboard with PIVOT 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Creating Chart Based Dashboard with Pivot

HR Dashboard Challenge ! (Assignment)

Day 6 : Training Metrics & Dashboard

Day 7 : Creating & Analyzing Survey Result

Day 8 : Calculating Gratuity – End of Service

Day 9 : Recruitment Dashboard

Day 10 : Compensation and Benefit

Day 11 : Leave Management

Day 12 : Extra Excel Formulas you should know

Day 13 : HR Report Queries

Day 14 : Training Reports Queries

Day 15 : Practical Assessment & Course Completion Certificate

HR Metrics Dashboard

Follow Us

© 2022 Upgrade Skill. All Rights Reserved by Upgrade Skill