HRD

HR Analytics – Gleaning People Insights from Data

This workshop is targeted at HR practitioners who would like to build upon their prior knowledge of HR analytics, enhance their capabilities and acquire essential skills in data preparation, data analysis, statistical knowledge, and data visualisation.

2 day in-person or online Classes

Offered in-person & online

Accredited by HRD Future & Course Trainer

Course Introduction

“83% of HR leaders from organisations across Singapore, Malaysia and Hong Kong agree
that HR analytics is helping to build the long-term strategy of their business.” – Chartered Institute of Personnel and Development (CIPD), 2015

Over the past decade, there has been a rise in organizations adopting data analytics as one of the core competencies for growth. This growth was built upon the growing evidence of the value that data analytics creates; specifically, how it augments and improves the decision-making process in organizations. While HR came to analytics a little later in the game, leaders in organizations are recognizing the potential it could hold and hence adoption has also been growing.

While many organizations have embarked on their own HR Analytics journey; however, many have yet to see significant returns on their investments. One of the key factors is the lack of analytics capabilities within the HR team. While organisations may utilise external contractors to jump start their analytics journey or work on specific analytics projects, the potential of HR analytics can only be sustainable if the organisation is able to build such capabilities internally.

Led by Derrick Yuen, an analytics expert who has comprehensive in-depth knowledge of the region, this two-day course is designed to provide a comprehensive hands-on solution to organise, monitor and analyse HR data with the objective of providing tremendous value to organisations. This is done through informing what is going on with employees, explaining the reasons underpinning organisational successes and failures, and guiding future decision making with greater confidence.

This workshop is targeted at HR practitioners who would like to build upon their prior knowledge of HR analytics, enhance their capabilities and acquire essential skills in data preparation, data analysis, statistical knowledge, and data visualisation. The workshop will be delivered through various case studies and interactive hands-on exercises that span across many HR applications (including Talent acquisition, Employee retention, Employee engagement, Talent development etc.), delegates will be able to effectively communicate business value to senior management, and witness how analytics can serve as powerful insights for maximum business impact.

Course Trainer

Derrick consults and leads engagements to help clients liberate their data for analytics, to glean relevant and actionable insights from their data; engagements span across many sectors, functions and regions including Pharmaceutical, FMCG, Government, Human Resources, Finance & F&B across the Asia Pacific region

Key Benefits of Attending

Develop a comprehensive understanding of the end-to-end analytics process applicable to address most HR problems.

Transform data into powerful insights in six simple steps and take away a structured analysis framework for action.

Develop technical skills in data management, data preparation and transformation to optimise the analysis process.

Develop statistical understanding and technical skills to conduct inferential analyses to establish relationships among variables and explain the variables behind people management issues.

Understand the concept of predictive analytics and gain exposure to machine learning tools for predictive analytics.

Practise your data analysis skills on a business case during a facilitated capstone exercise.

Who Should Attend?

  • HR Analysts or Professionals with data management and reporting responsibilities
  • HR Analysts or Professionals who want to develop deeper data visualization skills
  • HR Analysts or Professionals with Analytics responsibilities who want to go beyond descriptive analyses and learn inferential and predictive analytics skills
  • HR Analytics Managers responsible for managing and supervising a team of analysts
  • All other professionals with a keen interest in developing data analytics skills in the HR domain

Detailed Agenda

Applications of Analytics, Artificial Intelligence (AI), Machine Learning and Predictive Analytics

This segment provides a brief overview of the concepts and applications of HR analytics, including the general utilities of analytics, why analytics is important, and the potential of analytics to empower HR professionals to inform, explain and guide decision making.

Transforming Data into Insights in Six Steps

This segment provides a brief overview to the six-steps framework of turning data into insights and decision making. The six steps are:

  1. Problem definition;
  2. Hypotheses development;
  3. Data definition & collection;
  4. Data preparation & analysis;
  5. Results interpretation & insights;
  6. Communication & influence.

Data Management: Preparation and Transformation

This segment focuses on the fourth step of data analytics process, i.e. data preparation and analysis. This is largely a hands-on session with multiple computer-aided exercises on a wide range of HR-related problems including workforce flow analysis, manpower planning, employee opinion surveys, employee engagement, evaluation of training effectiveness & pay discrimination:

  • Data Preparation (with MS Excel):
  • Data transformation
  • Combining multiple data tables (merge and append)
  • Using data model for pivot table calculations
  • Descriptive analysis (with MS Excel):
  • Pivot table calculations
  • Excel functions
  • Workforce flow analysis

Inferential Analysis to Establish Relationships among Variables

This segment focuses on the fourth step of data analytics, i.e. data preparation and analysis. This is largely a hands-on session with multiple computer-aided exercises on a wide range of HR-related problems including workforce flow analysis, manpower planning, employee opinion surveys, employee engagement, evaluation of training effectiveness & pay discrimination:

  • Statistical concepts for HR analyst:
    • Sampling
    • Distribution, central tendency & variation
    • Probability
    • Hypothesis
    • Statistical significance
    • Correlation
    • Multiple factors problem
  • Inferential analysis (with MS Excel):
    • T-Test: Comparison between two groups
      • Comparing evaluation ratings between two groups
      • Comparing training effectiveness between two groups
    • Chi-square test: Analyse the relationship between two non-numerical variables
      • Testing the independence between gender and job level
      • Testing the independence between employee performance and promotion
    • Correlation analysis: Analyse the relationship between two numerical variables
      • Correlations among employee satisfaction variables from a pulse survey
      • Correlations among workforce demographics variables
    • Multiple regression analysis: Analyse and determine significant variables for multifactor problems
      • Driver analysis for time-to-fill in the recruitment process (linear multiple regression)
      • Examine the key factors that affect employee salary (non-linear multiple regression)

o Class exercise: Multiple data analysis exercises with MS Excel
o Inferential analytics beyond MS Excel

Data Visualization

This segment focuses on Step-6 of data analytics. This is largely a hands-on session with multiple computer-aided exercises to enable the delegates to design and build interactive dashboards and infographics with MS Excel

  • Principles of data visualization
  • Design and build interactive data visuals, infographics and dashboard

o Demo: Data visualization tools (e.g. Tableau, PowerBI, Qliksense)
o Class exercise: Multiple data visualization exercises with MS Excel

Capstone Exercise (approximately half day in duration)

In this segment, the participants are required to study the context of a business case and analyse a set of data to address the issues/problems in the business case and recommend solutions. Participants are expected to apply the statistical analysis techniques acquired in this workshop. Each group will take turns to present their analysis and findings. The exercise will be facilitated.

What Others Say About This Course

“If you are planning to become a HR data-driven organisation, this is the course to be inspired. Full marks for the trainer!” – Head of HR Services, Boehringer Ingelheim
“An extremely knowledgeable and hands-on trainer who gave deep insights from his wealth of experience.” – Regional HR Director, Emery Oleochemicals Malaysia
“This course covered the key techniques to analyse data and tips on leveraging Excel to validate data and establish correlation.” – Senior Vice President, Government of Singapore Investment Corporation (GIC)
“This course was well-structured and delivered by an effective trainer. Thumbs up!” – HR Director, SingTel

Request more information

Event Gallery