Deliver Meaningful Analytic Results with Excel ! This practical workshop is based on the Trainer's Best Selling Books

Predictive HR Analytics &

Organizational Network Analysis (ONA) with Excel

Organizational Network Analysis (ONA) is a hot topic and a powerful technique to improve organization effectiveness. VoloMetrix found that the size and amount of a salesperson’s network inside their company is a more important leading indicator of sales, than the time salespeople spend with customers. You don't need to spend months learning R programming, and you don’t need to buy expensive SPSS statistical software. This course teaches you how to use Excel for Predictive HR Analytics and ONA. You will learn how to predict employee performance, predict employee resignation with ONA graph metrics, predict employee’s sales with ONA data, predict Ethnic & Gender Diversity’s impact on EBIT, predict training’s impact on customer service and sales, etc.

Who Should Attend

 

  • Those who can't afford to buy expensive statistical software like SPSS or SAS.

  • Those who can't afford to spend months learning R or Python programming, but need to quickly deliver some analytics results.

  • HRBPs who does analytics as an additional side role.

  • HR people who wants to take their first steps into the analytics world.

  • Data Scientists who are searching for ideas & case studies on what HR issues they can study in their own company to generate improved business results.

  • Most importantly, for those who love to use Excel!

About Your Instructor

 

 

 

Cedric Ng Mong Shen

​​

The trainer, Cedric Ng Mong Shen has more than 20 years Global HR experience (Asia, Americas, Africa, Middle-East) in various Top Fortune 100 US/European/Asian MNCs, covering Technology, Manufacturing, Oil & Gas, Logistics, and Hospitality Service industries. Cedric has a Master’s in Business Administration (MBA) from University of Strathclyde, and a Bachelor in Economics & Sociology from National University of Singapore (NUS). As a HR thought leader, he has published several HR books. His books are rated by customers, and are sold worldwide in markets covering America, Europe, Middle-East, Africa, and Asia.

Learning Objectives

  • Applications of analytics

  • Overview of Analytics tools (Apache Spark, Excel, Minitab, Python, R, SAS, SPSS, SQL, Stata,Tableau)

  • Setup strategically aligned HR dashboard & metrics

  • ARHAT Predictive HR Analytics Framework

  • Strategies for Analytics Projects Quick Wins

  • Statistical analysis with Excel. E.g. Correlation, Multiple Regression, and Logistic Regression.

  • Organizational Network Analysis (ONA). Learn to predict employee resignation with ONA graph metrics, predict employee’s sales with ONA graph metrics, build an ONA survey, visualize ONA with Excel NodeXL, and formulate ONA Interventions.

  • Compensation & Benefits Analytics

  • Performance Analytics. Learn to predict employee performance based on their “Organizational Network Index”, “Competency”, & “Personality Traits”.

  • Diversity and Inclusion Analytics. Learn to predict Ethnic & Gender Diversity’s impact on EBIT.

  • Training & Development Analytics. Learn to predict training’s impact on customer service and sales.

  • Data Visualization Techniques

 

19 - 21 November 2019

Kuala Lumpur

SGD 2,195

14 - 17 January 2020

Bangkok

SGD 2,795

23 - 25 March 2020

Manila

SGD 2,195

Please reload

Schedule

2010 - present

2010 - present

Email us now for more information:

enquiry@hrd-future.com

Key Topics Covered
  • Predictive HR Analytics Framework

  • Strategies for Analytics Projects Quick Wins

  • Statistical Analysis

  • Organizational Network Analysis (ONA)

  • Compensation & Benefits Analytics

  • Performance Analytics

  • Diversity and Inclusion Analytics

  • Training & Development Analytics

  • Data Visualization Techniques

 

HRD Future's Past Event Photos
Testimonials

© 2020 by HRD Future

icon made from www.flaticon.com