Creating HR Employee Dashboard

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

Recruitment Metrics + Data Visualization + Employee Dashboard +
Training Dashboard + Comp. & Benefits +  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
Get Lifetime access for this workshop in just ₹4999 ₹15,000

Register before November 16, 2024 to unlock bonuses

Who is this workshop for?

HR Professionals
Training & Development
HR Managers
HR Executive
Recruitment
HR Director
Yes I want to Upskill myself in Creating Excel hR Dashboard!
(Book your spot now in just Rs. 4999 15,000 Today)

What will you learn in this HR Dashboard Workshop?

Course Introduction

HR Dashboard

Creating HR Dashboard using Formulas
Total Active & Resigned Employees
Gender Diversity
(Female to Male Ratio)
Nationality wise Analysis
Dept & Location wise
Tenure wise Analysis
Age wise Analysis
Day 1 - HR Metrics

Year & Month wise Hiring
Attrition / Turnover Percentage
Hiring Cost from different Hiring Mode
Day 2

Converting Data into Effective Reports
Creating Charts on Reports
Creating Beautiful Dashboard Design
Moving Reports to Dashboard
Conclusion
Day 3 - Data Visualization

 
Creating HR Dashboard using Pivot
Converting Data to Table Mode
Total Active / Resigned Employee
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 4 - Dashboard with Pivot Table

 
Building HR Dashboard using Pivot
Conclusion
Day 5

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

  • Understanding Training Metrics
  • Building Learning & Development Dashboard
Day 6 - Training Dashboard

  • Creating Survey
  • Analyzing Survey Result 
Day 7 - Survey

 
Calculate Total Hiring Cost
Cost Per Hire
Time to Fill Position
Time to Hire
First Month Turnover Rate
First Year Attrition Rate
Day 8 - Recruitment Metrics

Compensation and Benefit Reports

Day 9 - Compensation and Benefit

Designing Leave Management Dashboard

Day 10 - Leave Management
I Am Ready To Invest In Myself Now!
(Book your spot in just Rs. 4999 15,000 Today)

Register before November 16, 2024 to unlock bonuses

Activate Your Exclusive Bonuses

Excel Tips & Tricks E-Book

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

₹4500

100+ PowerPoint Infographics

Create stunning presentations easily using premium Infographic Templates

₹2000

Grab Your Bonuses Now! Time is running out!

  • 00Hours
  • 00Minutes
  • 00Seconds
Get Lifetime access for this workshop in just ₹4999 ₹15,000

Meet your Trainer

  • Microsoft Excel Specialist
  • Microsoft Certified Trainer
  • Power BI Analyst
  • 55,000+ Students Trained
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.
Get Lifetime access for this workshop in just ₹4999 ₹15,000

Register before November 16, 2024 to unlock bonuses

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.
Get Certified in Excel by Micorsoft Certified Trainer
(Book your spot in Rs. 4999 - 15,000 Today)

You may not believe me, but you can believe them

Experiences shared by people who previously attended this workshop

Get Lifetime access for this workshop in just ₹4999 ₹15,000

Register before November 16, 2024 to unlock bonuses

Still Wondering If the Workshop is for YOU?

Please check all boxes, where your answer is YES!

If you checked ANY of the boxes above, then you’re invited to join HR Metrics and Dashboard Workshop. 

I Am Ready To Invest In Myself Now!
(Book your spot not in just Rs. 4999 - 15,000 Today)

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.in

I made the payment but didn’t receive any email

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

Will this be live or pre-recorded?

Yes, this is Pre-recorded Session, so that you can watch anytime and can repeat the videos.

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?

All are Pre-recorded Videos, you can watch at your time zone, anytime.

Learn to Create HR Metrics Dashboard
(Book your spot in Rs. 4999 - 15,000 Today)