HR Analytics – A Data Driven Approach

HR Analytics – A data driven approach with microsoft excel

Course Overview

Learn how to effectively use analytics to support your organization’s goals and provide decision-makers with greater insight into workforce-related considerations. Explore how to properly align human capital analytics with business and HR strategies and to leverage data to build and deliver workforce and HR metrics to improve results.

What you will learn

  • Microsoft Excel Overview for HR Professionals
    • How to effectively work with TIME Functions
    • Track expiry of work permits and passports using conditional formatting
    • Identify the oldest employee at a glance using conditional formatting
    • How to profile employees using Pivot Tables
    • Using Advanced Filter to build customer employee lists
    • Create Job Application/Office Templates using Data Validation
    • How to work with names and named ranges
    • Using TEXT functions to swipe names, change cases and clean unaligned data
    • Monitor work hours clocked by employees using Excel custom cell formats
    • Using Macros and VBA to automate excel
    • Using IF & Nested IF functions
    • Demo: Advanced functions used in developing KRA compliant Payroll Models and Payslips
  • Basic concepts and terminology of data and analytics
  • The challenges of dealing with organizational data
  • How to use analytics and visualization software (In this class Advanced Excel tools will be utilized)
  • Connecting, and telling stories with data from across the organization
  • How to build a business case using a data and analytics based approach

Who Should Attend

  1. Mid-level HR professionals with three to seven years of HR experience
  2. HR Specialists looking to gain insight into HR its measurement of outcomes
  3. Professionals who want to learn how HR output supports the business through facts and insight
  4. HR professionals who need a greater understanding of the drivers of business performance
  5. HR professionals who support business leaders

Class Objectives

  1. Prepare HR Professionals to develop and analyze advanced data models
  2. Help HR Professionals to enlarge their scope and breadth on the applications of analytics to obtain insights that are most valuable to the organizations they work with.
  3. Help HR Consultants build confidence and industry standards in delivery of HR analytics solutions adoption
  4. Help HR professionals predict and answer questions on employee attrition, when to cut/hire, articulate on organization’s overall health through surveys and staff appraisals
  5. Teach HR Professionals use available tools such as Excel for data analysis and visualization.

Key Topics

HR Analytics Overview

  • The role of Analytics in HR
  • An overview of HR Regulations and Reporting Requirements
  • Connection Missions or Goals to HR Benchmarks and Metrics
  • Analytics Tools and Techniques for HR Professionals

Analytics Tools and Techniques for HR Professionals

  • Hands-on introduction to People/HR Analytics
  • Key Systems of Record for HR Data
  • Software Tools
  • Excel Quantitative Techniques
  • Excel Visualization
  • Excel Analytic Techniques

Using the Analytics Process Model

  • The Analytics Process Model and Its Phases
  • Applying the Analytics Process Model
  • Demonstrate use of the Analytics Process Model to analyze HR data

Measuring Employee Satisfaction (Class Exercise)

  • Typical/Traditional an modern HR Data Sources
  • Terminologies and Technologies that drive HR Data Analytics
  • Practical Class activity on how to measure employee satisfaction using the American Customer Satisfaction Index (ACSI) Model