Dashboard Modeling for HR Professionals

This course on Dashboard Modeling for HR Professionals will address features of Microsoft Excel to turn the data in a meaningful ways.

To consolidate and analysis personnel talent, you will have an overall picture of your company personnel talent and know-how to plan with your spending next year. This training focus on HR related Dashboard and Report usage.

We live in a world that’s drowning in data. Using this data effectively helps in gaining a competitive advantage. However, it’s no longer sufficient to use a multiple-page spreadsheet to present findings about the data.

There is a need to tell visual data stories that produce important insights.

Dashboard Modeling for HR Professionals

A “DASHBOARD” is a visual display of the most important information needed to achieve one or more objectives, consolidated and arranged on a single screen so the information can be monitored at a glance.

This course is about helping HR professionals in building dashboards on the data available in organizations for analysis; analysis that can really unlock the enormous potential that exists in finding patterns and relationships between key pieces of information held about people and teams.

Key Takeaways

Upon completion of Dashboard Modeling for HR Professionals, participants will be able to:

Create their own Dashboard
Different view of Dashboard
Fundamental understanding of data visualization concepts, principles and best practices, and dashboard modelling;
Basic analytical approach to mine the people data and gaining valuable insights;
Ability to turn plain and uninspiring information into smart, effective visualizations that powerfully convey ideas;
Hands-on experience in building interactive dashboards e.g. Head Count, Training, Performance Indicators, Individual Records and a lot more fun; and
Advance techniques in MS Excel to automate certain tasks, ultimately, saving loads of time. (allowing to go home early)
Import and model data in Excel
Create interactive control for dynamic Dashboard
Enhance inter activities using Slicer and Timeline Slicers

Target Professionals

This course is specifically for HR professionals interested in making effective business communication through data. However, professionals working in any stream who requires to present/analyse the data may also join.

Pre-requisite

This is not an introductory excel course, hence, participants should have sound knowledge of MS Excel.

Dashboard and Report for HR Professional (Excel Level two) prerequisites:

Fundamental Knowledge of Excel Chart
Master in using Microsoft Excel
Function and formula, includes Vlookup, match, offset and choose
Expert in Dynamic Named Range, Data Validation, and Pivot tables

Course Outline

Introduce Excel Dashboard and Report
What are Dashboards and Reports?
Dashboard Design Principles at a Glance
Tabular Report Techniques
Table Design Best Practices
Enhance Report with Custom Number and Conditional Formatting
Use Symbols to enhance report
Build dashboard with Camera tool
Introduce Sparkline
Customize Sparkline

Chart on the Dashboard

Chart for Trending Techniques
Top and Bottom Ranking and Emphasizing
Relationship and Frequency Tracking Histograms
Variance or Performance Chart
Bullet Graphs
Dynamic Labels and Text Formulas

Data Model for Dashboard

Build Data Model
Data Model Best Practices
Internal Data Model Overview
Integrate External Data
Power Query Overview

PivotTable Driven and PowerView Dashboards

PivotTable Driven Dashboards
PowerView Dashboard
Animate Data on Map

Interactive Controls

Introduce Form Controls
Check Boxes for Toggling chart series on/off
Option Buttons for showing views in on chart
Buttons
List Boxes for controlling multiple charts
Combo Box for Changing chart data

Slicer Interactivity

Introduce Slicers
Create Timeline Slicers
Slicers as Form Controls