Book
Predictive HR Analytics, Text Mining & Organizational Network Analysis with Excel
by Mong Shen Ng
(Write a Review)
Paperback
$50.00
1) Predictive HR Analytics: Use Excel's Statistical Analysis tools (Decision trees, Correlation, Multiple & Logistic Regression) to run Predictive HR Analytics. You will learn how to predict Ethnic & Gender Diversity's impact on EBIT, predict training's impact on sales revenue, predict employee resignation, predict impact of staff engagement on sales, predict workplace accident, etc.
2) Organizational Network Analysis (ONA): Run ONA using Excel's network analysis tool. Learn how to convert an employee's organizational network into a score & then predict if they will be a high-potential (HiPo). You will also learn how to predict employee performance and resignation with ONA graph metrics. E.g. an employee is predicted to be a HiPo with performance rating of "9", if his "Social Network Score" is "16", "Social Network Diversity Index" is "3" & "Competency Score" is "8".
3) Text Mining, Sentiment Analysis & Word Clouds: Mine text from social network posts, employee engagement surveys & Glassdoor comments, then run Sentiment Analysis using Excel & visualize the insights with "Word Clouds". Learn how to predict a company's average employee attrition rate based on its sentiment. E.g. a company's average employee attrition rate is predicted to be 8%, if unemployment rate is 3%, GDP growth is 2%, Glassdoor public sentiment rating is "5", and engagement score is "7".
1) Predictive HR Analytics: Use Excel's Statistical Analysis tools (Decision trees, Correlation, Multiple & Logistic Regression) to run Predictive HR Analytics. You will learn how to predict Ethnic & Gender Diversity's impact on EBIT, predict training's impact on sales revenue, predict employee resignation, predict impact of staff engagement on sales, predict workplace accident, etc.
2) Organizational Network Analysis (ONA): Run ONA using Excel's network analysis tool. Learn how to convert an employee's organizational network into a score & then predict if they will be a high-potential (HiPo). You will also learn how to predict employee performance and resignation with ONA graph metrics. E.g. an employee is predicted to be a HiPo with performance rating of "9", if his "Social Network Score" is "16", "Social Network Diversity Index" is "3" & "Competency Score" is "8".
3) Text Mining, Sentiment Analysis & Word Clouds: Mine text from social network posts, employee engagement surveys & Glassdoor comments, then run Sentiment Analysis using Excel & visualize the insights with "Word Clouds". Learn how to predict a company's average employee attrition rate based on its sentiment. E.g. a company's average employee attrition rate is predicted to be 8%, if unemployment rate is 3%, GDP growth is 2%, Glassdoor public sentiment rating is "5", and engagement score is "7".
Paperback
$50.00