Building Dynamic Interactive Human Resource Dashboards

Using raw HR data, learn how to create HR statistics from your employee list and display on a dynamic dashboard

Last updated 2022-01-10 | 3.8

- Analyse raw data using pivot tables
- pivot charts and slicers to support decision making
- Build interactive dashboards that are not static
- Prepare reports that inform decision making and impact the bottom line

What you'll learn

Analyse raw data using pivot tables

pivot charts and slicers to support decision making

Build interactive dashboards that are not static

Prepare reports that inform decision making and impact the bottom line

* Requirements

* Basic Ms Excel knowledge
* Passion to self-develop

Description

This course is a step by step process of developing a dynamic, interactive HR Dashboard. The uniqueness of this course is that the dashboard you will learn to build is not static BUT dynamic and interactive and on that one dashboard, you can slice and dice your data further to reveal more insights into your raw data. Students will learn how to use inbuilt excel analytical tools like pivot tables, pivot charts and slicers.

Who this course is for:

Human resource professionals
Anyone interested in learning how to create interactive dashboards in Ms Excel

Course content

6 sections • 15 lectures

Introduction 1 lectures

Introduction Preview 01:08

A brief introduction to the course.

Dashboard Fundamentals and Employee list - Dummy data 1 lectures

Dashboard Fundamentals Preview 00:12

The pdf file has information on what a dashboard is and how to plan before you begin to build your dashboard, to ensure it is purposeful to the users.

Excel Pivot Tables 6 lectures

Employee Data Preview 01:40

In this lecture you will learn how to maintain HR data in an excel spreedsheet. You will also learn how to create a formatted table.

Single Statistics Preview 05:24

In this lecture, you will learn how to create pivot tables with single statistics like headcount, gross salary, average salary etc.

Demographics Preview 02:34

In this lecture you will learn how to create pivot tables that show demographics/employee headcount in different employee records like gender, job grades, department, job category, duty station, salary and many more

Multi-dimentional statistics Preview 07:53

In this lecture you will learn how to create multi dimentional statistics forexample may analyse the relationship between many dimentions in one table like gender, headcount, department and salary to understand how these are related and where the gaps may be for action.