“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.
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
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
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:
- Problem definition;
- Hypotheses development;
- Data definition & collection;
- Data preparation & analysis;
- Results interpretation & insights;
- 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:
- Distribution, central tendency & variation
- Statistical significance
- 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)
- T-Test: Comparison between two groups
o Class exercise: Multiple data analysis exercises with MS Excel
o Inferential analytics beyond MS Excel
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.