Training Course: Dashboard Modeling for HR Professionals

Master Dashboard Modeling for HR Professionals to turn the data into meaningful information!

REF: HR321495

DATES: 23 - 27 Sep 2024

CITY: Paris (France)

FEE: 4400 £

All Dates & Locations

Introduction 

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

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

 

Training Course Objectives of Dashboard Modeling for HR Professionals

  • Fundamental understanding of data visualization concepts, principles and best practices, and dashboard modeling;
  • Basic analytical approach to mine the people data and gain 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 a dynamic Dashboard

 

Dashboard Modeling for HR Professionals Training Course Outlines

Day 1

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 the report
  • Build a dashboard with the Camera tool
  • Introduce Sparkline
  • Customize Sparkline

Day 2

The 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

Day 3

Data Model for Dashboard

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

Day 4

PivotTable Driven and PowerView Dashboards

  • PivotTable Driven Dashboards
  • PowerView Dashboard
  • Animate Data on Map

Day 5

Interactive Controls

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

Training Course: Dashboard Modeling for HR Professionals

Master Dashboard Modeling for HR Professionals to turn the data into meaningful information!

REF: HR321495

DATES: 23 - 27 Sep 2024

CITY: Paris (France)

FEE: 4400 £

Request a Call?

*
*
*
*
*
BlackBird Training Center