HR Metrics & Dashboard Training

Learn to create HR Dashboard and explore powerful analysis on HR data

Training Dashboard + Leave Management + Compensation & Benefits +
Recruitment Dashboard + Survey Data Analysis + Leave Management

Learn
Anytime Anywhere

15 Days

Practical Videos
Step by Step

Building HR Dashboard using Pivot
Calculating Gratuity - End of Service
Training Metrics & Dashboard
Creating & Analyzing Survey Result
Recruitment Dashboard
Compensation and Benefit
Leave Management

Who is this workshop for?

HR Professionals

Training & Development

HR Managers

HR Executive

Recruitment

HR Director

What will you learn in this HR Metrics and Dashboard Workshop?

HR Metrics & Dashboard Course Outline

Day 1 : Calculate Basic HR Metrics with Formulas

Calculate Active & Regisned Employees
Gender Diversity (Female to Male Ratio)
Nationality, Dept & Location wise Analysis
Tenure and Age wise Analysis

Day 2 : Calculate Attrition / Turnover

Year & Month wise Hiring
Attrition / Turnover Percentage
Hiring Cost from different Hiring Modes

Day 3 : Data Visualization

Converting Data into Effective Reports
Creating Charts on Reports
Creating Dashboard Design
Moving Reports to Dashboard

Day 4 : Creating HR Dashboard using Pivot Table

Converting Data to Table Mode
Total Active / Resigned Employee
Gender & Nationality wise Analysis
Department & Location wise Analysis
Tenure & Age wise Analysis
Attrition Percentage
Year & Month wise Hiring
Hiring Cost from different Hiring Mode

Day 5 : Building HR Dashboard using Pivot

You will use all the skills learned into building custom HR Dashboard from Scratch.
(Data set will be provided to complete this Project)

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 : Excel Formulas you should know

Day 13 : HR Reports Queries

Day 14 : Training Dashboard Queries

Day 15 : Practical Assessment & Course Completion Certificate

Activate your exclusive bonuses

Excel Tips & Tricks E-Book

An Excel cheatsheet with shortcuts to simplify your learning and save your time.

AED 50

100+ PowerPoint Infographics

Create stunning presentations easily using premium Infographic Templates

AED 200

Grab Your Bonuses Now! Time is running out!

00Hours
00Minutes
00Seconds

Meet your Trainer

Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI. 17+ years of experience in managing large databases, from requirements gathering through implementation and support. Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback. Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations. Ramzan helps answering business questions using data in creative ways.

Earn your HR Dashboard Certification

Yes, you will receive certification from a Microsoft Certified Trainer, which lends a lot of credibility to your certificate and resume.

You may not believe me, but you can believe them

Experiences shared by people who previously attended this workshop

Still Wondering If the Workshop is for YOU?

Please check all boxes, where your answer is YES!

I have knowledge of Excel, but I am unable to present my data in a beautiful manner.

I want to get better job opportunities but I lack Excel Dashboards knowledge.

I want to be more efficient and faster in using Microsoft Excel & HR Data representation.

I want to learn to create HR and Training Dashboard.

If you checked ANY of the boxes above, then you’re invited to join The Workshop.

Frequently Asked Questions

We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at contact@upgradeskill.ae

I made the payment but didn’t receive any email

Write to us at contact@upgradeskill.ae and our support team will be able to resolve your issue in the shortest amount of time.

Will this be live or pre-recorded?

The workshop is Pre-Recorded so that you can view at your own pace & time, and can repeat the video multiple times for better understanding

How much experience do I need for this workshop?

There is no prior experience required for this workshop.

Can I get a refund?

No. We do not offer refunds in any case. If you are unsure about the workshop, read testimonials, learn more about the trainer, and make an informed decision. If you miss the live workshop, we will move you to the next batch only ONCE.

Will I get a certificate after completion?

Yes, you will receive a certificate of completion from a Microsoft Certified Trainer after completing the workshop.

What is the time zone?

As this are pre-recorded videos, you can view at your own time.