HR Analytics: How To Create An HR Dashboard Using Excel

This course will teach the step by step process of creating an HR Dashboard from raw hr data using Excel.

4.60 (846 reviews)
Udemy
platform
English
language
Human Resources
category
instructor
2,973
students
1 hour
content
Dec 2021
last update
$39.99
regular price

What you will learn

Learn what an HR Dashboard is

Learn how to analyze HR Data Using Excel

Learn how to visualize HR Data in Excel

Learn how to create an HR Dashboard Using Excel

Description

“By visualizing information, we turn it into a landscape that you can explore with your eyes. A sort of information map. And when you’re lost in information, an information map is kind of useful.” – David McCandless


The primary goal of a dashboard is to enable data visualization for decision making. Dashboards display the most important information needed to achieve one or more objectives that fit entirely on a single computer screen, so it can be monitored at a glance.

Dashboards consolidate and arrange numbers and metrics on a single screen. A well-designed dashboard is a remarkable information management tool.

Data dashboards: Collections of tables, charts, maps, and summary statistics that are updated as new data become available.


Dashboards can be;

• Static for a one-time view, or

• Dynamic & interactive showing data changes


Effective Dashboards:

• Should present timely summary data or metrics/KPIs (useful to the user/decision-maker)

• Should inform rather than overwhelm

• Should call attention to unusual metrics/KPIs that require attention or are of interest


Uses of dashboards

• To help management monitor specific aspects of the company’s performance related to their decision-making responsibilities

• For corporate-level managers, daily data dashboards might summarize sales by region, current inventory levels, and other company-wide metrics

• Front-line managers may view dashboards that contain metrics related to staffing levels, local inventory levels, and short-term sales forecasts


An HR Dashboard is a data visualization/visual display of important HR metrics, stats & insights on a single screen. The primary purpose of an HR Dashboard is for decision making by management teams of organizations.

Employers should ascertain what works well for their organizations and what measurements they feel are critical to be displayed on the HR Dashboard.

Examples of What to Display on an HR Dashboard are things that the organization wants to monitor such as:

▪ Workforce Demographics like Gender, Age etc

▪ Employee Tenure/Years in Service

▪ Employee Turnover


This course is aimed to help participants learn how to create an HR Dashboard Using Excel. It is specifically tailored for those people that have little or no experience in processing, analyzing and visualizing HR data.

Content

Introduction

What is An HR Dashboard
Typical Example of An HR Dashboard
Reading Material: Data Visualization and Dashboards

Practical Session 1: Creating A Simple HR Dashboard in Excel

Excel Features for Creating an HR Dashboard
Reading Material: Analyzing HR Data Using PivotTables
Exploring the Employee Data
Creating A Simple HR Dashboard - Part 1
Creating A Simple HR Dashboard - Part 2
Creating A Simple HR Dashboard - Part 3
Creating A Simple HR Dashboard - Part 4
Creating A Simple HR Dashboard - Part 5

Practical Session 2: Creating An Interactive HR Dashboard in Excel

Creating An Interactive HR Dashboard
Creating An Interactive HR Dashboard - Part 1
Creating An Interactive HR Dashboard - Part 2
Creating An Interactive HR Dashboard - Part 3
Creating An Interactive HR Dashboard - Part 4
Creating An Interactive HR Dashboard - Part 5
Creating An Interactive HR Dashboard - Part 6
Creating An Interactive HR Dashboard - Part 7

Screenshots

HR Analytics: How To Create An HR Dashboard Using Excel - Screenshot_01HR Analytics: How To Create An HR Dashboard Using Excel - Screenshot_02HR Analytics: How To Create An HR Dashboard Using Excel - Screenshot_03HR Analytics: How To Create An HR Dashboard Using Excel - Screenshot_04

Reviews

Giacomo
October 11, 2023
Le due parti Dashboard semplice ed interattive sono praticamente identiche solo che che nella seconda vengono aggiunti più grafici e tabelle pivot, ma tutto sommato non danno un valore aggiunto al corso.
Phostina
October 6, 2023
Yes! It was a good experience, as i was able to use this teaching to Implement with my Organisation HR Staff Data and also now have experience on how to create different pivot chart with any data information given! Thank you
Petra
September 6, 2023
Moved a little too quickly when selecting an option or menu item for the first time. I had to pause it or rewind it to see what he was selecting. Otherwise this was a great learning experience and it was easy to work alongside his instruction.
Esther
April 28, 2023
This is an exceptional piece! I recommend it for all HR practitioners, easy to follow and replicate practically as you go.
Hend
April 1, 2023
At first I couldn't understand and nothing was clear But in the end, things started to clear up I hope not to put too many files because it makes a person get lost
Simran
October 8, 2022
VERY EFFECTIVE AND HELPFUL COURSE. SO GLAD THAT I HAVE LEARNED SO MUCH ABOUT DASHBOARD. WILL SURELY DO MORE CERTIFICATIONS FROM UDEMY.
Mohd
October 3, 2022
Actually i should do something like HR Analytics Dashboard by Division and departments, on top of that to create what ever data store in additional raw on spreadsheet, where by the spreadsheet are the data template from someone doing the data entry level. then the dashboard auto change also from the excel. Now these section 2 over 8 i understand.. also know the pivot table fungsion.
Abiodun
May 26, 2022
It was very practical. The instructor did a wonderful job explaining each step. I am glad I took this course as it will assist me in creating dashboards. Well done Segun.
Sritama
May 24, 2022
Yes, it is a good match. The instructor's lecture is quite clear. Only, I wish to see more complex HR dashboards involving training cost or cost per hire/employee turnover.
Vijay
May 15, 2022
Its superb learning with Segun Akiode sir teaches in a very simplifying and interesting manner. Myself waiting for another HR analytics related course from you sir...
Atreyi
May 13, 2022
It's a wonderful learning. Wish it including attrition rate, salary component, and employee salary rating.
Sneha
May 1, 2022
Course was excellent. help me soo much in understanding about the HR Dashboard and how to create it in excel.
Ekata
April 22, 2022
Awesome interactive dashboard. I used this and prepared my own HR dashboard. Thank you so much. This was of great help.
Shiney
March 6, 2022
The course was very interesting. Instructor has explained in a very simple way. Duration was also perfect. Cheers !! Dr.Shiney Chib, Director,DMIMS, Nagpur,India.
Candi
January 10, 2022
Straight to the point and SO valuable. Thank you so much! I have been looking to learn in a quick manner and you've exceeded my expectations. Thank YOU!

Charts

Price

HR Analytics: How To Create An HR Dashboard Using Excel - Price chart

Rating

HR Analytics: How To Create An HR Dashboard Using Excel - Ratings chart

Enrollment distribution

HR Analytics: How To Create An HR Dashboard Using Excel - Distribution chart
4459722
udemy ID
12/24/2021
course created date
12/28/2021
course indexed date
ANUBHAVJAIN
course submited by